Understanding Columns

Columns in VisiData behave much (though not entirely) like they do in spreadsheet programs and statistical computing environments. Getting a solid grasp of them will put you well on your way to mastering VisiData.

Basic column attributes

Every column in VisiData has the following basic properties, all of which can be modified:

  • Name
    • Self explanatory.
  • Width
    • The number of characters the column occupies on the screen.
  • Type
    • The kind of data — text, integer, float, currency, or date — that the column will be interpreted as.

We’ll get to a few other properties later.

How to view all columns and their attributes

To see all the columns in your dataset, press Shift-C. This will open the “Columns Sheet,” which lists each column and its attributes. For the FAA dataset we’ve been using, it should look like this:

 name                width  #| type   | fmtstr   | value              | expr   | aggregators      
 OPERATOR           ‖      20 |        |          | BUSINESS           | 0     #|               ‖   
 ATYPE              ‖      16 |        |          | PA-28              | 1     #|                  
 INCIDENT_DATE      ‖      20 |        |          | 05/22/15 00:00:00  | 2     #|                  
 STATE              ‖       9 |        |          | FL                 | 3     #|                  
 AIRPORT            ‖      20 |        |          | VERO BEACH MUNICIP…| 4     #|                  
 PHASE_OF_FLT       ‖      16 |        |          | APPROACH           | 5     #|                  
 HEIGHT             |        |          |                    | 6     #|                  
 SPEED              |        |          |                    | 7     #|                  
 SPECIES            |        |          | Unknown bird       | 8     #|           
 BIRDS_STRUCK       |        |          | 1                  | 9     #|                  
 EFFECT             |        |          | NONE               | 10    #|                  
 DAMAGE             |        |          | M                  | 11    #|                  
 COST_REPAIRS       |        |          |                    | 12    #|                  
 PERSON             |        |          | Tower              | 13    #|                  
 REMAINS_COLLECTED  |        |          | 0                  | 14    #|                  
 REMARKS            |        |          | N9240F was right b…| 15    #|           
                                                                                                    
                                                                                                    
                                                                                                    
                                                                                                    
                                                                                                    
                                                                                                    
faa-wildlife-strikes_columns|                                                  C        16 columns  

The Columns Sheet is handy for quickly getting a sense of your dataset’s structure. You can navigate the sheet as if it were just another dataset. And just like you can do with a standard data sheet, you can leave this column sheet by pressing q.

Note

The Columns Sheet is one of several “metasheets” in VisiData; the Sheets Sheet from the previous chapter is another example. You’ll encounter a few other metasheets in this tutorial.

How to set column types

Rather than guess at your column’s data types, VisiData assumes that they’re all plain-old text.

If a column of really is just text, then great.

But if that column is a number or date, and you want to do any math-y operations on your column (e.g., sorting, summing, averaging, et cetera), you’ll have to specify its type.

To set a column’s type, navigate over to that column and press one of the following keys:

Keystroke Column type Examples
# Integer 0, -1, 5000000
% Float 0.5, -3.14, 23.45557
$ Currency $4.99, €20, 100 100
@ Date 2018-04-06, April 6, 2018, 04/06/2018
~ Text anything!

When you do so, the corresponding symbol (e.g., $ for currency) will appear in the column’s heading.

For instance, here’s what you should see if you navigate to the wildlife-strike database’s HEIGHT column, and then press # to tell VisiData that the height values are integers:

