ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
798 rows where county = "Johnson" and state = "Kansas" 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 |
1458 | 1458 | 2020-03-12 | Johnson | Kansas | 20091 | 4 | 0 |
1731 | 1731 | 2020-03-13 | Johnson | Kansas | 20091 | 4 | 0 |
2066 | 2066 | 2020-03-14 | Johnson | Kansas | 20091 | 5 | 0 |
2462 | 2462 | 2020-03-15 | Johnson | Kansas | 20091 | 6 | 0 |
2907 | 2907 | 2020-03-16 | Johnson | Kansas | 20091 | 8 | 0 |
3402 | 3402 | 2020-03-17 | Johnson | Kansas | 20091 | 10 | 0 |
3978 | 3978 | 2020-03-18 | Johnson | Kansas | 20091 | 11 | 0 |
4660 | 4660 | 2020-03-19 | Johnson | Kansas | 20091 | 16 | 0 |
5471 | 5471 | 2020-03-20 | Johnson | Kansas | 20091 | 24 | 0 |
6416 | 6416 | 2020-03-21 | Johnson | Kansas | 20091 | 25 | 1 |
7484 | 7484 | 2020-03-22 | Johnson | Kansas | 20091 | 28 | 1 |
8645 | 8645 | 2020-03-23 | Johnson | Kansas | 20091 | 32 | 1 |
9926 | 9926 | 2020-03-24 | Johnson | Kansas | 20091 | 36 | 1 |
11324 | 11324 | 2020-03-25 | Johnson | Kansas | 20091 | 46 | 1 |
12892 | 12892 | 2020-03-26 | Johnson | Kansas | 20091 | 59 | 1 |
14592 | 14592 | 2020-03-27 | Johnson | Kansas | 20091 | 66 | 1 |
16399 | 16399 | 2020-03-28 | Johnson | Kansas | 20091 | 80 | 2 |
18305 | 18305 | 2020-03-29 | Johnson | Kansas | 20091 | 108 | 2 |
20318 | 20318 | 2020-03-30 | Johnson | Kansas | 20091 | 116 | 2 |
22416 | 22416 | 2020-03-31 | Johnson | Kansas | 20091 | 134 | 3 |
24591 | 24591 | 2020-04-01 | Johnson | Kansas | 20091 | 143 | 3 |
26835 | 26835 | 2020-04-02 | Johnson | Kansas | 20091 | 161 | 4 |
29149 | 29149 | 2020-04-03 | Johnson | Kansas | 20091 | 172 | 7 |
31523 | 31523 | 2020-04-04 | Johnson | Kansas | 20091 | 185 | 7 |
33937 | 33937 | 2020-04-05 | Johnson | Kansas | 20091 | 192 | 8 |
36394 | 36394 | 2020-04-06 | Johnson | Kansas | 20091 | 213 | 9 |
38896 | 38896 | 2020-04-07 | Johnson | Kansas | 20091 | 219 | 10 |
41443 | 41443 | 2020-04-08 | Johnson | Kansas | 20091 | 244 | 11 |
44019 | 44019 | 2020-04-09 | Johnson | Kansas | 20091 | 252 | 12 |
46626 | 46626 | 2020-04-10 | Johnson | Kansas | 20091 | 263 | 12 |
49262 | 49262 | 2020-04-11 | Johnson | Kansas | 20091 | 283 | 13 |
51926 | 51926 | 2020-04-12 | Johnson | Kansas | 20091 | 300 | 14 |
54608 | 54608 | 2020-04-13 | Johnson | Kansas | 20091 | 309 | 15 |
57302 | 57302 | 2020-04-14 | Johnson | Kansas | 20091 | 323 | 16 |
60010 | 60010 | 2020-04-15 | Johnson | Kansas | 20091 | 334 | 19 |
62731 | 62731 | 2020-04-16 | Johnson | Kansas | 20091 | 343 | 22 |
65467 | 65467 | 2020-04-17 | Johnson | Kansas | 20091 | 358 | 23 |
68216 | 68216 | 2020-04-18 | Johnson | Kansas | 20091 | 369 | 25 |
70977 | 70977 | 2020-04-19 | Johnson | Kansas | 20091 | 372 | 30 |
73749 | 73749 | 2020-04-20 | Johnson | Kansas | 20091 | 377 | 30 |
76529 | 76529 | 2020-04-21 | Johnson | Kansas | 20091 | 384 | 35 |
79314 | 79314 | 2020-04-22 | Johnson | Kansas | 20091 | 396 | 36 |
82108 | 82108 | 2020-04-23 | Johnson | Kansas | 20091 | 403 | 36 |
84910 | 84910 | 2020-04-24 | Johnson | Kansas | 20091 | 417 | 37 |
87719 | 87719 | 2020-04-25 | Johnson | Kansas | 20091 | 424 | 38 |
90535 | 90535 | 2020-04-26 | Johnson | Kansas | 20091 | 430 | 38 |
93356 | 93356 | 2020-04-27 | Johnson | Kansas | 20091 | 440 | 39 |
96188 | 96188 | 2020-04-28 | Johnson | Kansas | 20091 | 446 | 40 |
99034 | 99034 | 2020-04-29 | Johnson | Kansas | 20091 | 454 | 40 |
101886 | 101886 | 2020-04-30 | Johnson | Kansas | 20091 | 464 | 40 |
104746 | 104746 | 2020-05-01 | Johnson | Kansas | 20091 | 471 | 40 |
107611 | 107611 | 2020-05-02 | Johnson | Kansas | 20091 | 486 | 41 |
110482 | 110482 | 2020-05-03 | Johnson | Kansas | 20091 | 498 | 42 |
113359 | 113359 | 2020-05-04 | Johnson | Kansas | 20091 | 504 | 45 |
116241 | 116241 | 2020-05-05 | Johnson | Kansas | 20091 | 513 | 45 |
119202 | 119202 | 2020-05-06 | Johnson | Kansas | 20091 | 521 | 45 |
122172 | 122172 | 2020-05-07 | Johnson | Kansas | 20091 | 560 | 45 |
125154 | 125154 | 2020-05-08 | Johnson | Kansas | 20091 | 583 | 47 |
128142 | 128142 | 2020-05-09 | Johnson | Kansas | 20091 | 590 | 51 |
131132 | 131132 | 2020-05-10 | Johnson | Kansas | 20091 | 598 | 51 |
134123 | 134123 | 2020-05-11 | Johnson | Kansas | 20091 | 611 | 52 |
137113 | 137113 | 2020-05-12 | Johnson | Kansas | 20091 | 611 | 54 |
140106 | 140106 | 2020-05-13 | Johnson | Kansas | 20091 | 618 | 54 |
143102 | 143102 | 2020-05-14 | Johnson | Kansas | 20091 | 619 | 54 |
146102 | 146102 | 2020-05-15 | Johnson | Kansas | 20091 | 648 | 55 |
149106 | 149106 | 2020-05-16 | Johnson | Kansas | 20091 | 648 | 56 |
152117 | 152117 | 2020-05-17 | Johnson | Kansas | 20091 | 648 | 56 |
155129 | 155129 | 2020-05-18 | Johnson | Kansas | 20091 | 666 | 56 |
158146 | 158146 | 2020-05-19 | Johnson | Kansas | 20091 | 666 | 57 |
161171 | 161171 | 2020-05-20 | Johnson | Kansas | 20091 | 696 | 58 |
164200 | 164200 | 2020-05-21 | Johnson | Kansas | 20091 | 696 | 59 |
167234 | 167234 | 2020-05-22 | Johnson | Kansas | 20091 | 711 | 60 |
170272 | 170272 | 2020-05-23 | Johnson | Kansas | 20091 | 711 | 60 |
173313 | 173313 | 2020-05-24 | Johnson | Kansas | 20091 | 711 | 60 |
176357 | 176357 | 2020-05-25 | Johnson | Kansas | 20091 | 765 | 61 |
179401 | 179401 | 2020-05-26 | Johnson | Kansas | 20091 | 765 | 61 |
182446 | 182446 | 2020-05-27 | Johnson | Kansas | 20091 | 788 | 62 |
185500 | 185500 | 2020-05-28 | Johnson | Kansas | 20091 | 788 | 62 |
188558 | 188558 | 2020-05-29 | Johnson | Kansas | 20091 | 829 | 62 |
191622 | 191622 | 2020-05-30 | Johnson | Kansas | 20091 | 829 | 62 |
194690 | 194690 | 2020-05-31 | Johnson | Kansas | 20091 | 839 | 63 |
197760 | 197760 | 2020-06-01 | Johnson | Kansas | 20091 | 877 | 63 |
200832 | 200832 | 2020-06-02 | Johnson | Kansas | 20091 | 877 | 66 |
203908 | 203908 | 2020-06-03 | Johnson | Kansas | 20091 | 893 | 66 |
206989 | 206989 | 2020-06-04 | Johnson | Kansas | 20091 | 893 | 67 |
210070 | 210070 | 2020-06-05 | Johnson | Kansas | 20091 | 939 | 68 |
213155 | 213155 | 2020-06-06 | Johnson | Kansas | 20091 | 939 | 69 |
216242 | 216242 | 2020-06-07 | Johnson | Kansas | 20091 | 940 | 69 |
219334 | 219334 | 2020-06-08 | Johnson | Kansas | 20091 | 977 | 71 |
222429 | 222429 | 2020-06-09 | Johnson | Kansas | 20091 | 977 | 71 |
225524 | 225524 | 2020-06-10 | Johnson | Kansas | 20091 | 1003 | 71 |
228626 | 228626 | 2020-06-11 | Johnson | Kansas | 20091 | 1003 | 71 |
231729 | 231729 | 2020-06-12 | Johnson | Kansas | 20091 | 1045 | 71 |
234835 | 234835 | 2020-06-13 | Johnson | Kansas | 20091 | 1045 | 71 |
237942 | 237942 | 2020-06-14 | Johnson | Kansas | 20091 | 1061 | 71 |
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);