ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
10,512 rows where deaths = 57 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Georgia 729
- Texas 720
- Missouri 618
- Iowa 600
- Virginia 547
- Indiana 456
- Kentucky 453
- Ohio 426
- Mississippi 406
- Tennessee 340
- Alabama 332
- Louisiana 323
- Arkansas 316
- North Carolina 313
- Illinois 280
- New York 274
- Oklahoma 258
- South Carolina 247
- Minnesota 245
- Michigan 243
- Wisconsin 213
- Nebraska 187
- Colorado 156
- West Virginia 144
- Pennsylvania 142
- Oregon 123
- Washington 122
- Idaho 120
- Kansas 120
- South Dakota 120
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2499734 | 2499734 | 2022-05-13 | Montgomery | Arkansas | 5097 | 1525 | 57 |
2499880 | 2499880 | 2022-05-13 | Teller | Colorado | 8119 | 4897 | 57 |
2500176 | 2500176 | 2022-05-13 | Washington | Idaho | 16087 | 2394 | 57 |
2500691 | 2500691 | 2022-05-13 | Union | Kentucky | 21225 | 4341 | 57 |
2500779 | 2500779 | 2022-05-13 | Washington | Maine | 23029 | 4585 | 57 |
2500937 | 2500937 | 2022-05-13 | Kanabec | Minnesota | 27065 | 3575 | 57 |
2501074 | 2501074 | 2022-05-13 | Yalobusha | Mississippi | 28161 | 4114 | 57 |
2501095 | 2501095 | 2022-05-13 | Cedar | Missouri | 29039 | 2936 | 57 |
2501138 | 2501138 | 2022-05-13 | Madison | Missouri | 29123 | 3622 | 57 |
2501145 | 2501145 | 2022-05-13 | Moniteau | Missouri | 29135 | 3838 | 57 |
2501147 | 2501147 | 2022-05-13 | Montgomery | Missouri | 29139 | 2522 | 57 |
2501585 | 2501585 | 2022-05-13 | Yancey | North Carolina | 37199 | 5353 | 57 |
2501621 | 2501621 | 2022-05-13 | Ramsey | North Dakota | 38071 | 3638 | 57 |
2502114 | 2502114 | 2022-05-13 | Bledsoe | Tennessee | 47007 | 4669 | 57 |
2502667 | 2502667 | 2022-05-13 | Pacific | Washington | 53049 | 3795 | 57 |
2502817 | 2502817 | 2022-05-13 | Goshen | Wyoming | 56015 | 3646 | 57 |
2496476 | 2496476 | 2022-05-12 | Montgomery | Arkansas | 5097 | 1525 | 57 |
2496622 | 2496622 | 2022-05-12 | Teller | Colorado | 8119 | 4894 | 57 |
2496918 | 2496918 | 2022-05-12 | Washington | Idaho | 16087 | 2393 | 57 |
2497433 | 2497433 | 2022-05-12 | Union | Kentucky | 21225 | 4341 | 57 |
2497679 | 2497679 | 2022-05-12 | Kanabec | Minnesota | 27065 | 3573 | 57 |
2497816 | 2497816 | 2022-05-12 | Yalobusha | Mississippi | 28161 | 4114 | 57 |
2497837 | 2497837 | 2022-05-12 | Cedar | Missouri | 29039 | 2932 | 57 |
2497880 | 2497880 | 2022-05-12 | Madison | Missouri | 29123 | 3615 | 57 |
2497887 | 2497887 | 2022-05-12 | Moniteau | Missouri | 29135 | 3832 | 57 |
2497889 | 2497889 | 2022-05-12 | Montgomery | Missouri | 29139 | 2516 | 57 |
2497896 | 2497896 | 2022-05-12 | Ozark | Missouri | 29153 | 1732 | 57 |
2498327 | 2498327 | 2022-05-12 | Yancey | North Carolina | 37199 | 5353 | 57 |
2498363 | 2498363 | 2022-05-12 | Ramsey | North Dakota | 38071 | 3628 | 57 |
2498856 | 2498856 | 2022-05-12 | Bledsoe | Tennessee | 47007 | 4669 | 57 |
2499409 | 2499409 | 2022-05-12 | Pacific | Washington | 53049 | 3792 | 57 |
2499559 | 2499559 | 2022-05-12 | Goshen | Wyoming | 56015 | 3646 | 57 |
2493218 | 2493218 | 2022-05-11 | Montgomery | Arkansas | 5097 | 1525 | 57 |
2493364 | 2493364 | 2022-05-11 | Teller | Colorado | 8119 | 4884 | 57 |
2493660 | 2493660 | 2022-05-11 | Washington | Idaho | 16087 | 2393 | 57 |
2494175 | 2494175 | 2022-05-11 | Union | Kentucky | 21225 | 4341 | 57 |
2494421 | 2494421 | 2022-05-11 | Kanabec | Minnesota | 27065 | 3567 | 57 |
2494558 | 2494558 | 2022-05-11 | Yalobusha | Mississippi | 28161 | 4114 | 57 |
2494579 | 2494579 | 2022-05-11 | Cedar | Missouri | 29039 | 2932 | 57 |
2494622 | 2494622 | 2022-05-11 | Madison | Missouri | 29123 | 3615 | 57 |
2494629 | 2494629 | 2022-05-11 | Moniteau | Missouri | 29135 | 3832 | 57 |
2494631 | 2494631 | 2022-05-11 | Montgomery | Missouri | 29139 | 2516 | 57 |
2494638 | 2494638 | 2022-05-11 | Ozark | Missouri | 29153 | 1732 | 57 |
2495069 | 2495069 | 2022-05-11 | Yancey | North Carolina | 37199 | 5353 | 57 |
2495105 | 2495105 | 2022-05-11 | Ramsey | North Dakota | 38071 | 3628 | 57 |
2495598 | 2495598 | 2022-05-11 | Bledsoe | Tennessee | 47007 | 4669 | 57 |
2496151 | 2496151 | 2022-05-11 | Pacific | Washington | 53049 | 3792 | 57 |
2496301 | 2496301 | 2022-05-11 | Goshen | Wyoming | 56015 | 3646 | 57 |
2489960 | 2489960 | 2022-05-10 | Montgomery | Arkansas | 5097 | 1525 | 57 |
2490106 | 2490106 | 2022-05-10 | Teller | Colorado | 8119 | 4880 | 57 |
2490402 | 2490402 | 2022-05-10 | Washington | Idaho | 16087 | 2392 | 57 |
2490609 | 2490609 | 2022-05-10 | Buena Vista | Iowa | 19021 | 6401 | 57 |
2490917 | 2490917 | 2022-05-10 | Union | Kentucky | 21225 | 4341 | 57 |
2491004 | 2491004 | 2022-05-10 | Waldo | Maine | 23027 | 6399 | 57 |
2491163 | 2491163 | 2022-05-10 | Kanabec | Minnesota | 27065 | 3563 | 57 |
2491300 | 2491300 | 2022-05-10 | Yalobusha | Mississippi | 28161 | 4114 | 57 |
2491321 | 2491321 | 2022-05-10 | Cedar | Missouri | 29039 | 2932 | 57 |
2491364 | 2491364 | 2022-05-10 | Madison | Missouri | 29123 | 3615 | 57 |
2491371 | 2491371 | 2022-05-10 | Moniteau | Missouri | 29135 | 3832 | 57 |
2491373 | 2491373 | 2022-05-10 | Montgomery | Missouri | 29139 | 2516 | 57 |
2491380 | 2491380 | 2022-05-10 | Ozark | Missouri | 29153 | 1732 | 57 |
2491811 | 2491811 | 2022-05-10 | Yancey | North Carolina | 37199 | 5331 | 57 |
2491847 | 2491847 | 2022-05-10 | Ramsey | North Dakota | 38071 | 3628 | 57 |
2492340 | 2492340 | 2022-05-10 | Bledsoe | Tennessee | 47007 | 4664 | 57 |
2492397 | 2492397 | 2022-05-10 | Meigs | Tennessee | 47121 | 3392 | 57 |
2492752 | 2492752 | 2022-05-10 | Buckingham | Virginia | 51029 | 3988 | 57 |
2492893 | 2492893 | 2022-05-10 | Pacific | Washington | 53049 | 3785 | 57 |
2493043 | 2493043 | 2022-05-10 | Goshen | Wyoming | 56015 | 3646 | 57 |
2486703 | 2486703 | 2022-05-09 | Montgomery | Arkansas | 5097 | 1525 | 57 |
2486849 | 2486849 | 2022-05-09 | Teller | Colorado | 8119 | 4878 | 57 |
2487145 | 2487145 | 2022-05-09 | Washington | Idaho | 16087 | 2392 | 57 |
2487352 | 2487352 | 2022-05-09 | Buena Vista | Iowa | 19021 | 6401 | 57 |
2487516 | 2487516 | 2022-05-09 | Pottawatomie | Kansas | 20149 | 5760 | 57 |
2487660 | 2487660 | 2022-05-09 | Union | Kentucky | 21225 | 4341 | 57 |
2487747 | 2487747 | 2022-05-09 | Waldo | Maine | 23027 | 6381 | 57 |
2487906 | 2487906 | 2022-05-09 | Kanabec | Minnesota | 27065 | 3552 | 57 |
2488042 | 2488042 | 2022-05-09 | Yalobusha | Mississippi | 28161 | 4114 | 57 |
2488063 | 2488063 | 2022-05-09 | Cedar | Missouri | 29039 | 2932 | 57 |
2488106 | 2488106 | 2022-05-09 | Madison | Missouri | 29123 | 3615 | 57 |
2488113 | 2488113 | 2022-05-09 | Moniteau | Missouri | 29135 | 3832 | 57 |
2488115 | 2488115 | 2022-05-09 | Montgomery | Missouri | 29139 | 2516 | 57 |
2488122 | 2488122 | 2022-05-09 | Ozark | Missouri | 29153 | 1732 | 57 |
2488553 | 2488553 | 2022-05-09 | Yancey | North Carolina | 37199 | 5331 | 57 |
2488589 | 2488589 | 2022-05-09 | Ramsey | North Dakota | 38071 | 3628 | 57 |
2489082 | 2489082 | 2022-05-09 | Bledsoe | Tennessee | 47007 | 4664 | 57 |
2489139 | 2489139 | 2022-05-09 | Meigs | Tennessee | 47121 | 3392 | 57 |
2489494 | 2489494 | 2022-05-09 | Buckingham | Virginia | 51029 | 3988 | 57 |
2489635 | 2489635 | 2022-05-09 | Pacific | Washington | 53049 | 3785 | 57 |
2489785 | 2489785 | 2022-05-09 | Goshen | Wyoming | 56015 | 3648 | 57 |
2483445 | 2483445 | 2022-05-08 | Montgomery | Arkansas | 5097 | 1525 | 57 |
2483591 | 2483591 | 2022-05-08 | Teller | Colorado | 8119 | 4871 | 57 |
2483887 | 2483887 | 2022-05-08 | Washington | Idaho | 16087 | 2392 | 57 |
2484094 | 2484094 | 2022-05-08 | Buena Vista | Iowa | 19021 | 6401 | 57 |
2484258 | 2484258 | 2022-05-08 | Pottawatomie | Kansas | 20149 | 5760 | 57 |
2484298 | 2484298 | 2022-05-08 | Bourbon | Kentucky | 21017 | 5991 | 57 |
2484402 | 2484402 | 2022-05-08 | Union | Kentucky | 21225 | 4341 | 57 |
2484489 | 2484489 | 2022-05-08 | Waldo | Maine | 23027 | 6368 | 57 |
2484648 | 2484648 | 2022-05-08 | Kanabec | Minnesota | 27065 | 3548 | 57 |
2484785 | 2484785 | 2022-05-08 | Yalobusha | Mississippi | 28161 | 4103 | 57 |
2484806 | 2484806 | 2022-05-08 | Cedar | Missouri | 29039 | 2932 | 57 |
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);