<STATE   | AIRPORT            | PHASE_OF_FLT   | HEIGHT  #| SPEED   | SPECIES            | BIRDS_S> 
 FL      | VERO BEACH MUNICIP…| APPROACH       |         !|         | Unknown bird       | 1        
 AK      | KENAI MUNICIPAL AR…| APPROACH       |         !|         | Unknown bird       | 1        
 TX      | DAVID WAYNE HOOKS …|                |         !|         | Unknown bird       | 1        
 MO      | LAMBERT-ST LOUIS I…| APPROACH       |         !|         | Unknown bird       | 1        
 FL      | POMPANO BEACH AIRP…| LANDING ROLL   |        0 |         | Unknown bird       | 1        
 VI      | HENRY E ROHLSEN AR…|                |         !|         | Unknown bird       | 1        
 TX      | SAN ANTONIO INTL   | APPROACH       |         !|         | Unknown bird       | 1        
 TX      | LONE STAR EXECUTIV…| DEPARTURE      |         !|         | Unknown bird       | 1        
 FL      | TAMPA INTL         | APPROACH       |     6000 |         | Unknown bird       | 1        
 MO      | LAMBERT-ST LOUIS I…| APPROACH       |         !|         | Owls               | 1        
 FL      | OPA-LOCKA EXECUTIV…| APPROACH       |         !|         | Hawks              | 1        
 CA      | NORMAN Y. MINETA S…|                |         !|         | Gulls              | 1        
 FL      | FORT LAUDERDALE/HO…| APPROACH       |     1500 |         | Unknown bird - sma…| 1        
 AR      | FORT SMITH REGIONA…| CLIMB          |         !|         | Unknown bird - sma…| 1        
 AR      | BILL AND  HILLARY …| LANDING ROLL   |        0 |         | Unknown bird - sma…| 1        
         | UNKNOWN            | En Route       |         !|         | Unknown bird       | 1        
 CA      | METRO OAKLAND INTL |                |         !|         | Unknown bird       | 1        
 UT      | SALT LAKE CITY INTL|                |         !|         | Unknown bird       | 1        
 TX      | GEORGE BUSH INTERC…| CLIMB          |         !|         | Unknown bird       | 1        
 FL      | ORLANDO SANFORD IN…| APPROACH       |         !|         | Unknown bird       | 1        
 IL      | CHICAGO O'HARE INT…| CLIMB          |    12000 |         | Unknown bird       | 1        
 AL      | BIRMINGHAM-SHUTTLE…| LANDING ROLL   |        0 |         | Unknown bird - sma…| 1        
faa-wildlife-strikes|                                                             #     73448 rows  

Note

As you can see above, if a cell cannot be converted into the type you’ve assigned it, VisiData will display ! in the right-side margin of that cell.

How to rename columns

  • Navigate to the column that you want to rename:
 OPERATOR           | ATYPE          | INCIDENT_DATE      | STATE   | AIRPORT            | PHASE_O> 
 BUSINESS           | PA-28          | 05/22/15 00:00:00  | FL      | VERO BEACH MUNICIP…| APPROACH 
 BUSINESS           | BE-1900        | 06/18/15 00:00:00  | AK      | KENAI MUNICIPAL AR…| APPROACH 
  • Press ^, which enters column-name-editing mode (evident by the underscores and change in background highlighting):
 OPERATOR           |ATYPE__________   INCIDENT_DATE      | STATE   | AIRPORT            | PHASE_O> 
 BUSINESS           | PA-28          | 05/22/15 00:00:00  | FL      | VERO BEACH MUNICIP…| APPROACH 
 BUSINESS           | BE-1900        | 06/18/15 00:00:00  | AK      | KENAI MUNICIPAL AR…| APPROACH 
  • Then, type what you want the column to be renamed:
 OPERATOR           |Aircraft_______   INCIDENT_DATE      | STATE   | AIRPORT            | PHASE_O> 
 BUSINESS           | PA-28          | 05/22/15 00:00:00  | FL      | VERO BEACH MUNICIP…| APPROACH 
 BUSINESS           | BE-1900        | 06/18/15 00:00:00  | AK      | KENAI MUNICIPAL AR…| APPROACH 
  • And then press Enter to complete the process:
 OPERATOR           | Aircraft       | INCIDENT_DATE      | STATE   | AIRPORT            | PHASE_O> 
 BUSINESS           | PA-28          | 05/22/15 00:00:00  | FL      | VERO BEACH MUNICIP…| APPROACH 
 BUSINESS           | BE-1900        | 06/18/15 00:00:00  | AK      | KENAI MUNICIPAL AR…| APPROACH 

How to expand, shrink, and remove columns

When you load a dataset, VisiData will try to choose reasonable widths for your columns. You can adjust them in a few ways:

Keystroke(s) Action
_ Expands the width of current column to fit text in all visible rows
g_ Expands the width of all columns to fit text in all visible rows
z_ + n Sets the current column’s width to n characters
- Hides the current column by setting its width to 0
gv Unhides all columns
z- Shrinks the current column’s width in half

Note

What’s the deal with “z”?

Much like with g, you’ll notice that many VisiData commands can be prefixed with z. The effect is typically to narrow or specify the scope of the action; e.g., - hides a column entirely, while z- only shrinks it to half-width.

How to move columns’ positions

Sometimes you want to view a dataset’s columns in a different order than they appear in the dataset. To do that in VisiData, use the following keystrokes:

Keystroke(s) Action
Shift-H Moves column one position to the left
Shift-L Moves column one position to the right

