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 cases
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 |
798 | 798 | 2020-03-08 | Johnson | Kansas | 20091 | 1 | 0 |
920 | 920 | 2020-03-09 | Johnson | Kansas | 20091 | 1 | 0 |
1065 | 1065 | 2020-03-10 | Johnson | Kansas | 20091 | 1 | 0 |
1243 | 1243 | 2020-03-11 | Johnson | Kansas | 20091 | 1 | 0 |
6631 | 6631 | 2020-03-21 | Johnson | Missouri | 29101 | 1 | 0 |
7720 | 7720 | 2020-03-22 | Johnson | Missouri | 29101 | 1 | 0 |
8908 | 8908 | 2020-03-23 | Johnson | Missouri | 29101 | 1 | 0 |
10209 | 10209 | 2020-03-24 | Johnson | Missouri | 29101 | 1 | 0 |
14019 | 14019 | 2020-03-26 | Johnson | Wyoming | 56019 | 1 | 0 |
15903 | 15903 | 2020-03-28 | Johnson | Arkansas | 5071 | 1 | 0 |
17322 | 17322 | 2020-03-28 | Johnson | Tennessee | 47091 | 1 | 0 |
17790 | 17790 | 2020-03-29 | Johnson | Arkansas | 5071 | 1 | 0 |
20024 | 20024 | 2020-03-30 | Johnson | Georgia | 13167 | 1 | 0 |
22105 | 22105 | 2020-03-31 | Johnson | Georgia | 13167 | 1 | 0 |
24268 | 24268 | 2020-04-01 | Johnson | Georgia | 13167 | 1 | 0 |
26499 | 26499 | 2020-04-02 | Johnson | Georgia | 13167 | 1 | 0 |
28803 | 28803 | 2020-04-03 | Johnson | Georgia | 13167 | 1 | 0 |
34007 | 34007 | 2020-04-05 | Johnson | Kentucky | 21115 | 1 | 0 |
34497 | 34497 | 2020-04-05 | Johnson | Nebraska | 31097 | 1 | 0 |
36465 | 36465 | 2020-04-06 | Johnson | Kentucky | 21115 | 1 | 0 |
36966 | 36966 | 2020-04-06 | Johnson | Nebraska | 31097 | 1 | 0 |
38972 | 38972 | 2020-04-07 | Johnson | Kentucky | 21115 | 1 | 0 |
39482 | 39482 | 2020-04-07 | Johnson | Nebraska | 31097 | 1 | 0 |
41522 | 41522 | 2020-04-08 | Johnson | Kentucky | 21115 | 1 | 0 |
42038 | 42038 | 2020-04-08 | Johnson | Nebraska | 31097 | 1 | 0 |
44097 | 44097 | 2020-04-09 | Johnson | Kentucky | 21115 | 1 | 0 |
44619 | 44619 | 2020-04-09 | Johnson | Nebraska | 31097 | 1 | 0 |
46705 | 46705 | 2020-04-10 | Johnson | Kentucky | 21115 | 1 | 0 |
47231 | 47231 | 2020-04-10 | Johnson | Nebraska | 31097 | 1 | 0 |
49344 | 49344 | 2020-04-11 | Johnson | Kentucky | 21115 | 1 | 0 |
49881 | 49881 | 2020-04-11 | Johnson | Nebraska | 31097 | 1 | 0 |
52010 | 52010 | 2020-04-12 | Johnson | Kentucky | 21115 | 1 | 0 |
52555 | 52555 | 2020-04-12 | Johnson | Nebraska | 31097 | 1 | 0 |
54354 | 54354 | 2020-04-13 | Johnson | Illinois | 17087 | 1 | 0 |
54691 | 54691 | 2020-04-13 | Johnson | Kentucky | 21115 | 1 | 0 |
55236 | 55236 | 2020-04-13 | Johnson | Nebraska | 31097 | 1 | 0 |
57047 | 57047 | 2020-04-14 | Johnson | Illinois | 17087 | 1 | 0 |
57388 | 57388 | 2020-04-14 | Johnson | Kentucky | 21115 | 1 | 0 |
57935 | 57935 | 2020-04-14 | Johnson | Nebraska | 31097 | 1 | 0 |
60097 | 60097 | 2020-04-15 | Johnson | Kentucky | 21115 | 1 | 0 |
60649 | 60649 | 2020-04-15 | Johnson | Nebraska | 31097 | 1 | 0 |
62817 | 62817 | 2020-04-16 | Johnson | Kentucky | 21115 | 1 | 0 |
65556 | 65556 | 2020-04-17 | Johnson | Kentucky | 21115 | 1 | 0 |
68305 | 68305 | 2020-04-18 | Johnson | Kentucky | 21115 | 1 | 0 |
71068 | 71068 | 2020-04-19 | Johnson | Kentucky | 21115 | 1 | 0 |
73840 | 73840 | 2020-04-20 | Johnson | Kentucky | 21115 | 1 | 0 |
76621 | 76621 | 2020-04-21 | Johnson | Kentucky | 21115 | 1 | 0 |
79406 | 79406 | 2020-04-22 | Johnson | Kentucky | 21115 | 1 | 0 |
82203 | 82203 | 2020-04-23 | Johnson | Kentucky | 21115 | 1 | 0 |
85006 | 85006 | 2020-04-24 | Johnson | Kentucky | 21115 | 1 | 0 |
87815 | 87815 | 2020-04-25 | Johnson | Kentucky | 21115 | 1 | 0 |
5061 | 5061 | 2020-03-19 | Johnson | Texas | 48251 | 2 | 0 |
5954 | 5954 | 2020-03-20 | Johnson | Texas | 48251 | 2 | 0 |
6974 | 6974 | 2020-03-21 | Johnson | Texas | 48251 | 2 | 0 |
8104 | 8104 | 2020-03-22 | Johnson | Texas | 48251 | 2 | 0 |
9322 | 9322 | 2020-03-23 | Johnson | Texas | 48251 | 2 | 0 |
10662 | 10662 | 2020-03-24 | Johnson | Texas | 48251 | 2 | 0 |
11631 | 11631 | 2020-03-25 | Johnson | Missouri | 29101 | 2 | 0 |
19270 | 19270 | 2020-03-29 | Johnson | Tennessee | 47091 | 2 | 0 |
21325 | 21325 | 2020-03-30 | Johnson | Tennessee | 47091 | 2 | 0 |
23464 | 23464 | 2020-03-31 | Johnson | Tennessee | 47091 | 2 | 0 |
25665 | 25665 | 2020-04-01 | Johnson | Tennessee | 47091 | 2 | 0 |
27944 | 27944 | 2020-04-02 | Johnson | Tennessee | 47091 | 2 | 0 |
30279 | 30279 | 2020-04-03 | Johnson | Tennessee | 47091 | 2 | 0 |
31163 | 31163 | 2020-04-04 | Johnson | Georgia | 13167 | 2 | 0 |
32670 | 32670 | 2020-04-04 | Johnson | Tennessee | 47091 | 2 | 0 |
35107 | 35107 | 2020-04-05 | Johnson | Tennessee | 47091 | 2 | 0 |
37583 | 37583 | 2020-04-06 | Johnson | Tennessee | 47091 | 2 | 0 |
40106 | 40106 | 2020-04-07 | Johnson | Tennessee | 47091 | 2 | 0 |
42668 | 42668 | 2020-04-08 | Johnson | Tennessee | 47091 | 2 | 0 |
45255 | 45255 | 2020-04-09 | Johnson | Tennessee | 47091 | 2 | 0 |
47873 | 47873 | 2020-04-10 | Johnson | Tennessee | 47091 | 2 | 0 |
50531 | 50531 | 2020-04-11 | Johnson | Tennessee | 47091 | 2 | 0 |
53206 | 53206 | 2020-04-12 | Johnson | Tennessee | 47091 | 2 | 0 |
55892 | 55892 | 2020-04-13 | Johnson | Tennessee | 47091 | 2 | 0 |
58595 | 58595 | 2020-04-14 | Johnson | Tennessee | 47091 | 2 | 0 |
59754 | 59754 | 2020-04-15 | Johnson | Illinois | 17087 | 2 | 0 |
61310 | 61310 | 2020-04-15 | Johnson | Tennessee | 47091 | 2 | 0 |
62475 | 62475 | 2020-04-16 | Johnson | Illinois | 17087 | 2 | 0 |
63373 | 63373 | 2020-04-16 | Johnson | Nebraska | 31097 | 2 | 0 |
64037 | 64037 | 2020-04-16 | Johnson | Tennessee | 47091 | 2 | 0 |
65208 | 65208 | 2020-04-17 | Johnson | Illinois | 17087 | 2 | 0 |
66114 | 66114 | 2020-04-17 | Johnson | Nebraska | 31097 | 2 | 0 |
66783 | 66783 | 2020-04-17 | Johnson | Tennessee | 47091 | 2 | 0 |
67957 | 67957 | 2020-04-18 | Johnson | Illinois | 17087 | 2 | 0 |
68869 | 68869 | 2020-04-18 | Johnson | Nebraska | 31097 | 2 | 0 |
69542 | 69542 | 2020-04-18 | Johnson | Tennessee | 47091 | 2 | 0 |
70719 | 70719 | 2020-04-19 | Johnson | Illinois | 17087 | 2 | 0 |
71636 | 71636 | 2020-04-19 | Johnson | Nebraska | 31097 | 2 | 0 |
72309 | 72309 | 2020-04-19 | Johnson | Tennessee | 47091 | 2 | 0 |
73489 | 73489 | 2020-04-20 | Johnson | Illinois | 17087 | 2 | 0 |
74410 | 74410 | 2020-04-20 | Johnson | Nebraska | 31097 | 2 | 0 |
75084 | 75084 | 2020-04-20 | Johnson | Tennessee | 47091 | 2 | 0 |
76266 | 76266 | 2020-04-21 | Johnson | Illinois | 17087 | 2 | 0 |
77190 | 77190 | 2020-04-21 | Johnson | Nebraska | 31097 | 2 | 0 |
77866 | 77866 | 2020-04-21 | Johnson | Tennessee | 47091 | 2 | 0 |
79979 | 79979 | 2020-04-22 | Johnson | Nebraska | 31097 | 2 | 0 |
80656 | 80656 | 2020-04-22 | Johnson | Tennessee | 47091 | 2 | 0 |
82776 | 82776 | 2020-04-23 | Johnson | Nebraska | 31097 | 2 | 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);