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 deaths
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 |
3395 | 3395 | 2020-03-17 | Johnson | Iowa | 19103 | 18 | 0 |
3402 | 3402 | 2020-03-17 | Johnson | Kansas | 20091 | 10 | 0 |
3969 | 3969 | 2020-03-18 | Johnson | Iowa | 19103 | 21 | 0 |
3978 | 3978 | 2020-03-18 | Johnson | Kansas | 20091 | 11 | 0 |
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 |
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 |
6403 | 6403 | 2020-03-21 | Johnson | Iowa | 19103 | 27 | 0 |
6631 | 6631 | 2020-03-21 | Johnson | Missouri | 29101 | 1 | 0 |
6974 | 6974 | 2020-03-21 | Johnson | Texas | 48251 | 2 | 0 |
7464 | 7464 | 2020-03-22 | Johnson | Iowa | 19103 | 32 | 0 |
7720 | 7720 | 2020-03-22 | Johnson | Missouri | 29101 | 1 | 0 |
8104 | 8104 | 2020-03-22 | Johnson | Texas | 48251 | 2 | 0 |
8623 | 8623 | 2020-03-23 | Johnson | Iowa | 19103 | 35 | 0 |
8908 | 8908 | 2020-03-23 | Johnson | Missouri | 29101 | 1 | 0 |
9322 | 9322 | 2020-03-23 | Johnson | Texas | 48251 | 2 | 0 |
9902 | 9902 | 2020-03-24 | Johnson | Iowa | 19103 | 37 | 0 |
10209 | 10209 | 2020-03-24 | Johnson | Missouri | 29101 | 1 | 0 |
10662 | 10662 | 2020-03-24 | Johnson | Texas | 48251 | 2 | 0 |
11299 | 11299 | 2020-03-25 | Johnson | Iowa | 19103 | 43 | 0 |
11631 | 11631 | 2020-03-25 | Johnson | Missouri | 29101 | 2 | 0 |
12157 | 12157 | 2020-03-25 | Johnson | Texas | 48251 | 3 | 0 |
12863 | 12863 | 2020-03-26 | Johnson | Iowa | 19103 | 49 | 0 |
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 |
14555 | 14555 | 2020-03-27 | Johnson | Iowa | 19103 | 58 | 0 |
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 |
16359 | 16359 | 2020-03-28 | Johnson | Iowa | 19103 | 61 | 0 |
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 |
18264 | 18264 | 2020-03-29 | Johnson | Iowa | 19103 | 65 | 0 |
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 |
20274 | 20274 | 2020-03-30 | Johnson | Iowa | 19103 | 70 | 0 |
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 |
21719 | 21719 | 2020-03-30 | Johnson | Wyoming | 56019 | 5 | 0 |
21836 | 21836 | 2020-03-31 | Johnson | Arkansas | 5071 | 3 | 0 |
22105 | 22105 | 2020-03-31 | Johnson | Georgia | 13167 | 1 | 0 |
22370 | 22370 | 2020-03-31 | Johnson | Iowa | 19103 | 73 | 0 |
22845 | 22845 | 2020-03-31 | Johnson | Missouri | 29101 | 10 | 0 |
23464 | 23464 | 2020-03-31 | Johnson | Tennessee | 47091 | 2 | 0 |
23565 | 23565 | 2020-03-31 | Johnson | Texas | 48251 | 8 | 0 |
23872 | 23872 | 2020-03-31 | Johnson | Wyoming | 56019 | 7 | 0 |
23993 | 23993 | 2020-04-01 | Johnson | Arkansas | 5071 | 6 | 0 |
24268 | 24268 | 2020-04-01 | Johnson | Georgia | 13167 | 1 | 0 |
24542 | 24542 | 2020-04-01 | Johnson | Iowa | 19103 | 76 | 0 |
25033 | 25033 | 2020-04-01 | Johnson | Missouri | 29101 | 14 | 0 |
25665 | 25665 | 2020-04-01 | Johnson | Tennessee | 47091 | 2 | 0 |
25775 | 25775 | 2020-04-01 | Johnson | Texas | 48251 | 12 | 0 |
26093 | 26093 | 2020-04-01 | Johnson | Wyoming | 56019 | 7 | 0 |
26217 | 26217 | 2020-04-02 | Johnson | Arkansas | 5071 | 7 | 0 |
26499 | 26499 | 2020-04-02 | Johnson | Georgia | 13167 | 1 | 0 |
26784 | 26784 | 2020-04-02 | Johnson | Iowa | 19103 | 80 | 0 |
27289 | 27289 | 2020-04-02 | Johnson | Missouri | 29101 | 26 | 0 |
27944 | 27944 | 2020-04-02 | Johnson | Tennessee | 47091 | 2 | 0 |
28060 | 28060 | 2020-04-02 | Johnson | Texas | 48251 | 17 | 0 |
28387 | 28387 | 2020-04-02 | Johnson | Wyoming | 56019 | 8 | 0 |
28514 | 28514 | 2020-04-03 | Johnson | Arkansas | 5071 | 7 | 0 |
28803 | 28803 | 2020-04-03 | Johnson | Georgia | 13167 | 1 | 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);