Note

Similarly, you can use Shift-J to move a row down one position, and Shift-K to move a row up one position.

How to designate “key” columns

For any sheet, you can designate any number of columns as “key” columns. They serve two functions:

  • They stay pinned to the left-hand side of the sheet when you scroll horizontally.
  • They get special treatment for certain commands, such as when joining sheets. (More on this later.)

To turn a column into a key column (or vice-versa), navigate to that column and press !.

For example, say we’ve navigated to the AIRPORT column of the FAA dataset. Pressing ! will turn this:

 OPERATOR           | Aircraft       | INCIDENT_DATE      | STATE   | AIRPORT            | PHASE_O> 
 BUSINESS           | PA-28          | 05/22/15 00:00:00  | FL      | VERO BEACH MUNICIP…| APPROACH 
 BUSINESS           | BE-1900        | 06/18/15 00:00:00  | AK      | KENAI MUNICIPAL AR…| APPROACH 
 BUSINESS           | PA-46 MALIBU   | 09/20/15 00:00:00  | TX      | DAVID WAYNE HOOKS …|          
 DELTA AIR LINES    | B-717-200      | 11/07/15 00:00:00  | MO      | LAMBERT-ST LOUIS I…| APPROACH 
 BUSINESS           | BE-90 KING     | 12/17/15 00:00:00  | FL      | POMPANO BEACH AIRP…| LANDING… 
 DELTA AIR LINES    | B-757          | 07/17/15 00:00:00  | VI      | HENRY E ROHLSEN AR…|          
 DELTA AIR LINES    | B-717-200      | 08/02/15 00:00:00  | TX      | SAN ANTONIO INTL   | APPROACH 
 BUSINESS           | C-414          | 08/03/15 00:00:00  | TX      | LONE STAR EXECUTIV…| DEPARTU… 
 ALLEGIANT AIR      | MD-80          | 09/02/15 00:00:00  | FL      | TAMPA INTL         | APPROACH 
 TRANS STATES AIRLI…| EMB-145        | 09/07/15 00:00:00  | MO      | LAMBERT-ST LOUIS I…| APPROACH 
 BUSINESS           | C-172          | 11/28/15 00:00:00  | FL      | OPA-LOCKA EXECUTIV…| APPROACH 
 GOVERNMENT         | EC120          | 12/08/15 00:00:00  | CA      | NORMAN Y. MINETA S…|          
 AMERICAN AIRLINES  | A-321          | 05/06/15 00:00:00  | FL      | FORT LAUDERDALE/HO…| APPROACH 
 EXPRESSJET AIRLINES| CRJ100/200     | 05/06/15 00:00:00  | AR      | FORT SMITH REGIONA…| CLIMB    
 MESA AIRLINES      | CRJ900         | 05/08/15 00:00:00  | AR      | BILL AND  HILLARY …| LANDING… 
 BUSINESS           | HELICOPTER     | 05/06/15 00:00:00  |         | UNKNOWN            | En Route 
 DELTA AIR LINES    | A-320          | 05/07/15 00:00:00  | CA      | METRO OAKLAND INTL |          
 DELTA AIR LINES    | A-320          | 05/08/15 00:00:00  | UT      | SALT LAKE CITY INTL|          
 LUFTHANSA          | A-380          | 05/10/15 00:00:00  | TX      | GEORGE BUSH INTERC…| CLIMB    
 BUSINESS           | C-172          | 05/08/15 00:00:00  | FL      | ORLANDO SANFORD IN…| APPROACH 
 SPIRIT AIRLINES    | A-319          | 05/10/15 00:00:00  | IL      | CHICAGO O'HARE INT…| CLIMB    
 EXPRESSJET AIRLINES| EMB-145        | 05/11/15 00:00:00  | AL      | BIRMINGHAM-SHUTTLE…| LANDING… 
faa-wildlife-strikes| "AIRPORT"                                                   c     73448 rows  

