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

9,366 rows where county = "Johnson" sorted by date descending

✎ View and edit SQL

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

Suggested facets: date (date)

state 12

fips 12

county 1

  • Johnson · 9,366 ✖
Link rowid date ▲ county state fips cases deaths
2499721 2499721 2022-05-13 Johnson Arkansas 5071 6830 87
2500048 2500048 2022-05-13 Johnson Georgia 13167 2258 73
2500220 2500220 2022-05-13 Johnson Illinois 17087 4538 46
2500320 2500320 2022-05-13 Johnson Indiana 18081 42798 615
2500424 2500424 2022-05-13 Johnson Iowa 19103 35541 153
2500518 2500518 2022-05-13 Johnson Kansas 20091 148890 1219
2500636 2500636 2022-05-13 Johnson Kentucky 21115 6173 118
2501126 2501126 2022-05-13 Johnson Missouri 29101 12251 143
2501297 2501297 2022-05-13 Johnson Nebraska 31097 873 10
2502156 2502156 2022-05-13 Johnson Tennessee 47091 5181 95
2502332 2502332 2022-05-13 Johnson Texas 48251 43903 735
2502819 2502819 2022-05-13 Johnson Wyoming 56019 1845 19
2496463 2496463 2022-05-12 Johnson Arkansas 5071 6828 87
2496790 2496790 2022-05-12 Johnson Georgia 13167 2258 73
2496962 2496962 2022-05-12 Johnson Illinois 17087 4532 46
2497062 2497062 2022-05-12 Johnson Indiana 18081 42751 615
2497166 2497166 2022-05-12 Johnson Iowa 19103 35541 153
2497260 2497260 2022-05-12 Johnson Kansas 20091 147803 1219
2497378 2497378 2022-05-12 Johnson Kentucky 21115 6173 118
2497868 2497868 2022-05-12 Johnson Missouri 29101 12206 143
2498039 2498039 2022-05-12 Johnson Nebraska 31097 872 10
2498898 2498898 2022-05-12 Johnson Tennessee 47091 5181 95
2499074 2499074 2022-05-12 Johnson Texas 48251 43895 735
2499561 2499561 2022-05-12 Johnson Wyoming 56019 1845 19
2493205 2493205 2022-05-11 Johnson Arkansas 5071 6824 87
2493532 2493532 2022-05-11 Johnson Georgia 13167 2258 73
2493704 2493704 2022-05-11 Johnson Illinois 17087 4531 46
2493804 2493804 2022-05-11 Johnson Indiana 18081 42751 615
2493908 2493908 2022-05-11 Johnson Iowa 19103 35541 153
2494002 2494002 2022-05-11 Johnson Kansas 20091 147803 1219
2494120 2494120 2022-05-11 Johnson Kentucky 21115 6173 118
2494610 2494610 2022-05-11 Johnson Missouri 29101 12206 143
2494781 2494781 2022-05-11 Johnson Nebraska 31097 872 10
2495640 2495640 2022-05-11 Johnson Tennessee 47091 5181 95
2495816 2495816 2022-05-11 Johnson Texas 48251 43880 735
2496303 2496303 2022-05-11 Johnson Wyoming 56019 1845 19
2489947 2489947 2022-05-10 Johnson Arkansas 5071 6824 87
2490274 2490274 2022-05-10 Johnson Georgia 13167 2255 72
2490446 2490446 2022-05-10 Johnson Illinois 17087 4530 46
2490546 2490546 2022-05-10 Johnson Indiana 18081 42702 615
2490650 2490650 2022-05-10 Johnson Iowa 19103 35039 152
2490744 2490744 2022-05-10 Johnson Kansas 20091 147803 1219
2490862 2490862 2022-05-10 Johnson Kentucky 21115 6173 118
2491352 2491352 2022-05-10 Johnson Missouri 29101 12206 143
2491523 2491523 2022-05-10 Johnson Nebraska 31097 895 10
2492382 2492382 2022-05-10 Johnson Tennessee 47091 5174 95
2492558 2492558 2022-05-10 Johnson Texas 48251 43861 735
2493045 2493045 2022-05-10 Johnson Wyoming 56019 1845 19
2486690 2486690 2022-05-09 Johnson Arkansas 5071 6824 87
2487017 2487017 2022-05-09 Johnson Georgia 13167 2255 72
2487189 2487189 2022-05-09 Johnson Illinois 17087 4501 46
2487289 2487289 2022-05-09 Johnson Indiana 18081 42702 615
2487393 2487393 2022-05-09 Johnson Iowa 19103 35039 152
2487487 2487487 2022-05-09 Johnson Kansas 20091 147803 1215
2487605 2487605 2022-05-09 Johnson Kentucky 21115 6173 118
2488094 2488094 2022-05-09 Johnson Missouri 29101 12206 143
2488265 2488265 2022-05-09 Johnson Nebraska 31097 895 10
2489124 2489124 2022-05-09 Johnson Tennessee 47091 5174 95
2489300 2489300 2022-05-09 Johnson Texas 48251 43847 734
2489787 2489787 2022-05-09 Johnson Wyoming 56019 1845 19
2483432 2483432 2022-05-08 Johnson Arkansas 5071 6819 87
2483759 2483759 2022-05-08 Johnson Georgia 13167 2255 72
2483931 2483931 2022-05-08 Johnson Illinois 17087 4492 46
2484031 2484031 2022-05-08 Johnson Indiana 18081 42622 614
2484135 2484135 2022-05-08 Johnson Iowa 19103 35039 152
2484229 2484229 2022-05-08 Johnson Kansas 20091 147803 1215
2484347 2484347 2022-05-08 Johnson Kentucky 21115 6153 117
2484837 2484837 2022-05-08 Johnson Missouri 29101 12206 143
2485008 2485008 2022-05-08 Johnson Nebraska 31097 895 10
2485867 2485867 2022-05-08 Johnson Tennessee 47091 5174 95
2486043 2486043 2022-05-08 Johnson Texas 48251 43842 734
2486530 2486530 2022-05-08 Johnson Wyoming 56019 1845 19
2480174 2480174 2022-05-07 Johnson Arkansas 5071 6819 87
2480501 2480501 2022-05-07 Johnson Georgia 13167 2255 72
2480673 2480673 2022-05-07 Johnson Illinois 17087 4492 46
2480773 2480773 2022-05-07 Johnson Indiana 18081 42622 614
2480877 2480877 2022-05-07 Johnson Iowa 19103 35039 152
2480971 2480971 2022-05-07 Johnson Kansas 20091 147803 1215
2481089 2481089 2022-05-07 Johnson Kentucky 21115 6153 117
2481579 2481579 2022-05-07 Johnson Missouri 29101 12206 143
2481750 2481750 2022-05-07 Johnson Nebraska 31097 895 10
2482609 2482609 2022-05-07 Johnson Tennessee 47091 5174 95
2482785 2482785 2022-05-07 Johnson Texas 48251 43833 734
2483272 2483272 2022-05-07 Johnson Wyoming 56019 1845 19
2476916 2476916 2022-05-06 Johnson Arkansas 5071 6819 87
2477243 2477243 2022-05-06 Johnson Georgia 13167 2255 72
2477415 2477415 2022-05-06 Johnson Illinois 17087 4492 46
2477515 2477515 2022-05-06 Johnson Indiana 18081 42622 614
2477619 2477619 2022-05-06 Johnson Iowa 19103 35039 152
2477713 2477713 2022-05-06 Johnson Kansas 20091 147803 1215
2477831 2477831 2022-05-06 Johnson Kentucky 21115 6153 117
2478321 2478321 2022-05-06 Johnson Missouri 29101 12206 143
2478492 2478492 2022-05-06 Johnson Nebraska 31097 895 10
2479351 2479351 2022-05-06 Johnson Tennessee 47091 5174 95
2479527 2479527 2022-05-06 Johnson Texas 48251 43820 734
2480014 2480014 2022-05-06 Johnson Wyoming 56019 1845 19
2473658 2473658 2022-05-05 Johnson Arkansas 5071 6819 87
2473985 2473985 2022-05-05 Johnson Georgia 13167 2255 72
2474157 2474157 2022-05-05 Johnson Illinois 17087 4486 46
2474257 2474257 2022-05-05 Johnson Indiana 18081 42622 614

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