ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
699 rows where deaths = 299 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- North Carolina 89
- Ohio 42
- Georgia 37
- Kansas 35
- Florida 32
- Pennsylvania 31
- Illinois 29
- Alabama 27
- California 26
- Indiana 26
- Texas 26
- Michigan 24
- South Carolina 24
- Tennessee 24
- Colorado 17
- Louisiana 17
- Virginia 16
- Minnesota 15
- Connecticut 14
- Oregon 14
- New Mexico 13
- Kentucky 11
- Mississippi 10
- Utah 10
- Wisconsin 10
- Arizona 9
- Idaho 9
- Missouri 9
- North Dakota 9
- Maryland 7
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2500052 | 2500052 | 2022-05-13 | Laurens | Georgia | 13175 | 13827 | 299 |
2496794 | 2496794 | 2022-05-12 | Laurens | Georgia | 13175 | 13827 | 299 |
2493536 | 2493536 | 2022-05-11 | Laurens | Georgia | 13175 | 13827 | 299 |
2490278 | 2490278 | 2022-05-10 | Laurens | Georgia | 13175 | 13816 | 299 |
2487021 | 2487021 | 2022-05-09 | Laurens | Georgia | 13175 | 13816 | 299 |
2483763 | 2483763 | 2022-05-08 | Laurens | Georgia | 13175 | 13818 | 299 |
2480505 | 2480505 | 2022-05-07 | Laurens | Georgia | 13175 | 13818 | 299 |
2477247 | 2477247 | 2022-05-06 | Laurens | Georgia | 13175 | 13818 | 299 |
2473989 | 2473989 | 2022-05-05 | Laurens | Georgia | 13175 | 13818 | 299 |
2470732 | 2470732 | 2022-05-04 | Laurens | Georgia | 13175 | 13818 | 299 |
2467476 | 2467476 | 2022-05-03 | Laurens | Georgia | 13175 | 13769 | 299 |
2470049 | 2470049 | 2022-05-03 | Spotsylvania | Virginia | 51177 | 27272 | 299 |
2464221 | 2464221 | 2022-05-02 | Laurens | Georgia | 13175 | 13769 | 299 |
2466793 | 2466793 | 2022-05-02 | Spotsylvania | Virginia | 51177 | 27255 | 299 |
2460965 | 2460965 | 2022-05-01 | Laurens | Georgia | 13175 | 13770 | 299 |
2463538 | 2463538 | 2022-05-01 | Spotsylvania | Virginia | 51177 | 27195 | 299 |
2457709 | 2457709 | 2022-04-30 | Laurens | Georgia | 13175 | 13770 | 299 |
2460282 | 2460282 | 2022-04-30 | Spotsylvania | Virginia | 51177 | 27195 | 299 |
2454453 | 2454453 | 2022-04-29 | Laurens | Georgia | 13175 | 13770 | 299 |
2457026 | 2457026 | 2022-04-29 | Spotsylvania | Virginia | 51177 | 27195 | 299 |
2451197 | 2451197 | 2022-04-28 | Laurens | Georgia | 13175 | 13770 | 299 |
2453823 | 2453823 | 2022-04-28 | Whatcom | Washington | 53073 | 38094 | 299 |
2447941 | 2447941 | 2022-04-27 | Laurens | Georgia | 13175 | 13770 | 299 |
2450567 | 2450567 | 2022-04-27 | Whatcom | Washington | 53073 | 38094 | 299 |
2446181 | 2446181 | 2022-04-26 | Nash | North Carolina | 37127 | 26577 | 299 |
2442926 | 2442926 | 2022-04-25 | Nash | North Carolina | 37127 | 26577 | 299 |
2439670 | 2439670 | 2022-04-24 | Nash | North Carolina | 37127 | 26577 | 299 |
2436414 | 2436414 | 2022-04-23 | Nash | North Carolina | 37127 | 26577 | 299 |
2433158 | 2433158 | 2022-04-22 | Nash | North Carolina | 37127 | 26577 | 299 |
2429902 | 2429902 | 2022-04-21 | Nash | North Carolina | 37127 | 26577 | 299 |
2426646 | 2426646 | 2022-04-20 | Nash | North Carolina | 37127 | 26577 | 299 |
2422142 | 2422142 | 2022-04-19 | Floyd | Indiana | 18043 | 18951 | 299 |
2423390 | 2423390 | 2022-04-19 | Nash | North Carolina | 37127 | 26597 | 299 |
2424469 | 2424469 | 2022-04-19 | Suffolk city | Virginia | 51800 | 18744 | 299 |
2418886 | 2418886 | 2022-04-18 | Floyd | Indiana | 18043 | 18951 | 299 |
2420133 | 2420133 | 2022-04-18 | Nash | North Carolina | 37127 | 26597 | 299 |
2421024 | 2421024 | 2022-04-18 | Val Verde | Texas | 48465 | 14332 | 299 |
2421213 | 2421213 | 2022-04-18 | Suffolk city | Virginia | 51800 | 18738 | 299 |
2415630 | 2415630 | 2022-04-17 | Floyd | Indiana | 18043 | 18936 | 299 |
2416878 | 2416878 | 2022-04-17 | Nash | North Carolina | 37127 | 26597 | 299 |
2417768 | 2417768 | 2022-04-17 | Val Verde | Texas | 48465 | 14330 | 299 |
2417957 | 2417957 | 2022-04-17 | Suffolk city | Virginia | 51800 | 18726 | 299 |
2412374 | 2412374 | 2022-04-16 | Floyd | Indiana | 18043 | 18936 | 299 |
2413622 | 2413622 | 2022-04-16 | Nash | North Carolina | 37127 | 26597 | 299 |
2414512 | 2414512 | 2022-04-16 | Val Verde | Texas | 48465 | 14330 | 299 |
2414701 | 2414701 | 2022-04-16 | Suffolk city | Virginia | 51800 | 18726 | 299 |
2409118 | 2409118 | 2022-04-15 | Floyd | Indiana | 18043 | 18936 | 299 |
2410366 | 2410366 | 2022-04-15 | Nash | North Carolina | 37127 | 26597 | 299 |
2411256 | 2411256 | 2022-04-15 | Val Verde | Texas | 48465 | 14330 | 299 |
2411445 | 2411445 | 2022-04-15 | Suffolk city | Virginia | 51800 | 18726 | 299 |
2405862 | 2405862 | 2022-04-14 | Floyd | Indiana | 18043 | 18936 | 299 |
2407110 | 2407110 | 2022-04-14 | Nash | North Carolina | 37127 | 26597 | 299 |
2408000 | 2408000 | 2022-04-14 | Val Verde | Texas | 48465 | 14330 | 299 |
2408189 | 2408189 | 2022-04-14 | Suffolk city | Virginia | 51800 | 18711 | 299 |
2402607 | 2402607 | 2022-04-13 | Floyd | Indiana | 18043 | 18936 | 299 |
2403854 | 2403854 | 2022-04-13 | Nash | North Carolina | 37127 | 26597 | 299 |
2404744 | 2404744 | 2022-04-13 | Val Verde | Texas | 48465 | 14314 | 299 |
2399352 | 2399352 | 2022-04-12 | Floyd | Indiana | 18043 | 18925 | 299 |
2400567 | 2400567 | 2022-04-12 | Durham | North Carolina | 37063 | 72902 | 299 |
2400599 | 2400599 | 2022-04-12 | Nash | North Carolina | 37127 | 26650 | 299 |
2401489 | 2401489 | 2022-04-12 | Val Verde | Texas | 48465 | 14314 | 299 |
2396097 | 2396097 | 2022-04-11 | Floyd | Indiana | 18043 | 18925 | 299 |
2397312 | 2397312 | 2022-04-11 | Durham | North Carolina | 37063 | 72789 | 299 |
2397344 | 2397344 | 2022-04-11 | Nash | North Carolina | 37127 | 26650 | 299 |
2398234 | 2398234 | 2022-04-11 | Val Verde | Texas | 48465 | 14314 | 299 |
2392841 | 2392841 | 2022-04-10 | Floyd | Indiana | 18043 | 18922 | 299 |
2394057 | 2394057 | 2022-04-10 | Durham | North Carolina | 37063 | 72660 | 299 |
2394089 | 2394089 | 2022-04-10 | Nash | North Carolina | 37127 | 26650 | 299 |
2394979 | 2394979 | 2022-04-10 | Val Verde | Texas | 48465 | 14313 | 299 |
2389585 | 2389585 | 2022-04-09 | Floyd | Indiana | 18043 | 18922 | 299 |
2390717 | 2390717 | 2022-04-09 | Chautauqua | New York | 36013 | 23589 | 299 |
2390801 | 2390801 | 2022-04-09 | Durham | North Carolina | 37063 | 72660 | 299 |
2390833 | 2390833 | 2022-04-09 | Nash | North Carolina | 37127 | 26650 | 299 |
2391723 | 2391723 | 2022-04-09 | Val Verde | Texas | 48465 | 14313 | 299 |
2386330 | 2386330 | 2022-04-08 | Floyd | Indiana | 18043 | 18922 | 299 |
2387545 | 2387545 | 2022-04-08 | Durham | North Carolina | 37063 | 72660 | 299 |
2387577 | 2387577 | 2022-04-08 | Nash | North Carolina | 37127 | 26650 | 299 |
2383075 | 2383075 | 2022-04-07 | Floyd | Indiana | 18043 | 18916 | 299 |
2384322 | 2384322 | 2022-04-07 | Nash | North Carolina | 37127 | 26650 | 299 |
2379820 | 2379820 | 2022-04-06 | Floyd | Indiana | 18043 | 18916 | 299 |
2381067 | 2381067 | 2022-04-06 | Nash | North Carolina | 37127 | 26650 | 299 |
2376566 | 2376566 | 2022-04-05 | Floyd | Indiana | 18043 | 18910 | 299 |
2377762 | 2377762 | 2022-04-05 | Caldwell | North Carolina | 37027 | 22183 | 299 |
2373314 | 2373314 | 2022-04-04 | Floyd | Indiana | 18043 | 18910 | 299 |
2374509 | 2374509 | 2022-04-04 | Caldwell | North Carolina | 37027 | 22178 | 299 |
2370061 | 2370061 | 2022-04-03 | Floyd | Indiana | 18043 | 18902 | 299 |
2371257 | 2371257 | 2022-04-03 | Caldwell | North Carolina | 37027 | 22165 | 299 |
2366808 | 2366808 | 2022-04-02 | Floyd | Indiana | 18043 | 18902 | 299 |
2368004 | 2368004 | 2022-04-02 | Caldwell | North Carolina | 37027 | 22165 | 299 |
2363555 | 2363555 | 2022-04-01 | Floyd | Indiana | 18043 | 18902 | 299 |
2364751 | 2364751 | 2022-04-01 | Caldwell | North Carolina | 37027 | 22165 | 299 |
2361497 | 2361497 | 2022-03-31 | Caldwell | North Carolina | 37027 | 22164 | 299 |
2358243 | 2358243 | 2022-03-30 | Caldwell | North Carolina | 37027 | 22159 | 299 |
2354989 | 2354989 | 2022-03-29 | Caldwell | North Carolina | 37027 | 22156 | 299 |
2351736 | 2351736 | 2022-03-28 | Caldwell | North Carolina | 37027 | 22154 | 299 |
2332865 | 2332865 | 2022-03-22 | Hawkins | Tennessee | 47073 | 16585 | 299 |
2329612 | 2329612 | 2022-03-21 | Hawkins | Tennessee | 47073 | 16585 | 299 |
2326360 | 2326360 | 2022-03-20 | Hawkins | Tennessee | 47073 | 16585 | 299 |
2323107 | 2323107 | 2022-03-19 | Hawkins | Tennessee | 47073 | 16585 | 299 |
2319853 | 2319853 | 2022-03-18 | Hawkins | Tennessee | 47073 | 16585 | 299 |
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);