… into this:

 AIRPORT             OPERATOR           | Aircraft       | INCIDENT_DATE      | STATE   | PHASE_O> 
 VERO BEACH MUNICIP…‖ BUSINESS           | PA-28          | 05/22/15 00:00:00  | FL      | APPROACH 
 KENAI MUNICIPAL AR…‖ BUSINESS           | BE-1900        | 06/18/15 00:00:00  | AK      | APPROACH 
 DAVID WAYNE HOOKS …‖ BUSINESS           | PA-46 MALIBU   | 09/20/15 00:00:00  | TX      |          
 LAMBERT-ST LOUIS I…‖ DELTA AIR LINES    | B-717-200      | 11/07/15 00:00:00  | MO      | APPROACH 
 POMPANO BEACH AIRP…‖ BUSINESS           | BE-90 KING     | 12/17/15 00:00:00  | FL      | LANDING… 
 HENRY E ROHLSEN AR…‖ DELTA AIR LINES    | B-757          | 07/17/15 00:00:00  | VI      |          
 SAN ANTONIO INTL   ‖ DELTA AIR LINES    | B-717-200      | 08/02/15 00:00:00  | TX      | APPROACH 
 LONE STAR EXECUTIV…‖ BUSINESS           | C-414          | 08/03/15 00:00:00  | TX      | DEPARTU… 
 TAMPA INTL         ‖ ALLEGIANT AIR      | MD-80          | 09/02/15 00:00:00  | FL      | APPROACH 
 LAMBERT-ST LOUIS I…‖ TRANS STATES AIRLI…| EMB-145        | 09/07/15 00:00:00  | MO      | APPROACH 
 OPA-LOCKA EXECUTIV…‖ BUSINESS           | C-172          | 11/28/15 00:00:00  | FL      | APPROACH 
 NORMAN Y. MINETA S…‖ GOVERNMENT         | EC120          | 12/08/15 00:00:00  | CA      |          
 FORT LAUDERDALE/HO…‖ AMERICAN AIRLINES  | A-321          | 05/06/15 00:00:00  | FL      | APPROACH 
 FORT SMITH REGIONA…‖ EXPRESSJET AIRLINES| CRJ100/200     | 05/06/15 00:00:00  | AR      | CLIMB    
 BILL AND  HILLARY …‖ MESA AIRLINES      | CRJ900         | 05/08/15 00:00:00  | AR      | LANDING… 
 UNKNOWN            ‖ BUSINESS           | HELICOPTER     | 05/06/15 00:00:00  |         | En Route 
 METRO OAKLAND INTL ‖ DELTA AIR LINES    | A-320          | 05/07/15 00:00:00  | CA      |          
 SALT LAKE CITY INTL‖ DELTA AIR LINES    | A-320          | 05/08/15 00:00:00  | UT      |          
 GEORGE BUSH INTERC…‖ LUFTHANSA          | A-380          | 05/10/15 00:00:00  | TX      | CLIMB    
 ORLANDO SANFORD IN…‖ BUSINESS           | C-172          | 05/08/15 00:00:00  | FL      | APPROACH 
 CHICAGO O'HARE INT…‖ SPIRIT AIRLINES    | A-319          | 05/10/15 00:00:00  | IL      | CLIMB    
 BIRMINGHAM-SHUTTLE…‖ EXPRESSJET AIRLINES| EMB-145        | 05/11/15 00:00:00  | AL      | LANDING… 
faa-wildlife-strikes|                                                             !     73448 rows  

Manipulating columns from the Columns Sheet

You can do nearly all of the above from the Columns Sheet (Shift-C). When you’re dealing with datasets with a particularly large number of columns, doing it this way can often be easier; you can see more of the columns at once, and you can adjust multiple columns at once.

  • Moving columns: In the Columns Sheet, each column is represented as a row; you can reposition them using Shift-J and Shift-K.
  • Editing column names: In the Columns Sheet, you can edit each column’s name like you would any other row cell. Just navigate to the name, and press e to start editing.
  • Setting column types: You can select multiple rows of the Columns Sheet and type g$, for example, to set all of the selected columns’ types to currency.
  • Setting column widths: You can edit the width field of the Columns Sheet to adjust any column’s width. You can also give multiple columns to the same width by selecting each of their rows, and typing ge + number, where number is the desired width.

