ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
818 rows where deaths = 294 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Pennsylvania 72
- Iowa 68
- Louisiana 49
- Alabama 45
- Ohio 43
- South Carolina 43
- North Carolina 42
- Missouri 41
- Texas 41
- Michigan 39
- Florida 30
- Illinois 25
- Tennessee 24
- Maryland 18
- New Jersey 18
- Georgia 16
- Indiana 16
- Mississippi 16
- Massachusetts 15
- Washington 15
- Connecticut 13
- California 12
- Virginia 12
- Arizona 11
- Wisconsin 11
- Kentucky 10
- Colorado 8
- Idaho 8
- Utah 8
- Minnesota 7
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2499942 | 2499942 | 2022-05-13 | Nassau | Florida | 12089 | 21949 | 294 |
2500699 | 2500699 | 2022-05-13 | Acadia | Louisiana | 22001 | 15906 | 294 |
2501703 | 2501703 | 2022-05-13 | Muskingum | Ohio | 39119 | 25481 | 294 |
2501859 | 2501859 | 2022-05-13 | Carbon | Pennsylvania | 42025 | 16188 | 294 |
2496684 | 2496684 | 2022-05-12 | Nassau | Florida | 12089 | 21949 | 294 |
2497441 | 2497441 | 2022-05-12 | Acadia | Louisiana | 22001 | 15905 | 294 |
2498445 | 2498445 | 2022-05-12 | Muskingum | Ohio | 39119 | 25481 | 294 |
2498601 | 2498601 | 2022-05-12 | Carbon | Pennsylvania | 42025 | 16188 | 294 |
2493426 | 2493426 | 2022-05-11 | Nassau | Florida | 12089 | 21949 | 294 |
2494183 | 2494183 | 2022-05-11 | Acadia | Louisiana | 22001 | 15904 | 294 |
2495187 | 2495187 | 2022-05-11 | Muskingum | Ohio | 39119 | 25414 | 294 |
2495343 | 2495343 | 2022-05-11 | Carbon | Pennsylvania | 42025 | 16188 | 294 |
2496168 | 2496168 | 2022-05-11 | Berkeley | West Virginia | 54003 | 36180 | 294 |
2490629 | 2490629 | 2022-05-10 | Dubuque | Iowa | 19061 | 26176 | 294 |
2490925 | 2490925 | 2022-05-10 | Acadia | Louisiana | 22001 | 15902 | 294 |
2491790 | 2491790 | 2022-05-10 | Rockingham | North Carolina | 37157 | 22106 | 294 |
2491929 | 2491929 | 2022-05-10 | Muskingum | Ohio | 39119 | 25414 | 294 |
2492085 | 2492085 | 2022-05-10 | Carbon | Pennsylvania | 42025 | 16072 | 294 |
2492910 | 2492910 | 2022-05-10 | Berkeley | West Virginia | 54003 | 36107 | 294 |
2487372 | 2487372 | 2022-05-09 | Dubuque | Iowa | 19061 | 26176 | 294 |
2487668 | 2487668 | 2022-05-09 | Acadia | Louisiana | 22001 | 15901 | 294 |
2488532 | 2488532 | 2022-05-09 | Rockingham | North Carolina | 37157 | 22106 | 294 |
2488671 | 2488671 | 2022-05-09 | Muskingum | Ohio | 39119 | 25414 | 294 |
2488827 | 2488827 | 2022-05-09 | Carbon | Pennsylvania | 42025 | 16072 | 294 |
2489652 | 2489652 | 2022-05-09 | Berkeley | West Virginia | 54003 | 36107 | 294 |
2484114 | 2484114 | 2022-05-08 | Dubuque | Iowa | 19061 | 26176 | 294 |
2484410 | 2484410 | 2022-05-08 | Acadia | Louisiana | 22001 | 15900 | 294 |
2485275 | 2485275 | 2022-05-08 | Rockingham | North Carolina | 37157 | 22106 | 294 |
2485414 | 2485414 | 2022-05-08 | Muskingum | Ohio | 39119 | 25414 | 294 |
2485570 | 2485570 | 2022-05-08 | Carbon | Pennsylvania | 42025 | 16072 | 294 |
2480856 | 2480856 | 2022-05-07 | Dubuque | Iowa | 19061 | 26176 | 294 |
2481152 | 2481152 | 2022-05-07 | Acadia | Louisiana | 22001 | 15900 | 294 |
2482017 | 2482017 | 2022-05-07 | Rockingham | North Carolina | 37157 | 22106 | 294 |
2482156 | 2482156 | 2022-05-07 | Muskingum | Ohio | 39119 | 25414 | 294 |
2482312 | 2482312 | 2022-05-07 | Carbon | Pennsylvania | 42025 | 16072 | 294 |
2477598 | 2477598 | 2022-05-06 | Dubuque | Iowa | 19061 | 26176 | 294 |
2477894 | 2477894 | 2022-05-06 | Acadia | Louisiana | 22001 | 15900 | 294 |
2478759 | 2478759 | 2022-05-06 | Rockingham | North Carolina | 37157 | 22106 | 294 |
2478898 | 2478898 | 2022-05-06 | Muskingum | Ohio | 39119 | 25414 | 294 |
2479054 | 2479054 | 2022-05-06 | Carbon | Pennsylvania | 42025 | 16072 | 294 |
2474340 | 2474340 | 2022-05-05 | Dubuque | Iowa | 19061 | 26176 | 294 |
2474636 | 2474636 | 2022-05-05 | Acadia | Louisiana | 22001 | 15896 | 294 |
2475501 | 2475501 | 2022-05-05 | Rockingham | North Carolina | 37157 | 22106 | 294 |
2475640 | 2475640 | 2022-05-05 | Muskingum | Ohio | 39119 | 25414 | 294 |
2475796 | 2475796 | 2022-05-05 | Carbon | Pennsylvania | 42025 | 16072 | 294 |
2471083 | 2471083 | 2022-05-04 | Dubuque | Iowa | 19061 | 26176 | 294 |
2471379 | 2471379 | 2022-05-04 | Acadia | Louisiana | 22001 | 15894 | 294 |
2471857 | 2471857 | 2022-05-04 | St. Francois | Missouri | 29187 | 19070 | 294 |
2472244 | 2472244 | 2022-05-04 | Rockingham | North Carolina | 37157 | 22106 | 294 |
2472539 | 2472539 | 2022-05-04 | Carbon | Pennsylvania | 42025 | 16072 | 294 |
2467827 | 2467827 | 2022-05-03 | Dubuque | Iowa | 19061 | 26053 | 294 |
2468123 | 2468123 | 2022-05-03 | Acadia | Louisiana | 22001 | 15892 | 294 |
2468601 | 2468601 | 2022-05-03 | St. Francois | Missouri | 29187 | 19070 | 294 |
2469283 | 2469283 | 2022-05-03 | Carbon | Pennsylvania | 42025 | 16057 | 294 |
2464572 | 2464572 | 2022-05-02 | Dubuque | Iowa | 19061 | 26053 | 294 |
2464868 | 2464868 | 2022-05-02 | Acadia | Louisiana | 22001 | 15889 | 294 |
2465345 | 2465345 | 2022-05-02 | St. Francois | Missouri | 29187 | 19070 | 294 |
2466027 | 2466027 | 2022-05-02 | Carbon | Pennsylvania | 42025 | 16052 | 294 |
2466196 | 2466196 | 2022-05-02 | Laurens | South Carolina | 45059 | 18632 | 294 |
2461316 | 2461316 | 2022-05-01 | Dubuque | Iowa | 19061 | 26053 | 294 |
2461612 | 2461612 | 2022-05-01 | Acadia | Louisiana | 22001 | 15889 | 294 |
2462090 | 2462090 | 2022-05-01 | St. Francois | Missouri | 29187 | 19070 | 294 |
2462772 | 2462772 | 2022-05-01 | Carbon | Pennsylvania | 42025 | 16043 | 294 |
2462941 | 2462941 | 2022-05-01 | Laurens | South Carolina | 45059 | 18632 | 294 |
2458060 | 2458060 | 2022-04-30 | Dubuque | Iowa | 19061 | 26053 | 294 |
2458356 | 2458356 | 2022-04-30 | Acadia | Louisiana | 22001 | 15889 | 294 |
2458834 | 2458834 | 2022-04-30 | St. Francois | Missouri | 29187 | 19070 | 294 |
2459516 | 2459516 | 2022-04-30 | Carbon | Pennsylvania | 42025 | 16030 | 294 |
2459685 | 2459685 | 2022-04-30 | Laurens | South Carolina | 45059 | 18632 | 294 |
2454804 | 2454804 | 2022-04-29 | Dubuque | Iowa | 19061 | 26053 | 294 |
2455100 | 2455100 | 2022-04-29 | Acadia | Louisiana | 22001 | 15889 | 294 |
2455578 | 2455578 | 2022-04-29 | St. Francois | Missouri | 29187 | 19070 | 294 |
2456260 | 2456260 | 2022-04-29 | Carbon | Pennsylvania | 42025 | 16018 | 294 |
2456429 | 2456429 | 2022-04-29 | Laurens | South Carolina | 45059 | 18632 | 294 |
2451548 | 2451548 | 2022-04-28 | Dubuque | Iowa | 19061 | 26053 | 294 |
2452322 | 2452322 | 2022-04-28 | St. Francois | Missouri | 29187 | 19070 | 294 |
2453004 | 2453004 | 2022-04-28 | Carbon | Pennsylvania | 42025 | 16003 | 294 |
2453173 | 2453173 | 2022-04-28 | Laurens | South Carolina | 45059 | 18632 | 294 |
2448292 | 2448292 | 2022-04-27 | Dubuque | Iowa | 19061 | 26053 | 294 |
2449066 | 2449066 | 2022-04-27 | St. Francois | Missouri | 29187 | 19070 | 294 |
2449748 | 2449748 | 2022-04-27 | Carbon | Pennsylvania | 42025 | 15991 | 294 |
2449917 | 2449917 | 2022-04-27 | Laurens | South Carolina | 45059 | 18617 | 294 |
2445036 | 2445036 | 2022-04-26 | Dubuque | Iowa | 19061 | 25987 | 294 |
2445809 | 2445809 | 2022-04-26 | St. Francois | Missouri | 29187 | 19070 | 294 |
2446491 | 2446491 | 2022-04-26 | Carbon | Pennsylvania | 42025 | 15977 | 294 |
2446660 | 2446660 | 2022-04-26 | Laurens | South Carolina | 45059 | 18617 | 294 |
2441780 | 2441780 | 2022-04-25 | Dubuque | Iowa | 19061 | 25987 | 294 |
2442554 | 2442554 | 2022-04-25 | St. Francois | Missouri | 29187 | 19070 | 294 |
2443236 | 2443236 | 2022-04-25 | Carbon | Pennsylvania | 42025 | 15973 | 294 |
2443405 | 2443405 | 2022-04-25 | Laurens | South Carolina | 45059 | 18617 | 294 |
2438524 | 2438524 | 2022-04-24 | Dubuque | Iowa | 19061 | 25987 | 294 |
2439298 | 2439298 | 2022-04-24 | St. Francois | Missouri | 29187 | 19070 | 294 |
2440149 | 2440149 | 2022-04-24 | Laurens | South Carolina | 45059 | 18617 | 294 |
2435268 | 2435268 | 2022-04-23 | Dubuque | Iowa | 19061 | 25987 | 294 |
2436042 | 2436042 | 2022-04-23 | St. Francois | Missouri | 29187 | 19070 | 294 |
2436893 | 2436893 | 2022-04-23 | Laurens | South Carolina | 45059 | 18617 | 294 |
2432012 | 2432012 | 2022-04-22 | Dubuque | Iowa | 19061 | 25987 | 294 |
2432786 | 2432786 | 2022-04-22 | St. Francois | Missouri | 29187 | 19070 | 294 |
2433468 | 2433468 | 2022-04-22 | Carbon | Pennsylvania | 42025 | 15958 | 294 |
2433637 | 2433637 | 2022-04-22 | Laurens | South Carolina | 45059 | 18617 | 294 |
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);