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
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▼ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
699 | 699 | 2020-03-07 | Johnson | Kansas | 20091 | 1 | 0 |
797 | 797 | 2020-03-08 | Johnson | Iowa | 19103 | 3 | 0 |
798 | 798 | 2020-03-08 | Johnson | Kansas | 20091 | 1 | 0 |
918 | 918 | 2020-03-09 | Johnson | Iowa | 19103 | 7 | 0 |
920 | 920 | 2020-03-09 | Johnson | Kansas | 20091 | 1 | 0 |
1063 | 1063 | 2020-03-10 | Johnson | Iowa | 19103 | 12 | 0 |
1065 | 1065 | 2020-03-10 | Johnson | Kansas | 20091 | 1 | 0 |
1237 | 1237 | 2020-03-11 | Johnson | Indiana | 18081 | 3 | 0 |
1241 | 1241 | 2020-03-11 | Johnson | Iowa | 19103 | 13 | 0 |
1243 | 1243 | 2020-03-11 | Johnson | Kansas | 20091 | 1 | 0 |
1451 | 1451 | 2020-03-12 | Johnson | Indiana | 18081 | 3 | 0 |
1456 | 1456 | 2020-03-12 | Johnson | Iowa | 19103 | 14 | 0 |
1458 | 1458 | 2020-03-12 | Johnson | Kansas | 20091 | 4 | 0 |
1722 | 1722 | 2020-03-13 | Johnson | Indiana | 18081 | 3 | 0 |
1728 | 1728 | 2020-03-13 | Johnson | Iowa | 19103 | 14 | 0 |
1731 | 1731 | 2020-03-13 | Johnson | Kansas | 20091 | 4 | 0 |
2053 | 2053 | 2020-03-14 | Johnson | Indiana | 18081 | 3 | 0 |
2062 | 2062 | 2020-03-14 | Johnson | Iowa | 19103 | 14 | 0 |
2066 | 2066 | 2020-03-14 | Johnson | Kansas | 20091 | 5 | 0 |
2447 | 2447 | 2020-03-15 | Johnson | Indiana | 18081 | 3 | 0 |
2457 | 2457 | 2020-03-15 | Johnson | Iowa | 19103 | 15 | 0 |
2462 | 2462 | 2020-03-15 | Johnson | Kansas | 20091 | 6 | 0 |
2892 | 2892 | 2020-03-16 | Johnson | Indiana | 18081 | 3 | 0 |
2902 | 2902 | 2020-03-16 | Johnson | Iowa | 19103 | 15 | 0 |
2907 | 2907 | 2020-03-16 | Johnson | Kansas | 20091 | 8 | 0 |
3382 | 3382 | 2020-03-17 | Johnson | Indiana | 18081 | 3 | 1 |
3395 | 3395 | 2020-03-17 | Johnson | Iowa | 19103 | 18 | 0 |
3402 | 3402 | 2020-03-17 | Johnson | Kansas | 20091 | 10 | 0 |
3955 | 3955 | 2020-03-18 | Johnson | Indiana | 18081 | 3 | 1 |
3969 | 3969 | 2020-03-18 | Johnson | Iowa | 19103 | 21 | 0 |
3978 | 3978 | 2020-03-18 | Johnson | Kansas | 20091 | 11 | 0 |
4631 | 4631 | 2020-03-19 | Johnson | Indiana | 18081 | 3 | 1 |
4649 | 4649 | 2020-03-19 | Johnson | Iowa | 19103 | 22 | 0 |
4660 | 4660 | 2020-03-19 | Johnson | Kansas | 20091 | 16 | 0 |
5061 | 5061 | 2020-03-19 | Johnson | Texas | 48251 | 2 | 0 |
5439 | 5439 | 2020-03-20 | Johnson | Indiana | 18081 | 4 | 1 |
5460 | 5460 | 2020-03-20 | Johnson | Iowa | 19103 | 22 | 0 |
5471 | 5471 | 2020-03-20 | Johnson | Kansas | 20091 | 24 | 0 |
5954 | 5954 | 2020-03-20 | Johnson | Texas | 48251 | 2 | 0 |
6378 | 6378 | 2020-03-21 | Johnson | Indiana | 18081 | 7 | 1 |
6403 | 6403 | 2020-03-21 | Johnson | Iowa | 19103 | 27 | 0 |
6416 | 6416 | 2020-03-21 | Johnson | Kansas | 20091 | 25 | 1 |
6631 | 6631 | 2020-03-21 | Johnson | Missouri | 29101 | 1 | 0 |
6974 | 6974 | 2020-03-21 | Johnson | Texas | 48251 | 2 | 0 |
7432 | 7432 | 2020-03-22 | Johnson | Indiana | 18081 | 12 | 1 |
7464 | 7464 | 2020-03-22 | Johnson | Iowa | 19103 | 32 | 0 |
7484 | 7484 | 2020-03-22 | Johnson | Kansas | 20091 | 28 | 1 |
7720 | 7720 | 2020-03-22 | Johnson | Missouri | 29101 | 1 | 0 |
8104 | 8104 | 2020-03-22 | Johnson | Texas | 48251 | 2 | 0 |
8590 | 8590 | 2020-03-23 | Johnson | Indiana | 18081 | 14 | 1 |
8623 | 8623 | 2020-03-23 | Johnson | Iowa | 19103 | 35 | 0 |
8645 | 8645 | 2020-03-23 | Johnson | Kansas | 20091 | 32 | 1 |
8908 | 8908 | 2020-03-23 | Johnson | Missouri | 29101 | 1 | 0 |
9322 | 9322 | 2020-03-23 | Johnson | Texas | 48251 | 2 | 0 |
9859 | 9859 | 2020-03-24 | Johnson | Indiana | 18081 | 18 | 3 |
9902 | 9902 | 2020-03-24 | Johnson | Iowa | 19103 | 37 | 0 |
9926 | 9926 | 2020-03-24 | Johnson | Kansas | 20091 | 36 | 1 |
10209 | 10209 | 2020-03-24 | Johnson | Missouri | 29101 | 1 | 0 |
10662 | 10662 | 2020-03-24 | Johnson | Texas | 48251 | 2 | 0 |
11254 | 11254 | 2020-03-25 | Johnson | Indiana | 18081 | 24 | 3 |
11299 | 11299 | 2020-03-25 | Johnson | Iowa | 19103 | 43 | 0 |
11324 | 11324 | 2020-03-25 | Johnson | Kansas | 20091 | 46 | 1 |
11631 | 11631 | 2020-03-25 | Johnson | Missouri | 29101 | 2 | 0 |
12157 | 12157 | 2020-03-25 | Johnson | Texas | 48251 | 3 | 0 |
12811 | 12811 | 2020-03-26 | Johnson | Indiana | 18081 | 36 | 3 |
12863 | 12863 | 2020-03-26 | Johnson | Iowa | 19103 | 49 | 0 |
12892 | 12892 | 2020-03-26 | Johnson | Kansas | 20091 | 59 | 1 |
13229 | 13229 | 2020-03-26 | Johnson | Missouri | 29101 | 8 | 0 |
13787 | 13787 | 2020-03-26 | Johnson | Texas | 48251 | 3 | 0 |
14019 | 14019 | 2020-03-26 | Johnson | Wyoming | 56019 | 1 | 0 |
14494 | 14494 | 2020-03-27 | Johnson | Indiana | 18081 | 42 | 3 |
14555 | 14555 | 2020-03-27 | Johnson | Iowa | 19103 | 58 | 0 |
14592 | 14592 | 2020-03-27 | Johnson | Kansas | 20091 | 66 | 1 |
14954 | 14954 | 2020-03-27 | Johnson | Missouri | 29101 | 8 | 0 |
15543 | 15543 | 2020-03-27 | Johnson | Texas | 48251 | 6 | 0 |
15796 | 15796 | 2020-03-27 | Johnson | Wyoming | 56019 | 4 | 0 |
15903 | 15903 | 2020-03-28 | Johnson | Arkansas | 5071 | 1 | 0 |
16292 | 16292 | 2020-03-28 | Johnson | Indiana | 18081 | 52 | 3 |
16359 | 16359 | 2020-03-28 | Johnson | Iowa | 19103 | 61 | 0 |
16399 | 16399 | 2020-03-28 | Johnson | Kansas | 20091 | 80 | 2 |
16778 | 16778 | 2020-03-28 | Johnson | Missouri | 29101 | 9 | 0 |
17322 | 17322 | 2020-03-28 | Johnson | Tennessee | 47091 | 1 | 0 |
17412 | 17412 | 2020-03-28 | Johnson | Texas | 48251 | 8 | 0 |
17678 | 17678 | 2020-03-28 | Johnson | Wyoming | 56019 | 5 | 0 |
17790 | 17790 | 2020-03-29 | Johnson | Arkansas | 5071 | 1 | 0 |
18195 | 18195 | 2020-03-29 | Johnson | Indiana | 18081 | 71 | 3 |
18264 | 18264 | 2020-03-29 | Johnson | Iowa | 19103 | 65 | 0 |
18305 | 18305 | 2020-03-29 | Johnson | Kansas | 20091 | 108 | 2 |
18700 | 18700 | 2020-03-29 | Johnson | Missouri | 29101 | 9 | 0 |
19270 | 19270 | 2020-03-29 | Johnson | Tennessee | 47091 | 2 | 0 |
19366 | 19366 | 2020-03-29 | Johnson | Texas | 48251 | 8 | 0 |
19647 | 19647 | 2020-03-29 | Johnson | Wyoming | 56019 | 5 | 0 |
19764 | 19764 | 2020-03-30 | Johnson | Arkansas | 5071 | 3 | 0 |
20024 | 20024 | 2020-03-30 | Johnson | Georgia | 13167 | 1 | 0 |
20201 | 20201 | 2020-03-30 | Johnson | Indiana | 18081 | 81 | 3 |
20274 | 20274 | 2020-03-30 | Johnson | Iowa | 19103 | 70 | 0 |
20318 | 20318 | 2020-03-30 | Johnson | Kansas | 20091 | 116 | 2 |
20726 | 20726 | 2020-03-30 | Johnson | Missouri | 29101 | 9 | 0 |
21325 | 21325 | 2020-03-30 | Johnson | Tennessee | 47091 | 2 | 0 |
21426 | 21426 | 2020-03-30 | Johnson | Texas | 48251 | 8 | 0 |
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);