ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
9,366 rows where county = "Johnson" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2474361 | 2474361 | 2022-05-05 | Johnson | Iowa | 19103 | 35039 | 152 |
2474455 | 2474455 | 2022-05-05 | Johnson | Kansas | 20091 | 146955 | 1215 |
2474573 | 2474573 | 2022-05-05 | Johnson | Kentucky | 21115 | 6153 | 117 |
2475063 | 2475063 | 2022-05-05 | Johnson | Missouri | 29101 | 12175 | 143 |
2475234 | 2475234 | 2022-05-05 | Johnson | Nebraska | 31097 | 895 | 10 |
2476093 | 2476093 | 2022-05-05 | Johnson | Tennessee | 47091 | 5174 | 95 |
2476269 | 2476269 | 2022-05-05 | Johnson | Texas | 48251 | 43804 | 734 |
2476756 | 2476756 | 2022-05-05 | Johnson | Wyoming | 56019 | 1845 | 19 |
2470401 | 2470401 | 2022-05-04 | Johnson | Arkansas | 5071 | 6819 | 87 |
2470728 | 2470728 | 2022-05-04 | Johnson | Georgia | 13167 | 2255 | 72 |
2470900 | 2470900 | 2022-05-04 | Johnson | Illinois | 17087 | 4487 | 46 |
2471000 | 2471000 | 2022-05-04 | Johnson | Indiana | 18081 | 42622 | 614 |
2471104 | 2471104 | 2022-05-04 | Johnson | Iowa | 19103 | 35039 | 152 |
2471198 | 2471198 | 2022-05-04 | Johnson | Kansas | 20091 | 146955 | 1215 |
2471316 | 2471316 | 2022-05-04 | Johnson | Kentucky | 21115 | 6153 | 117 |
2471806 | 2471806 | 2022-05-04 | Johnson | Missouri | 29101 | 12165 | 140 |
2471977 | 2471977 | 2022-05-04 | Johnson | Nebraska | 31097 | 892 | 10 |
2472836 | 2472836 | 2022-05-04 | Johnson | Tennessee | 47091 | 5174 | 95 |
2473012 | 2473012 | 2022-05-04 | Johnson | Texas | 48251 | 43800 | 734 |
2473498 | 2473498 | 2022-05-04 | Johnson | Wyoming | 56019 | 1845 | 19 |
2467145 | 2467145 | 2022-05-03 | Johnson | Arkansas | 5071 | 6819 | 87 |
2467472 | 2467472 | 2022-05-03 | Johnson | Georgia | 13167 | 2254 | 72 |
2467644 | 2467644 | 2022-05-03 | Johnson | Illinois | 17087 | 4485 | 46 |
2467744 | 2467744 | 2022-05-03 | Johnson | Indiana | 18081 | 42564 | 614 |
2467848 | 2467848 | 2022-05-03 | Johnson | Iowa | 19103 | 34672 | 152 |
2467942 | 2467942 | 2022-05-03 | Johnson | Kansas | 20091 | 146955 | 1215 |
2468060 | 2468060 | 2022-05-03 | Johnson | Kentucky | 21115 | 6153 | 117 |
2468550 | 2468550 | 2022-05-03 | Johnson | Missouri | 29101 | 12165 | 140 |
2468721 | 2468721 | 2022-05-03 | Johnson | Nebraska | 31097 | 891 | 10 |
2469580 | 2469580 | 2022-05-03 | Johnson | Tennessee | 47091 | 5170 | 93 |
2469756 | 2469756 | 2022-05-03 | Johnson | Texas | 48251 | 43776 | 734 |
2470241 | 2470241 | 2022-05-03 | Johnson | Wyoming | 56019 | 1845 | 19 |
2463890 | 2463890 | 2022-05-02 | Johnson | Arkansas | 5071 | 6818 | 87 |
2464217 | 2464217 | 2022-05-02 | Johnson | Georgia | 13167 | 2254 | 72 |
2464389 | 2464389 | 2022-05-02 | Johnson | Illinois | 17087 | 4483 | 46 |
2464489 | 2464489 | 2022-05-02 | Johnson | Indiana | 18081 | 42564 | 614 |
2464593 | 2464593 | 2022-05-02 | Johnson | Iowa | 19103 | 34672 | 152 |
2464687 | 2464687 | 2022-05-02 | Johnson | Kansas | 20091 | 146955 | 1211 |
2464805 | 2464805 | 2022-05-02 | Johnson | Kentucky | 21115 | 6153 | 117 |
2465294 | 2465294 | 2022-05-02 | Johnson | Missouri | 29101 | 12165 | 140 |
2465465 | 2465465 | 2022-05-02 | Johnson | Nebraska | 31097 | 893 | 10 |
2466324 | 2466324 | 2022-05-02 | Johnson | Tennessee | 47091 | 5170 | 93 |
2466500 | 2466500 | 2022-05-02 | Johnson | Texas | 48251 | 43757 | 734 |
2466985 | 2466985 | 2022-05-02 | Johnson | Wyoming | 56019 | 1845 | 19 |
2460634 | 2460634 | 2022-05-01 | Johnson | Arkansas | 5071 | 6817 | 87 |
2460961 | 2460961 | 2022-05-01 | Johnson | Georgia | 13167 | 2255 | 72 |
2461133 | 2461133 | 2022-05-01 | Johnson | Illinois | 17087 | 4479 | 46 |
2461233 | 2461233 | 2022-05-01 | Johnson | Indiana | 18081 | 42546 | 614 |
2461337 | 2461337 | 2022-05-01 | Johnson | Iowa | 19103 | 34672 | 152 |
2461431 | 2461431 | 2022-05-01 | Johnson | Kansas | 20091 | 146955 | 1211 |
2461549 | 2461549 | 2022-05-01 | Johnson | Kentucky | 21115 | 6117 | 113 |
2462039 | 2462039 | 2022-05-01 | Johnson | Missouri | 29101 | 12165 | 140 |
2462210 | 2462210 | 2022-05-01 | Johnson | Nebraska | 31097 | 893 | 10 |
2463069 | 2463069 | 2022-05-01 | Johnson | Tennessee | 47091 | 5170 | 93 |
2463245 | 2463245 | 2022-05-01 | Johnson | Texas | 48251 | 43754 | 734 |
2463730 | 2463730 | 2022-05-01 | Johnson | Wyoming | 56019 | 1845 | 19 |
2457378 | 2457378 | 2022-04-30 | Johnson | Arkansas | 5071 | 6817 | 87 |
2457705 | 2457705 | 2022-04-30 | Johnson | Georgia | 13167 | 2255 | 72 |
2457877 | 2457877 | 2022-04-30 | Johnson | Illinois | 17087 | 4479 | 46 |
2457977 | 2457977 | 2022-04-30 | Johnson | Indiana | 18081 | 42546 | 614 |
2458081 | 2458081 | 2022-04-30 | Johnson | Iowa | 19103 | 34672 | 152 |
2458175 | 2458175 | 2022-04-30 | Johnson | Kansas | 20091 | 146955 | 1211 |
2458293 | 2458293 | 2022-04-30 | Johnson | Kentucky | 21115 | 6117 | 113 |
2458783 | 2458783 | 2022-04-30 | Johnson | Missouri | 29101 | 12165 | 140 |
2458954 | 2458954 | 2022-04-30 | Johnson | Nebraska | 31097 | 893 | 10 |
2459813 | 2459813 | 2022-04-30 | Johnson | Tennessee | 47091 | 5170 | 93 |
2459989 | 2459989 | 2022-04-30 | Johnson | Texas | 48251 | 43754 | 734 |
2460474 | 2460474 | 2022-04-30 | Johnson | Wyoming | 56019 | 1845 | 19 |
2454122 | 2454122 | 2022-04-29 | Johnson | Arkansas | 5071 | 6817 | 87 |
2454449 | 2454449 | 2022-04-29 | Johnson | Georgia | 13167 | 2255 | 72 |
2454621 | 2454621 | 2022-04-29 | Johnson | Illinois | 17087 | 4479 | 46 |
2454721 | 2454721 | 2022-04-29 | Johnson | Indiana | 18081 | 42546 | 614 |
2454825 | 2454825 | 2022-04-29 | Johnson | Iowa | 19103 | 34672 | 152 |
2454919 | 2454919 | 2022-04-29 | Johnson | Kansas | 20091 | 146955 | 1211 |
2455037 | 2455037 | 2022-04-29 | Johnson | Kentucky | 21115 | 6117 | 113 |
2455527 | 2455527 | 2022-04-29 | Johnson | Missouri | 29101 | 12165 | 140 |
2455698 | 2455698 | 2022-04-29 | Johnson | Nebraska | 31097 | 893 | 10 |
2456557 | 2456557 | 2022-04-29 | Johnson | Tennessee | 47091 | 5170 | 93 |
2456733 | 2456733 | 2022-04-29 | Johnson | Texas | 48251 | 43711 | 734 |
2457218 | 2457218 | 2022-04-29 | Johnson | Wyoming | 56019 | 1845 | 19 |
2450866 | 2450866 | 2022-04-28 | Johnson | Arkansas | 5071 | 6817 | 87 |
2451193 | 2451193 | 2022-04-28 | Johnson | Georgia | 13167 | 2255 | 72 |
2451365 | 2451365 | 2022-04-28 | Johnson | Illinois | 17087 | 4480 | 46 |
2451465 | 2451465 | 2022-04-28 | Johnson | Indiana | 18081 | 42505 | 613 |
2451569 | 2451569 | 2022-04-28 | Johnson | Iowa | 19103 | 34672 | 152 |
2451663 | 2451663 | 2022-04-28 | Johnson | Kansas | 20091 | 146355 | 1211 |
2451781 | 2451781 | 2022-04-28 | Johnson | Kentucky | 21115 | 6117 | 113 |
2452271 | 2452271 | 2022-04-28 | Johnson | Missouri | 29101 | 12165 | 140 |
2452442 | 2452442 | 2022-04-28 | Johnson | Nebraska | 31097 | 894 | 10 |
2453301 | 2453301 | 2022-04-28 | Johnson | Tennessee | 47091 | 5170 | 93 |
2453477 | 2453477 | 2022-04-28 | Johnson | Texas | 48251 | 43676 | 734 |
2453962 | 2453962 | 2022-04-28 | Johnson | Wyoming | 56019 | 1845 | 19 |
2447610 | 2447610 | 2022-04-27 | Johnson | Arkansas | 5071 | 6816 | 87 |
2447937 | 2447937 | 2022-04-27 | Johnson | Georgia | 13167 | 2255 | 72 |
2448109 | 2448109 | 2022-04-27 | Johnson | Illinois | 17087 | 4478 | 46 |
2448209 | 2448209 | 2022-04-27 | Johnson | Indiana | 18081 | 42505 | 613 |
2448313 | 2448313 | 2022-04-27 | Johnson | Iowa | 19103 | 34672 | 152 |
2448407 | 2448407 | 2022-04-27 | Johnson | Kansas | 20091 | 146355 | 1211 |
2448525 | 2448525 | 2022-04-27 | Johnson | Kentucky | 21115 | 6117 | 113 |
2449015 | 2449015 | 2022-04-27 | Johnson | Missouri | 29101 | 12165 | 140 |
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);