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 date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
386875 | 386875 | 2020-07-31 | Johnson | Kansas | 20091 | 4995 | 98 |
383657 | 383657 | 2020-07-30 | Johnson | Kansas | 20091 | 4813 | 98 |
380440 | 380440 | 2020-07-29 | Johnson | Kansas | 20091 | 4813 | 96 |
377223 | 377223 | 2020-07-28 | Johnson | Kansas | 20091 | 4643 | 96 |
374008 | 374008 | 2020-07-27 | Johnson | Kansas | 20091 | 4643 | 94 |
370796 | 370796 | 2020-07-26 | Johnson | Kansas | 20091 | 4455 | 94 |
367586 | 367586 | 2020-07-25 | Johnson | Kansas | 20091 | 4387 | 94 |
364379 | 364379 | 2020-07-24 | Johnson | Kansas | 20091 | 4381 | 92 |
361172 | 361172 | 2020-07-23 | Johnson | Kansas | 20091 | 4161 | 96 |
357967 | 357967 | 2020-07-22 | Johnson | Kansas | 20091 | 4158 | 96 |
354765 | 354765 | 2020-07-21 | Johnson | Kansas | 20091 | 3933 | 95 |
351563 | 351563 | 2020-07-20 | Johnson | Kansas | 20091 | 3933 | 96 |
348363 | 348363 | 2020-07-19 | Johnson | Kansas | 20091 | 3744 | 96 |
345162 | 345162 | 2020-07-18 | Johnson | Kansas | 20091 | 3667 | 96 |
341962 | 341962 | 2020-07-17 | Johnson | Kansas | 20091 | 3654 | 95 |
338766 | 338766 | 2020-07-16 | Johnson | Kansas | 20091 | 3422 | 95 |
335570 | 335570 | 2020-07-15 | Johnson | Kansas | 20091 | 3370 | 94 |
332377 | 332377 | 2020-07-14 | Johnson | Kansas | 20091 | 3160 | 93 |
329190 | 329190 | 2020-07-13 | Johnson | Kansas | 20091 | 3160 | 93 |
326004 | 326004 | 2020-07-12 | Johnson | Kansas | 20091 | 2967 | 93 |
322821 | 322821 | 2020-07-11 | Johnson | Kansas | 20091 | 2857 | 92 |
319642 | 319642 | 2020-07-10 | Johnson | Kansas | 20091 | 2804 | 92 |
316469 | 316469 | 2020-07-09 | Johnson | Kansas | 20091 | 2633 | 92 |
313295 | 313295 | 2020-07-08 | Johnson | Kansas | 20091 | 2565 | 91 |
310125 | 310125 | 2020-07-07 | Johnson | Kansas | 20091 | 2356 | 91 |
306957 | 306957 | 2020-07-06 | Johnson | Kansas | 20091 | 2349 | 90 |
303791 | 303791 | 2020-07-05 | Johnson | Kansas | 20091 | 2205 | 89 |
300627 | 300627 | 2020-07-04 | Johnson | Kansas | 20091 | 2111 | 88 |
297465 | 297465 | 2020-07-03 | Johnson | Kansas | 20091 | 2066 | 88 |
294307 | 294307 | 2020-07-02 | Johnson | Kansas | 20091 | 1870 | 88 |
291153 | 291153 | 2020-07-01 | Johnson | Kansas | 20091 | 1870 | 87 |
288003 | 288003 | 2020-06-30 | Johnson | Kansas | 20091 | 1722 | 86 |
284854 | 284854 | 2020-06-29 | Johnson | Kansas | 20091 | 1722 | 86 |
281709 | 281709 | 2020-06-28 | Johnson | Kansas | 20091 | 1613 | 86 |
278561 | 278561 | 2020-06-27 | Johnson | Kansas | 20091 | 1550 | 85 |
275413 | 275413 | 2020-06-26 | Johnson | Kansas | 20091 | 1545 | 83 |
272270 | 272270 | 2020-06-25 | Johnson | Kansas | 20091 | 1427 | 81 |
269133 | 269133 | 2020-06-24 | Johnson | Kansas | 20091 | 1409 | 81 |
266003 | 266003 | 2020-06-23 | Johnson | Kansas | 20091 | 1316 | 81 |
262875 | 262875 | 2020-06-22 | Johnson | Kansas | 20091 | 1310 | 80 |
259748 | 259748 | 2020-06-21 | Johnson | Kansas | 20091 | 1257 | 80 |
256622 | 256622 | 2020-06-20 | Johnson | Kansas | 20091 | 1236 | 79 |
253502 | 253502 | 2020-06-19 | Johnson | Kansas | 20091 | 1229 | 77 |
250387 | 250387 | 2020-06-18 | Johnson | Kansas | 20091 | 1150 | 76 |
247275 | 247275 | 2020-06-17 | Johnson | Kansas | 20091 | 1139 | 73 |
244162 | 244162 | 2020-06-16 | Johnson | Kansas | 20091 | 1106 | 72 |
241051 | 241051 | 2020-06-15 | Johnson | Kansas | 20091 | 1106 | 72 |
237942 | 237942 | 2020-06-14 | Johnson | Kansas | 20091 | 1061 | 71 |
234835 | 234835 | 2020-06-13 | Johnson | Kansas | 20091 | 1045 | 71 |
231729 | 231729 | 2020-06-12 | Johnson | Kansas | 20091 | 1045 | 71 |
228626 | 228626 | 2020-06-11 | Johnson | Kansas | 20091 | 1003 | 71 |
225524 | 225524 | 2020-06-10 | Johnson | Kansas | 20091 | 1003 | 71 |
222429 | 222429 | 2020-06-09 | Johnson | Kansas | 20091 | 977 | 71 |
219334 | 219334 | 2020-06-08 | Johnson | Kansas | 20091 | 977 | 71 |
216242 | 216242 | 2020-06-07 | Johnson | Kansas | 20091 | 940 | 69 |
213155 | 213155 | 2020-06-06 | Johnson | Kansas | 20091 | 939 | 69 |
210070 | 210070 | 2020-06-05 | Johnson | Kansas | 20091 | 939 | 68 |
206989 | 206989 | 2020-06-04 | Johnson | Kansas | 20091 | 893 | 67 |
203908 | 203908 | 2020-06-03 | Johnson | Kansas | 20091 | 893 | 66 |
200832 | 200832 | 2020-06-02 | Johnson | Kansas | 20091 | 877 | 66 |
197760 | 197760 | 2020-06-01 | Johnson | Kansas | 20091 | 877 | 63 |
194690 | 194690 | 2020-05-31 | Johnson | Kansas | 20091 | 839 | 63 |
191622 | 191622 | 2020-05-30 | Johnson | Kansas | 20091 | 829 | 62 |
188558 | 188558 | 2020-05-29 | Johnson | Kansas | 20091 | 829 | 62 |
185500 | 185500 | 2020-05-28 | Johnson | Kansas | 20091 | 788 | 62 |
182446 | 182446 | 2020-05-27 | Johnson | Kansas | 20091 | 788 | 62 |
179401 | 179401 | 2020-05-26 | Johnson | Kansas | 20091 | 765 | 61 |
176357 | 176357 | 2020-05-25 | Johnson | Kansas | 20091 | 765 | 61 |
173313 | 173313 | 2020-05-24 | Johnson | Kansas | 20091 | 711 | 60 |
170272 | 170272 | 2020-05-23 | Johnson | Kansas | 20091 | 711 | 60 |
167234 | 167234 | 2020-05-22 | Johnson | Kansas | 20091 | 711 | 60 |
164200 | 164200 | 2020-05-21 | Johnson | Kansas | 20091 | 696 | 59 |
161171 | 161171 | 2020-05-20 | Johnson | Kansas | 20091 | 696 | 58 |
158146 | 158146 | 2020-05-19 | Johnson | Kansas | 20091 | 666 | 57 |
155129 | 155129 | 2020-05-18 | Johnson | Kansas | 20091 | 666 | 56 |
152117 | 152117 | 2020-05-17 | Johnson | Kansas | 20091 | 648 | 56 |
149106 | 149106 | 2020-05-16 | Johnson | Kansas | 20091 | 648 | 56 |
146102 | 146102 | 2020-05-15 | Johnson | Kansas | 20091 | 648 | 55 |
143102 | 143102 | 2020-05-14 | Johnson | Kansas | 20091 | 619 | 54 |
140106 | 140106 | 2020-05-13 | Johnson | Kansas | 20091 | 618 | 54 |
137113 | 137113 | 2020-05-12 | Johnson | Kansas | 20091 | 611 | 54 |
134123 | 134123 | 2020-05-11 | Johnson | Kansas | 20091 | 611 | 52 |
131132 | 131132 | 2020-05-10 | Johnson | Kansas | 20091 | 598 | 51 |
128142 | 128142 | 2020-05-09 | Johnson | Kansas | 20091 | 590 | 51 |
125154 | 125154 | 2020-05-08 | Johnson | Kansas | 20091 | 583 | 47 |
122172 | 122172 | 2020-05-07 | Johnson | Kansas | 20091 | 560 | 45 |
119202 | 119202 | 2020-05-06 | Johnson | Kansas | 20091 | 521 | 45 |
116241 | 116241 | 2020-05-05 | Johnson | Kansas | 20091 | 513 | 45 |
113359 | 113359 | 2020-05-04 | Johnson | Kansas | 20091 | 504 | 45 |
110482 | 110482 | 2020-05-03 | Johnson | Kansas | 20091 | 498 | 42 |
107611 | 107611 | 2020-05-02 | Johnson | Kansas | 20091 | 486 | 41 |
104746 | 104746 | 2020-05-01 | Johnson | Kansas | 20091 | 471 | 40 |
101886 | 101886 | 2020-04-30 | Johnson | Kansas | 20091 | 464 | 40 |
99034 | 99034 | 2020-04-29 | Johnson | Kansas | 20091 | 454 | 40 |
96188 | 96188 | 2020-04-28 | Johnson | Kansas | 20091 | 446 | 40 |
93356 | 93356 | 2020-04-27 | Johnson | Kansas | 20091 | 440 | 39 |
90535 | 90535 | 2020-04-26 | Johnson | Kansas | 20091 | 430 | 38 |
87719 | 87719 | 2020-04-25 | Johnson | Kansas | 20091 | 424 | 38 |
84910 | 84910 | 2020-04-24 | Johnson | Kansas | 20091 | 417 | 37 |
82108 | 82108 | 2020-04-23 | Johnson | Kansas | 20091 | 403 | 36 |
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);