ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
634 rows where deaths = 354 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 81
- California 77
- Ohio 43
- Pennsylvania 43
- Illinois 42
- Georgia 40
- Michigan 40
- Louisiana 24
- Indiana 22
- North Carolina 17
- Alabama 16
- New York 16
- Massachusetts 15
- Virginia 15
- Tennessee 14
- Florida 13
- Arizona 12
- Connecticut 11
- South Carolina 10
- Arkansas 8
- Colorado 7
- Oklahoma 7
- West Virginia 7
- Kansas 6
- Minnesota 6
- Missouri 6
- Oregon 6
- Delaware 5
- Kentucky 5
- Wisconsin 5
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2500231 | 2500231 | 2022-05-13 | Macon | Illinois | 17115 | 31113 | 354 |
2500306 | 2500306 | 2022-05-13 | Grant | Indiana | 18053 | 17380 | 354 |
2496973 | 2496973 | 2022-05-12 | Macon | Illinois | 17115 | 31078 | 354 |
2493715 | 2493715 | 2022-05-11 | Macon | Illinois | 17115 | 31046 | 354 |
2490457 | 2490457 | 2022-05-10 | Macon | Illinois | 17115 | 31018 | 354 |
2487200 | 2487200 | 2022-05-09 | Macon | Illinois | 17115 | 30986 | 354 |
2483942 | 2483942 | 2022-05-08 | Macon | Illinois | 17115 | 30913 | 354 |
2480684 | 2480684 | 2022-05-07 | Macon | Illinois | 17115 | 30913 | 354 |
2477426 | 2477426 | 2022-05-06 | Macon | Illinois | 17115 | 30913 | 354 |
2474168 | 2474168 | 2022-05-05 | Macon | Illinois | 17115 | 30873 | 354 |
2470806 | 2470806 | 2022-05-04 | Unknown | Guam | 49251 | 354 | |
2470911 | 2470911 | 2022-05-04 | Macon | Illinois | 17115 | 30857 | 354 |
2472411 | 2472411 | 2022-05-04 | Wood | Ohio | 39173 | 31748 | 354 |
2467655 | 2467655 | 2022-05-03 | Macon | Illinois | 17115 | 30835 | 354 |
2468237 | 2468237 | 2022-05-03 | Hampshire | Massachusetts | 25015 | 29509 | 354 |
2469155 | 2469155 | 2022-05-03 | Wood | Ohio | 39173 | 31748 | 354 |
2464400 | 2464400 | 2022-05-02 | Macon | Illinois | 17115 | 30822 | 354 |
2464982 | 2464982 | 2022-05-02 | Hampshire | Massachusetts | 25015 | 29459 | 354 |
2465899 | 2465899 | 2022-05-02 | Wood | Ohio | 39173 | 31748 | 354 |
2461144 | 2461144 | 2022-05-01 | Macon | Illinois | 17115 | 30790 | 354 |
2461726 | 2461726 | 2022-05-01 | Hampshire | Massachusetts | 25015 | 29232 | 354 |
2462644 | 2462644 | 2022-05-01 | Wood | Ohio | 39173 | 31748 | 354 |
2457888 | 2457888 | 2022-04-30 | Macon | Illinois | 17115 | 30790 | 354 |
2458470 | 2458470 | 2022-04-30 | Hampshire | Massachusetts | 25015 | 29232 | 354 |
2459388 | 2459388 | 2022-04-30 | Wood | Ohio | 39173 | 31748 | 354 |
2454632 | 2454632 | 2022-04-29 | Macon | Illinois | 17115 | 30790 | 354 |
2455214 | 2455214 | 2022-04-29 | Hampshire | Massachusetts | 25015 | 29232 | 354 |
2456132 | 2456132 | 2022-04-29 | Wood | Ohio | 39173 | 31748 | 354 |
2450926 | 2450926 | 2022-04-28 | Madera | California | 6039 | 43436 | 354 |
2451376 | 2451376 | 2022-04-28 | Macon | Illinois | 17115 | 30753 | 354 |
2451958 | 2451958 | 2022-04-28 | Hampshire | Massachusetts | 25015 | 29137 | 354 |
2452876 | 2452876 | 2022-04-28 | Wood | Ohio | 39173 | 31748 | 354 |
2447670 | 2447670 | 2022-04-27 | Madera | California | 6039 | 43436 | 354 |
2448120 | 2448120 | 2022-04-27 | Macon | Illinois | 17115 | 30733 | 354 |
2448702 | 2448702 | 2022-04-27 | Hampshire | Massachusetts | 25015 | 29041 | 354 |
2444414 | 2444414 | 2022-04-26 | Madera | California | 6039 | 43436 | 354 |
2444864 | 2444864 | 2022-04-26 | Macon | Illinois | 17115 | 30715 | 354 |
2445446 | 2445446 | 2022-04-26 | Hampshire | Massachusetts | 25015 | 28936 | 354 |
2441158 | 2441158 | 2022-04-25 | Madera | California | 6039 | 43430 | 354 |
2441608 | 2441608 | 2022-04-25 | Macon | Illinois | 17115 | 30696 | 354 |
2442190 | 2442190 | 2022-04-25 | Hampshire | Massachusetts | 25015 | 28899 | 354 |
2437902 | 2437902 | 2022-04-24 | Madera | California | 6039 | 43445 | 354 |
2438352 | 2438352 | 2022-04-24 | Macon | Illinois | 17115 | 30640 | 354 |
2438934 | 2438934 | 2022-04-24 | Hampshire | Massachusetts | 25015 | 28736 | 354 |
2434646 | 2434646 | 2022-04-23 | Madera | California | 6039 | 43445 | 354 |
2435096 | 2435096 | 2022-04-23 | Macon | Illinois | 17115 | 30640 | 354 |
2435678 | 2435678 | 2022-04-23 | Hampshire | Massachusetts | 25015 | 28736 | 354 |
2431390 | 2431390 | 2022-04-22 | Madera | California | 6039 | 43445 | 354 |
2431840 | 2431840 | 2022-04-22 | Macon | Illinois | 17115 | 30640 | 354 |
2432422 | 2432422 | 2022-04-22 | Hampshire | Massachusetts | 25015 | 28736 | 354 |
2433996 | 2433996 | 2022-04-22 | Orange | Texas | 48361 | 14950 | 354 |
2428134 | 2428134 | 2022-04-21 | Madera | California | 6039 | 43445 | 354 |
2428584 | 2428584 | 2022-04-21 | Macon | Illinois | 17115 | 30614 | 354 |
2429166 | 2429166 | 2022-04-21 | Hampshire | Massachusetts | 25015 | 28669 | 354 |
2430740 | 2430740 | 2022-04-21 | Orange | Texas | 48361 | 14946 | 354 |
2424878 | 2424878 | 2022-04-20 | Madera | California | 6039 | 43445 | 354 |
2425328 | 2425328 | 2022-04-20 | Macon | Illinois | 17115 | 30601 | 354 |
2425910 | 2425910 | 2022-04-20 | Hampshire | Massachusetts | 25015 | 28585 | 354 |
2426828 | 2426828 | 2022-04-20 | Wood | Ohio | 39173 | 31548 | 354 |
2426975 | 2426975 | 2022-04-20 | Indiana | Pennsylvania | 42063 | 17455 | 354 |
2427484 | 2427484 | 2022-04-20 | Orange | Texas | 48361 | 14942 | 354 |
2421622 | 2421622 | 2022-04-19 | Madera | California | 6039 | 43445 | 354 |
2422072 | 2422072 | 2022-04-19 | Macon | Illinois | 17115 | 30580 | 354 |
2423572 | 2423572 | 2022-04-19 | Wood | Ohio | 39173 | 31548 | 354 |
2423719 | 2423719 | 2022-04-19 | Indiana | Pennsylvania | 42063 | 17444 | 354 |
2424228 | 2424228 | 2022-04-19 | Orange | Texas | 48361 | 14942 | 354 |
2418366 | 2418366 | 2022-04-18 | Madera | California | 6039 | 43445 | 354 |
2418816 | 2418816 | 2022-04-18 | Macon | Illinois | 17115 | 30552 | 354 |
2420315 | 2420315 | 2022-04-18 | Wood | Ohio | 39173 | 31548 | 354 |
2420463 | 2420463 | 2022-04-18 | Indiana | Pennsylvania | 42063 | 17440 | 354 |
2420972 | 2420972 | 2022-04-18 | Orange | Texas | 48361 | 14932 | 354 |
2415110 | 2415110 | 2022-04-17 | Madera | California | 6039 | 43445 | 354 |
2415560 | 2415560 | 2022-04-17 | Macon | Illinois | 17115 | 30529 | 354 |
2417060 | 2417060 | 2022-04-17 | Wood | Ohio | 39173 | 31548 | 354 |
2417207 | 2417207 | 2022-04-17 | Indiana | Pennsylvania | 42063 | 17438 | 354 |
2417716 | 2417716 | 2022-04-17 | Orange | Texas | 48361 | 14928 | 354 |
2411854 | 2411854 | 2022-04-16 | Madera | California | 6039 | 43445 | 354 |
2412304 | 2412304 | 2022-04-16 | Macon | Illinois | 17115 | 30529 | 354 |
2413804 | 2413804 | 2022-04-16 | Wood | Ohio | 39173 | 31548 | 354 |
2413951 | 2413951 | 2022-04-16 | Indiana | Pennsylvania | 42063 | 17434 | 354 |
2414460 | 2414460 | 2022-04-16 | Orange | Texas | 48361 | 14928 | 354 |
2408598 | 2408598 | 2022-04-15 | Madera | California | 6039 | 43445 | 354 |
2409048 | 2409048 | 2022-04-15 | Macon | Illinois | 17115 | 30529 | 354 |
2410548 | 2410548 | 2022-04-15 | Wood | Ohio | 39173 | 31548 | 354 |
2410695 | 2410695 | 2022-04-15 | Indiana | Pennsylvania | 42063 | 17429 | 354 |
2411204 | 2411204 | 2022-04-15 | Orange | Texas | 48361 | 14928 | 354 |
2405342 | 2405342 | 2022-04-14 | Madera | California | 6039 | 43444 | 354 |
2405792 | 2405792 | 2022-04-14 | Macon | Illinois | 17115 | 30506 | 354 |
2407292 | 2407292 | 2022-04-14 | Wood | Ohio | 39173 | 31548 | 354 |
2407439 | 2407439 | 2022-04-14 | Indiana | Pennsylvania | 42063 | 17424 | 354 |
2407948 | 2407948 | 2022-04-14 | Orange | Texas | 48361 | 14928 | 354 |
2402087 | 2402087 | 2022-04-13 | Madera | California | 6039 | 43423 | 354 |
2402537 | 2402537 | 2022-04-13 | Macon | Illinois | 17115 | 30495 | 354 |
2404036 | 2404036 | 2022-04-13 | Wood | Ohio | 39173 | 31466 | 354 |
2404183 | 2404183 | 2022-04-13 | Indiana | Pennsylvania | 42063 | 17424 | 354 |
2404692 | 2404692 | 2022-04-13 | Orange | Texas | 48361 | 14927 | 354 |
2398832 | 2398832 | 2022-04-12 | Madera | California | 6039 | 43423 | 354 |
2399282 | 2399282 | 2022-04-12 | Macon | Illinois | 17115 | 30484 | 354 |
2400781 | 2400781 | 2022-04-12 | Wood | Ohio | 39173 | 31466 | 354 |
2400928 | 2400928 | 2022-04-12 | Indiana | Pennsylvania | 42063 | 17415 | 354 |
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);