ny_times_us_counties

Table actions
⚠️ Consult the README for warnings about using and building on this data. Also review Why It’s So Freaking Hard To Make A Good COVID-19 Model and Ten Considerations Before You Create Another Chart About COVID-19.

Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette

8,543 rows where county = "Crawford" sorted by date descending

✎ View and edit SQL

This data as json, yaml, Notebook, copyable, CSV (advanced)

Suggested facets: date (date)

state 11

fips 11

county 1

  • Crawford · 8,543 ✖
Link rowid date ▲ county state fips cases deaths
2499702 2499702 2022-05-13 Crawford Arkansas 5033 15884 249
2500004 2500004 2022-05-13 Crawford Georgia 13079 1780 55
2500193 2500193 2022-05-13 Crawford Illinois 17033 6249 61
2500292 2500292 2022-05-13 Crawford Indiana 18025 2560 40
2500396 2500396 2022-05-13 Crawford Iowa 19047 4539 54
2500491 2500491 2022-05-13 Crawford Kansas 20037 11966 130
2500840 2500840 2022-05-13 Crawford Michigan 26039 2629 31
2501103 2501103 2022-05-13 Crawford Missouri 29055 5422 104
2501660 2501660 2022-05-13 Crawford Ohio 39033 11254 215
2501866 2501866 2022-05-13 Crawford Pennsylvania 42039 20080 320
2502749 2502749 2022-05-13 Crawford Wisconsin 55023 4299 28
2496444 2496444 2022-05-12 Crawford Arkansas 5033 15879 249
2496746 2496746 2022-05-12 Crawford Georgia 13079 1780 55
2496935 2496935 2022-05-12 Crawford Illinois 17033 6245 61
2497034 2497034 2022-05-12 Crawford Indiana 18025 2560 40
2497138 2497138 2022-05-12 Crawford Iowa 19047 4539 54
2497233 2497233 2022-05-12 Crawford Kansas 20037 11939 130
2497582 2497582 2022-05-12 Crawford Michigan 26039 2629 31
2497845 2497845 2022-05-12 Crawford Missouri 29055 5393 102
2498402 2498402 2022-05-12 Crawford Ohio 39033 11254 215
2498608 2498608 2022-05-12 Crawford Pennsylvania 42039 20080 320
2499491 2499491 2022-05-12 Crawford Wisconsin 55023 4291 28
2493186 2493186 2022-05-11 Crawford Arkansas 5033 15876 249
2493488 2493488 2022-05-11 Crawford Georgia 13079 1780 55
2493677 2493677 2022-05-11 Crawford Illinois 17033 6241 61
2493776 2493776 2022-05-11 Crawford Indiana 18025 2560 40
2493880 2493880 2022-05-11 Crawford Iowa 19047 4539 54
2493975 2493975 2022-05-11 Crawford Kansas 20037 11939 130
2494324 2494324 2022-05-11 Crawford Michigan 26039 2629 31
2494587 2494587 2022-05-11 Crawford Missouri 29055 5393 102
2495144 2495144 2022-05-11 Crawford Ohio 39033 11224 214
2495350 2495350 2022-05-11 Crawford Pennsylvania 42039 20080 320
2496233 2496233 2022-05-11 Crawford Wisconsin 55023 4286 28
2489928 2489928 2022-05-10 Crawford Arkansas 5033 15864 249
2490230 2490230 2022-05-10 Crawford Georgia 13079 1773 55
2490419 2490419 2022-05-10 Crawford Illinois 17033 6235 61
2490518 2490518 2022-05-10 Crawford Indiana 18025 2559 40
2490622 2490622 2022-05-10 Crawford Iowa 19047 4528 54
2490717 2490717 2022-05-10 Crawford Kansas 20037 11939 130
2491066 2491066 2022-05-10 Crawford Michigan 26039 2596 31
2491329 2491329 2022-05-10 Crawford Missouri 29055 5393 102
2491886 2491886 2022-05-10 Crawford Ohio 39033 11224 214
2492092 2492092 2022-05-10 Crawford Pennsylvania 42039 19946 318
2492975 2492975 2022-05-10 Crawford Wisconsin 55023 4281 28
2486671 2486671 2022-05-09 Crawford Arkansas 5033 15863 249
2486973 2486973 2022-05-09 Crawford Georgia 13079 1773 55
2487162 2487162 2022-05-09 Crawford Illinois 17033 6233 61
2487261 2487261 2022-05-09 Crawford Indiana 18025 2559 40
2487365 2487365 2022-05-09 Crawford Iowa 19047 4528 54
2487460 2487460 2022-05-09 Crawford Kansas 20037 11939 130
2487809 2487809 2022-05-09 Crawford Michigan 26039 2596 31
2488071 2488071 2022-05-09 Crawford Missouri 29055 5393 102
2488628 2488628 2022-05-09 Crawford Ohio 39033 11224 214
2488834 2488834 2022-05-09 Crawford Pennsylvania 42039 19946 318
2489717 2489717 2022-05-09 Crawford Wisconsin 55023 4276 28
2483413 2483413 2022-05-08 Crawford Arkansas 5033 15862 249
2483715 2483715 2022-05-08 Crawford Georgia 13079 1773 55
2483904 2483904 2022-05-08 Crawford Illinois 17033 6228 61
2484003 2484003 2022-05-08 Crawford Indiana 18025 2558 40
2484107 2484107 2022-05-08 Crawford Iowa 19047 4528 54
2484202 2484202 2022-05-08 Crawford Kansas 20037 11939 130
2484551 2484551 2022-05-08 Crawford Michigan 26039 2596 31
2484814 2484814 2022-05-08 Crawford Missouri 29055 5393 102
2485371 2485371 2022-05-08 Crawford Ohio 39033 11224 214
2485577 2485577 2022-05-08 Crawford Pennsylvania 42039 19946 318
2486460 2486460 2022-05-08 Crawford Wisconsin 55023 4271 28
2480155 2480155 2022-05-07 Crawford Arkansas 5033 15859 249
2480457 2480457 2022-05-07 Crawford Georgia 13079 1773 55
2480646 2480646 2022-05-07 Crawford Illinois 17033 6228 61
2480745 2480745 2022-05-07 Crawford Indiana 18025 2558 40
2480849 2480849 2022-05-07 Crawford Iowa 19047 4528 54
2480944 2480944 2022-05-07 Crawford Kansas 20037 11939 130
2481293 2481293 2022-05-07 Crawford Michigan 26039 2596 31
2481556 2481556 2022-05-07 Crawford Missouri 29055 5393 102
2482113 2482113 2022-05-07 Crawford Ohio 39033 11224 214
2482319 2482319 2022-05-07 Crawford Pennsylvania 42039 19946 318
2483202 2483202 2022-05-07 Crawford Wisconsin 55023 4271 28
2476897 2476897 2022-05-06 Crawford Arkansas 5033 15858 249
2477199 2477199 2022-05-06 Crawford Georgia 13079 1773 55
2477388 2477388 2022-05-06 Crawford Illinois 17033 6228 61
2477487 2477487 2022-05-06 Crawford Indiana 18025 2558 40
2477591 2477591 2022-05-06 Crawford Iowa 19047 4528 54
2477686 2477686 2022-05-06 Crawford Kansas 20037 11939 130
2478035 2478035 2022-05-06 Crawford Michigan 26039 2596 31
2478298 2478298 2022-05-06 Crawford Missouri 29055 5393 102
2478855 2478855 2022-05-06 Crawford Ohio 39033 11224 214
2479061 2479061 2022-05-06 Crawford Pennsylvania 42039 19946 318
2479944 2479944 2022-05-06 Crawford Wisconsin 55023 4271 28
2473639 2473639 2022-05-05 Crawford Arkansas 5033 15858 249
2473941 2473941 2022-05-05 Crawford Georgia 13079 1773 55
2474130 2474130 2022-05-05 Crawford Illinois 17033 6224 61
2474229 2474229 2022-05-05 Crawford Indiana 18025 2558 40
2474333 2474333 2022-05-05 Crawford Iowa 19047 4528 54
2474428 2474428 2022-05-05 Crawford Kansas 20037 11915 130
2474777 2474777 2022-05-05 Crawford Michigan 26039 2596 31
2475040 2475040 2022-05-05 Crawford Missouri 29055 5396 102
2475597 2475597 2022-05-05 Crawford Ohio 39033 11224 214
2475803 2475803 2022-05-05 Crawford Pennsylvania 42039 19946 318
2476686 2476686 2022-05-05 Crawford Wisconsin 55023 4269 28
2470382 2470382 2022-05-04 Crawford Arkansas 5033 15852 249

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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);