For instance, here’s the Columns Sheet for the FAA dataset before we’ve made any changes:

 name                width  #| type   | fmtstr   | value              | expr   | aggregators      
 OPERATOR           ‖      20 |        |          | BUSINESS           | 0     #|               ‖   
 ATYPE              ‖      16 |        |          | PA-28              | 1     #|                  
 INCIDENT_DATE      ‖      20 |        |          | 05/22/15 00:00:00  | 2     #|                  
 STATE              ‖       9 |        |          | FL                 | 3     #|                  
 AIRPORT            ‖      20 |        |          | VERO BEACH MUNICIP…| 4     #|                  
 PHASE_OF_FLT       ‖      16 |        |          | APPROACH           | 5     #|                  
 HEIGHT             |        |          |                    | 6     #|                  
 SPEED              |        |          |                    | 7     #|                  
 SPECIES            |        |          | Unknown bird       | 8     #|           
 BIRDS_STRUCK       |        |          | 1                  | 9     #|                  
 EFFECT             |        |          | NONE               | 10    #|                  
 DAMAGE             |        |          | M                  | 11    #|                  
 COST_REPAIRS       |        |          |                    | 12    #|                  
 PERSON             |        |          | Tower              | 13    #|                  
 REMAINS_COLLECTED  |        |          | 0                  | 14    #|                  
 REMARKS            |        |          | N9240F was right b…| 15    #|           
                                                                                                    
                                                                                                    
                                                                                                    
                                                                                                    
                                                                                                    
                                                                                                    
faa-wildlife-strikes_columns|                                                  C        16 columns  

Next, we use the s key to select the four columns we’d like to change:

 name                width  #| type   | fmtstr   | value              | expr   | aggregators      
 OPERATOR           ‖      20 |        |          | BUSINESS           | 0     #|                  
 ATYPE              ‖      16 |        |          | PA-28              | 1     #|                  
 INCIDENT_DATE      ‖      20 |        |          | 05/22/15 00:00:00  | 2     #|                  
 STATE              ‖       9 |        |          | FL                 | 3     #|                  
 AIRPORT            ‖      20 |        |          | VERO BEACH MUNICIP…| 4     #|                  
 PHASE_OF_FLT       ‖      16 |        |          | APPROACH           | 5     #|                  
 HEIGHT             |        |          |                    | 6     #|                  
 SPEED              |        |          |                    | 7     #|                  
 SPECIES            |        |          | Unknown bird       | 8     #|                  
 BIRDS_STRUCK       |        |          | 1                  | 9     #|                  
 EFFECT             |        |          | NONE               | 10    #|                  
 DAMAGE             |        |          | M                  | 11    #|                  
 COST_REPAIRS       |        |          |                    | 12    #|                  
 PERSON             |        |          | Tower              | 13    #|               ‖   
 REMAINS_COLLECTED  |        |          | 0                  | 14    #|                  
 REMARKS            |        |          | N9240F was right b…| 15    #|           
                                                                                                    
                                                                                                    
                                                                                                    
                                                                                                    
                                                                                                    
                                                                                                    
faa-wildlife-strikes_columns| selected 1 more columns                          s        16 columns  

We’d like to make them all numeric columns, so we type g#, which results in this:

 name                width  #| type   | fmtstr   | value              | expr   | aggregators      
 OPERATOR           ‖      20 |        |          | BUSINESS           | 0     #|                  
 ATYPE              ‖      16 |        |          | PA-28              | 1     #|                  
 INCIDENT_DATE      ‖      20 |        |          | 05/22/15 00:00:00  | 2     #|                  
 STATE              ‖       9 |        |          | FL                 | 3     #|                  
 AIRPORT            ‖      20 |        |          | VERO BEACH MUNICIP…| 4     #|                  
 PHASE_OF_FLT       ‖      16 |        |          | APPROACH           | 5     #|                  
 HEIGHT             | int    | {:.0f}   |                    | 6     #|                  
 SPEED              | int    | {:.0f}   |                    | 7     #|                  
 SPECIES            |        |          | Unknown bird       | 8     #|                  
 BIRDS_STRUCK       | int    | {:.0f}   | 1                  | 9     #|                  
 EFFECT             |        |          | NONE               | 10    #|                  
 DAMAGE             |        |          | M                  | 11    #|                  
 COST_REPAIRS       | int    | {:.0f}   |                    | 12    #|                  
 PERSON             |        |          | Tower              | 13    #|               ‖   
 REMAINS_COLLECTED  |        |          | 0                  | 14    #|                  
 REMARKS            |        |          | N9240F was right b…| 15    #|           
                                                                                                    
                                                                                                    
                                                                                                    
                                                                                                    
                                                                                                    
                                                                                                    
faa-wildlife-strikes_columns|                                                 g#        16 columns  

