ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
4,682 rows where deaths = 108 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 428
- Georgia 388
- Tennessee 239
- Mississippi 234
- North Carolina 212
- Indiana 208
- Ohio 198
- Alabama 186
- Michigan 183
- South Carolina 175
- Illinois 173
- Oklahoma 170
- Kentucky 154
- Kansas 142
- Virginia 138
- Louisiana 137
- Missouri 134
- Minnesota 129
- Iowa 106
- Pennsylvania 83
- Oregon 78
- New York 76
- Maryland 66
- Washington 65
- Nebraska 63
- Nevada 60
- Arkansas 57
- Wisconsin 55
- California 53
- Florida 48
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2499620 | 2499620 | 2022-05-13 | Marengo | Alabama | 1091 | 5196 | 108 |
2500319 | 2500319 | 2022-05-13 | Jennings | Indiana | 18079 | 6995 | 108 |
2500665 | 2500665 | 2022-05-13 | Montgomery | Kentucky | 21173 | 8200 | 108 |
2500790 | 2500790 | 2022-05-13 | Dorchester | Maryland | 24019 | 7819 | 108 |
2500874 | 2500874 | 2022-05-13 | Mecosta | Michigan | 26107 | 8784 | 108 |
2500950 | 2500950 | 2022-05-13 | McLeod | Minnesota | 27085 | 10753 | 108 |
2501004 | 2501004 | 2022-05-13 | Clarke | Mississippi | 28023 | 4239 | 108 |
2501161 | 2501161 | 2022-05-13 | Polk | Missouri | 29167 | 8073 | 108 |
2501275 | 2501275 | 2022-05-13 | Dodge | Nebraska | 31053 | 10158 | 108 |
2501765 | 2501765 | 2022-05-13 | Jackson | Oklahoma | 40065 | 6575 | 108 |
2501833 | 2501833 | 2022-05-13 | Malheur | Oregon | 41045 | 8251 | 108 |
2502444 | 2502444 | 2022-05-13 | Waller | Texas | 48473 | 9695 | 108 |
2496362 | 2496362 | 2022-05-12 | Marengo | Alabama | 1091 | 5195 | 108 |
2497061 | 2497061 | 2022-05-12 | Jennings | Indiana | 18079 | 6990 | 108 |
2497407 | 2497407 | 2022-05-12 | Montgomery | Kentucky | 21173 | 8200 | 108 |
2497532 | 2497532 | 2022-05-12 | Dorchester | Maryland | 24019 | 7812 | 108 |
2497616 | 2497616 | 2022-05-12 | Mecosta | Michigan | 26107 | 8784 | 108 |
2497692 | 2497692 | 2022-05-12 | McLeod | Minnesota | 27085 | 10741 | 108 |
2497746 | 2497746 | 2022-05-12 | Clarke | Mississippi | 28023 | 4239 | 108 |
2497903 | 2497903 | 2022-05-12 | Polk | Missouri | 29167 | 8064 | 108 |
2498017 | 2498017 | 2022-05-12 | Dodge | Nebraska | 31053 | 10153 | 108 |
2498507 | 2498507 | 2022-05-12 | Jackson | Oklahoma | 40065 | 6575 | 108 |
2498575 | 2498575 | 2022-05-12 | Malheur | Oregon | 41045 | 8251 | 108 |
2499186 | 2499186 | 2022-05-12 | Waller | Texas | 48473 | 9690 | 108 |
2493104 | 2493104 | 2022-05-11 | Marengo | Alabama | 1091 | 5194 | 108 |
2493803 | 2493803 | 2022-05-11 | Jennings | Indiana | 18079 | 6990 | 108 |
2494149 | 2494149 | 2022-05-11 | Montgomery | Kentucky | 21173 | 8200 | 108 |
2494274 | 2494274 | 2022-05-11 | Dorchester | Maryland | 24019 | 7803 | 108 |
2494358 | 2494358 | 2022-05-11 | Mecosta | Michigan | 26107 | 8784 | 108 |
2494434 | 2494434 | 2022-05-11 | McLeod | Minnesota | 27085 | 10733 | 108 |
2494488 | 2494488 | 2022-05-11 | Clarke | Mississippi | 28023 | 4239 | 108 |
2494645 | 2494645 | 2022-05-11 | Polk | Missouri | 29167 | 8064 | 108 |
2494759 | 2494759 | 2022-05-11 | Dodge | Nebraska | 31053 | 10153 | 108 |
2495317 | 2495317 | 2022-05-11 | Malheur | Oregon | 41045 | 8250 | 108 |
2495928 | 2495928 | 2022-05-11 | Waller | Texas | 48473 | 9683 | 108 |
2489846 | 2489846 | 2022-05-10 | Marengo | Alabama | 1091 | 5193 | 108 |
2490204 | 2490204 | 2022-05-10 | Brantley | Georgia | 13025 | 4166 | 108 |
2490275 | 2490275 | 2022-05-10 | Jones | Georgia | 13169 | 5071 | 108 |
2490545 | 2490545 | 2022-05-10 | Jennings | Indiana | 18079 | 6987 | 108 |
2490891 | 2490891 | 2022-05-10 | Montgomery | Kentucky | 21173 | 8200 | 108 |
2491016 | 2491016 | 2022-05-10 | Dorchester | Maryland | 24019 | 7801 | 108 |
2491176 | 2491176 | 2022-05-10 | McLeod | Minnesota | 27085 | 10725 | 108 |
2491230 | 2491230 | 2022-05-10 | Clarke | Mississippi | 28023 | 4239 | 108 |
2491387 | 2491387 | 2022-05-10 | Polk | Missouri | 29167 | 8064 | 108 |
2491501 | 2491501 | 2022-05-10 | Dodge | Nebraska | 31053 | 10168 | 108 |
2492059 | 2492059 | 2022-05-10 | Malheur | Oregon | 41045 | 8244 | 108 |
2492670 | 2492670 | 2022-05-10 | Waller | Texas | 48473 | 9676 | 108 |
2486589 | 2486589 | 2022-05-09 | Marengo | Alabama | 1091 | 5192 | 108 |
2486947 | 2486947 | 2022-05-09 | Brantley | Georgia | 13025 | 4166 | 108 |
2487018 | 2487018 | 2022-05-09 | Jones | Georgia | 13169 | 5071 | 108 |
2487288 | 2487288 | 2022-05-09 | Jennings | Indiana | 18079 | 6987 | 108 |
2487634 | 2487634 | 2022-05-09 | Montgomery | Kentucky | 21173 | 8200 | 108 |
2487759 | 2487759 | 2022-05-09 | Dorchester | Maryland | 24019 | 7785 | 108 |
2487919 | 2487919 | 2022-05-09 | McLeod | Minnesota | 27085 | 10707 | 108 |
2487973 | 2487973 | 2022-05-09 | Clarke | Mississippi | 28023 | 4239 | 108 |
2488129 | 2488129 | 2022-05-09 | Polk | Missouri | 29167 | 8064 | 108 |
2488243 | 2488243 | 2022-05-09 | Dodge | Nebraska | 31053 | 10168 | 108 |
2488801 | 2488801 | 2022-05-09 | Malheur | Oregon | 41045 | 8240 | 108 |
2489412 | 2489412 | 2022-05-09 | Waller | Texas | 48473 | 9674 | 108 |
2483331 | 2483331 | 2022-05-08 | Marengo | Alabama | 1091 | 5191 | 108 |
2483689 | 2483689 | 2022-05-08 | Brantley | Georgia | 13025 | 4166 | 108 |
2483760 | 2483760 | 2022-05-08 | Jones | Georgia | 13169 | 5072 | 108 |
2484030 | 2484030 | 2022-05-08 | Jennings | Indiana | 18079 | 6974 | 108 |
2484501 | 2484501 | 2022-05-08 | Dorchester | Maryland | 24019 | 7779 | 108 |
2484661 | 2484661 | 2022-05-08 | McLeod | Minnesota | 27085 | 10693 | 108 |
2484715 | 2484715 | 2022-05-08 | Clarke | Mississippi | 28023 | 4233 | 108 |
2484872 | 2484872 | 2022-05-08 | Polk | Missouri | 29167 | 8064 | 108 |
2484986 | 2484986 | 2022-05-08 | Dodge | Nebraska | 31053 | 10151 | 108 |
2485544 | 2485544 | 2022-05-08 | Malheur | Oregon | 41045 | 8240 | 108 |
2486154 | 2486154 | 2022-05-08 | Waller | Texas | 48473 | 9671 | 108 |
2480073 | 2480073 | 2022-05-07 | Marengo | Alabama | 1091 | 5191 | 108 |
2480431 | 2480431 | 2022-05-07 | Brantley | Georgia | 13025 | 4166 | 108 |
2480502 | 2480502 | 2022-05-07 | Jones | Georgia | 13169 | 5072 | 108 |
2480772 | 2480772 | 2022-05-07 | Jennings | Indiana | 18079 | 6974 | 108 |
2481243 | 2481243 | 2022-05-07 | Dorchester | Maryland | 24019 | 7779 | 108 |
2481403 | 2481403 | 2022-05-07 | McLeod | Minnesota | 27085 | 10693 | 108 |
2481457 | 2481457 | 2022-05-07 | Clarke | Mississippi | 28023 | 4233 | 108 |
2481614 | 2481614 | 2022-05-07 | Polk | Missouri | 29167 | 8064 | 108 |
2481728 | 2481728 | 2022-05-07 | Dodge | Nebraska | 31053 | 10151 | 108 |
2482286 | 2482286 | 2022-05-07 | Malheur | Oregon | 41045 | 8240 | 108 |
2482896 | 2482896 | 2022-05-07 | Waller | Texas | 48473 | 9669 | 108 |
2476815 | 2476815 | 2022-05-06 | Marengo | Alabama | 1091 | 5191 | 108 |
2477173 | 2477173 | 2022-05-06 | Brantley | Georgia | 13025 | 4166 | 108 |
2477244 | 2477244 | 2022-05-06 | Jones | Georgia | 13169 | 5072 | 108 |
2477514 | 2477514 | 2022-05-06 | Jennings | Indiana | 18079 | 6974 | 108 |
2477985 | 2477985 | 2022-05-06 | Dorchester | Maryland | 24019 | 7779 | 108 |
2478145 | 2478145 | 2022-05-06 | McLeod | Minnesota | 27085 | 10693 | 108 |
2478199 | 2478199 | 2022-05-06 | Clarke | Mississippi | 28023 | 4233 | 108 |
2478356 | 2478356 | 2022-05-06 | Polk | Missouri | 29167 | 8064 | 108 |
2478470 | 2478470 | 2022-05-06 | Dodge | Nebraska | 31053 | 10151 | 108 |
2479028 | 2479028 | 2022-05-06 | Malheur | Oregon | 41045 | 8240 | 108 |
2479638 | 2479638 | 2022-05-06 | Waller | Texas | 48473 | 9667 | 108 |
2473557 | 2473557 | 2022-05-05 | Marengo | Alabama | 1091 | 5191 | 108 |
2473915 | 2473915 | 2022-05-05 | Brantley | Georgia | 13025 | 4166 | 108 |
2473986 | 2473986 | 2022-05-05 | Jones | Georgia | 13169 | 5072 | 108 |
2474256 | 2474256 | 2022-05-05 | Jennings | Indiana | 18079 | 6974 | 108 |
2474727 | 2474727 | 2022-05-05 | Dorchester | Maryland | 24019 | 7773 | 108 |
2474887 | 2474887 | 2022-05-05 | McLeod | Minnesota | 27085 | 10684 | 108 |
2474941 | 2474941 | 2022-05-05 | Clarke | Mississippi | 28023 | 4233 | 108 |
2475098 | 2475098 | 2022-05-05 | Polk | Missouri | 29167 | 8051 | 108 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [ny_times_us_counties] ( [date] TEXT, [county] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER ); CREATE INDEX [idx_ny_times_us_counties_state] ON [ny_times_us_counties] ([state]); CREATE INDEX [idx_ny_times_us_counties_county] ON [ny_times_us_counties] ([county]); CREATE INDEX [idx_ny_times_us_counties_fips] ON [ny_times_us_counties] ([fips]); CREATE INDEX [idx_ny_times_us_counties_date] ON [ny_times_us_counties] ([date] desc);