And we’d like to make them uniformly narrow, so we navigate to the width column and type ge8 + Enter, which gives us this:

 name                width  #| type   | fmtstr   | value              | expr   | aggregators      
 OPERATOR                 20 |        |          | BUSINESS           | 0     #|                  
 ATYPE                    16 |        |          | PA-28              | 1     #|                  
 INCIDENT_DATE            20 |        |          | 05/22/15 00:00:00  | 2     #|                  
 STATE                     9 |        |          | FL                 | 3     #|                  
 AIRPORT                  20 |        |          | VERO BEACH MUNICIP…| 4     #|                  
 PHASE_OF_FLT             16 |        |          | APPROACH           | 5     #|                  
 HEIGHT             ‖       8 | int    | {:.0f}   |                    | 6     #|                  
 SPEED                     8 | int    | {:.0f}   |                    | 7     #|                  
 SPECIES                    |        |          | Unknown bird       | 8     #|                  
 BIRDS_STRUCK       ‖       8 | int    | {:.0f}   | 1                  | 9     #|                  
 EFFECT                     |        |          | NONE               | 10    #|                  
 DAMAGE                     |        |          | M                  | 11    #|                  
 COST_REPAIRS       ‖       8 | int    | {:.0f}   |                    | 12    #|                  
 PERSON                     |        |          | Tower              | 13    #|               ‖   
 REMAINS_COLLECTED          |        |          | 0                  | 14    #|                  
 REMARKS                    |        |          | N9240F was right b…| 15    #|           
                                                                                                    
                                                                                                    
                                                                                                    
                                                                                                    
                                                                                                    
                                                                                                    
faa-wildlife-strikes_columns| "8" | set 4 cells to 1 values                   ge        16 columns  

To see how these changes have affected your data sheet, press q to exit the Columns Sheet, and then navigate over to the HEIGHT column:

<STATE   | AIRPORT            | PHASE_OF_FLT   | HEIGHT#| SPEED #| SPECIES            | BIRDS_#| E> 
 FL      | VERO BEACH MUNICIP…| APPROACH       |       !|       !| Unknown bird       |      1 | N… 
 AK      | KENAI MUNICIPAL AR…| APPROACH       |       !|       !| Unknown bird       |      1 | N… 
 TX      | DAVID WAYNE HOOKS …|                |       !|       !| Unknown bird       |      1 | N… 
 MO      | LAMBERT-ST LOUIS I…| APPROACH       |       !|       !| Unknown bird       |      1 | N… 
 FL      | POMPANO BEACH AIRP…| LANDING ROLL   |      0 |       !| Unknown bird       |      1 |    
 VI      | HENRY E ROHLSEN AR…|                |       !|       !| Unknown bird       |      1 | O… 
 TX      | SAN ANTONIO INTL   | APPROACH       |       !|       !| Unknown bird       |      1 | N… 
 TX      | LONE STAR EXECUTIV…| DEPARTURE      |       !|       !| Unknown bird       |      1 | P… 
 FL      | TAMPA INTL         | APPROACH       |   6000 |       !| Unknown bird       |      1 | N… 
 MO      | LAMBERT-ST LOUIS I…| APPROACH       |       !|       !| Owls               |      1 | N… 
 FL      | OPA-LOCKA EXECUTIV…| APPROACH       |       !|       !| Hawks              |      1 | N… 
 CA      | NORMAN Y. MINETA S…|                |       !|       !| Gulls              |      1 | N… 
 FL      | FORT LAUDERDALE/HO…| APPROACH       |   1500 |       !| Unknown bird - sma…|      1 | N… 
 AR      | FORT SMITH REGIONA…| CLIMB          |       !|       !| Unknown bird - sma…|      1 | N… 
 AR      | BILL AND  HILLARY …| LANDING ROLL   |      0 |       !| Unknown bird - sma…|      1 | N… 
         | UNKNOWN            | En Route       |       !|       !| Unknown bird       |      1 | P… 
 CA      | METRO OAKLAND INTL |                |       !|       !| Unknown bird       |      1 | N… 
 UT      | SALT LAKE CITY INTL|                |       !|       !| Unknown bird       |      1 | N… 
 TX      | GEORGE BUSH INTERC…| CLIMB          |       !|       !| Unknown bird       |      1 | N… 
 FL      | ORLANDO SANFORD IN…| APPROACH       |       !|       !| Unknown bird       |      1 | N… 
 IL      | CHICAGO O'HARE INT…| CLIMB          |  12000 |       !| Unknown bird       |      1 | P… 
 AL      | BIRMINGHAM-SHUTTLE…| LANDING ROLL   |      0 |       !| Unknown bird - sma…|      1 | N… 
faa-wildlife-strikes|                                                             h     73448 rows