ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
793 rows where county = "Wyandotte" and state = "Kansas" sorted by county
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date | county ▼ | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1459 | 1459 | 2020-03-12 | Wyandotte | Kansas | 20209 | 1 | 1 |
1732 | 1732 | 2020-03-13 | Wyandotte | Kansas | 20209 | 1 | 1 |
2067 | 2067 | 2020-03-14 | Wyandotte | Kansas | 20209 | 1 | 1 |
2463 | 2463 | 2020-03-15 | Wyandotte | Kansas | 20209 | 1 | 1 |
2908 | 2908 | 2020-03-16 | Wyandotte | Kansas | 20209 | 1 | 1 |
3403 | 3403 | 2020-03-17 | Wyandotte | Kansas | 20209 | 3 | 1 |
3980 | 3980 | 2020-03-18 | Wyandotte | Kansas | 20209 | 5 | 1 |
4665 | 4665 | 2020-03-19 | Wyandotte | Kansas | 20209 | 8 | 1 |
5478 | 5478 | 2020-03-20 | Wyandotte | Kansas | 20209 | 9 | 1 |
6423 | 6423 | 2020-03-21 | Wyandotte | Kansas | 20209 | 13 | 1 |
7492 | 7492 | 2020-03-22 | Wyandotte | Kansas | 20209 | 14 | 1 |
8654 | 8654 | 2020-03-23 | Wyandotte | Kansas | 20209 | 16 | 1 |
9937 | 9937 | 2020-03-24 | Wyandotte | Kansas | 20209 | 22 | 2 |
11337 | 11337 | 2020-03-25 | Wyandotte | Kansas | 20209 | 27 | 2 |
12906 | 12906 | 2020-03-26 | Wyandotte | Kansas | 20209 | 34 | 2 |
14609 | 14609 | 2020-03-27 | Wyandotte | Kansas | 20209 | 43 | 3 |
16417 | 16417 | 2020-03-28 | Wyandotte | Kansas | 20209 | 53 | 3 |
18326 | 18326 | 2020-03-29 | Wyandotte | Kansas | 20209 | 55 | 4 |
20340 | 20340 | 2020-03-30 | Wyandotte | Kansas | 20209 | 67 | 4 |
22439 | 22439 | 2020-03-31 | Wyandotte | Kansas | 20209 | 79 | 4 |
24615 | 24615 | 2020-04-01 | Wyandotte | Kansas | 20209 | 93 | 4 |
26859 | 26859 | 2020-04-02 | Wyandotte | Kansas | 20209 | 106 | 5 |
29175 | 29175 | 2020-04-03 | Wyandotte | Kansas | 20209 | 131 | 6 |
31549 | 31549 | 2020-04-04 | Wyandotte | Kansas | 20209 | 149 | 6 |
33965 | 33965 | 2020-04-05 | Wyandotte | Kansas | 20209 | 161 | 6 |
36423 | 36423 | 2020-04-06 | Wyandotte | Kansas | 20209 | 186 | 7 |
38928 | 38928 | 2020-04-07 | Wyandotte | Kansas | 20209 | 192 | 10 |
41476 | 41476 | 2020-04-08 | Wyandotte | Kansas | 20209 | 245 | 13 |
44051 | 44051 | 2020-04-09 | Wyandotte | Kansas | 20209 | 277 | 16 |
46659 | 46659 | 2020-04-10 | Wyandotte | Kansas | 20209 | 300 | 20 |
49296 | 49296 | 2020-04-11 | Wyandotte | Kansas | 20209 | 315 | 24 |
51962 | 51962 | 2020-04-12 | Wyandotte | Kansas | 20209 | 332 | 24 |
54643 | 54643 | 2020-04-13 | Wyandotte | Kansas | 20209 | 337 | 29 |
57338 | 57338 | 2020-04-14 | Wyandotte | Kansas | 20209 | 345 | 30 |
60047 | 60047 | 2020-04-15 | Wyandotte | Kansas | 20209 | 363 | 31 |
62767 | 62767 | 2020-04-16 | Wyandotte | Kansas | 20209 | 379 | 34 |
65506 | 65506 | 2020-04-17 | Wyandotte | Kansas | 20209 | 400 | 35 |
68255 | 68255 | 2020-04-18 | Wyandotte | Kansas | 20209 | 412 | 35 |
71016 | 71016 | 2020-04-19 | Wyandotte | Kansas | 20209 | 417 | 37 |
73788 | 73788 | 2020-04-20 | Wyandotte | Kansas | 20209 | 426 | 44 |
76568 | 76568 | 2020-04-21 | Wyandotte | Kansas | 20209 | 433 | 44 |
79353 | 79353 | 2020-04-22 | Wyandotte | Kansas | 20209 | 471 | 46 |
82149 | 82149 | 2020-04-23 | Wyandotte | Kansas | 20209 | 501 | 47 |
84952 | 84952 | 2020-04-24 | Wyandotte | Kansas | 20209 | 539 | 49 |
87761 | 87761 | 2020-04-25 | Wyandotte | Kansas | 20209 | 565 | 50 |
90577 | 90577 | 2020-04-26 | Wyandotte | Kansas | 20209 | 575 | 51 |
93398 | 93398 | 2020-04-27 | Wyandotte | Kansas | 20209 | 587 | 53 |
96231 | 96231 | 2020-04-28 | Wyandotte | Kansas | 20209 | 599 | 53 |
99077 | 99077 | 2020-04-29 | Wyandotte | Kansas | 20209 | 632 | 55 |
101929 | 101929 | 2020-04-30 | Wyandotte | Kansas | 20209 | 693 | 55 |
104790 | 104790 | 2020-05-01 | Wyandotte | Kansas | 20209 | 736 | 55 |
107655 | 107655 | 2020-05-02 | Wyandotte | Kansas | 20209 | 789 | 55 |
110526 | 110526 | 2020-05-03 | Wyandotte | Kansas | 20209 | 849 | 55 |
113403 | 113403 | 2020-05-04 | Wyandotte | Kansas | 20209 | 901 | 61 |
116285 | 116285 | 2020-05-05 | Wyandotte | Kansas | 20209 | 922 | 64 |
119246 | 119246 | 2020-05-06 | Wyandotte | Kansas | 20209 | 939 | 64 |
122216 | 122216 | 2020-05-07 | Wyandotte | Kansas | 20209 | 978 | 64 |
125198 | 125198 | 2020-05-08 | Wyandotte | Kansas | 20209 | 1042 | 64 |
128186 | 128186 | 2020-05-09 | Wyandotte | Kansas | 20209 | 1080 | 64 |
131176 | 131176 | 2020-05-10 | Wyandotte | Kansas | 20209 | 1110 | 64 |
134167 | 134167 | 2020-05-11 | Wyandotte | Kansas | 20209 | 1121 | 65 |
137157 | 137157 | 2020-05-12 | Wyandotte | Kansas | 20209 | 1127 | 65 |
140150 | 140150 | 2020-05-13 | Wyandotte | Kansas | 20209 | 1140 | 66 |
143146 | 143146 | 2020-05-14 | Wyandotte | Kansas | 20209 | 1159 | 67 |
146146 | 146146 | 2020-05-15 | Wyandotte | Kansas | 20209 | 1170 | 69 |
149150 | 149150 | 2020-05-16 | Wyandotte | Kansas | 20209 | 1199 | 70 |
152161 | 152161 | 2020-05-17 | Wyandotte | Kansas | 20209 | 1203 | 70 |
155174 | 155174 | 2020-05-18 | Wyandotte | Kansas | 20209 | 1212 | 70 |
158191 | 158191 | 2020-05-19 | Wyandotte | Kansas | 20209 | 1224 | 70 |
161216 | 161216 | 2020-05-20 | Wyandotte | Kansas | 20209 | 1242 | 71 |
164245 | 164245 | 2020-05-21 | Wyandotte | Kansas | 20209 | 1266 | 71 |
167281 | 167281 | 2020-05-22 | Wyandotte | Kansas | 20209 | 1289 | 71 |
170319 | 170319 | 2020-05-23 | Wyandotte | Kansas | 20209 | 1308 | 71 |
173360 | 173360 | 2020-05-24 | Wyandotte | Kansas | 20209 | 1317 | 71 |
176404 | 176404 | 2020-05-25 | Wyandotte | Kansas | 20209 | 1318 | 71 |
179448 | 179448 | 2020-05-26 | Wyandotte | Kansas | 20209 | 1326 | 71 |
182493 | 182493 | 2020-05-27 | Wyandotte | Kansas | 20209 | 1332 | 71 |
185547 | 185547 | 2020-05-28 | Wyandotte | Kansas | 20209 | 1365 | 73 |
188605 | 188605 | 2020-05-29 | Wyandotte | Kansas | 20209 | 1396 | 73 |
191669 | 191669 | 2020-05-30 | Wyandotte | Kansas | 20209 | 1404 | 73 |
194737 | 194737 | 2020-05-31 | Wyandotte | Kansas | 20209 | 1414 | 74 |
197808 | 197808 | 2020-06-01 | Wyandotte | Kansas | 20209 | 1425 | 74 |
200879 | 200879 | 2020-06-02 | Wyandotte | Kansas | 20209 | 1442 | 74 |
203956 | 203956 | 2020-06-03 | Wyandotte | Kansas | 20209 | 1485 | 74 |
207037 | 207037 | 2020-06-04 | Wyandotte | Kansas | 20209 | 1500 | 74 |
210118 | 210118 | 2020-06-05 | Wyandotte | Kansas | 20209 | 1537 | 75 |
213203 | 213203 | 2020-06-06 | Wyandotte | Kansas | 20209 | 1552 | 75 |
216290 | 216290 | 2020-06-07 | Wyandotte | Kansas | 20209 | 1562 | 75 |
219382 | 219382 | 2020-06-08 | Wyandotte | Kansas | 20209 | 1575 | 75 |
222477 | 222477 | 2020-06-09 | Wyandotte | Kansas | 20209 | 1587 | 76 |
225573 | 225573 | 2020-06-10 | Wyandotte | Kansas | 20209 | 1617 | 76 |
228675 | 228675 | 2020-06-11 | Wyandotte | Kansas | 20209 | 1646 | 76 |
231779 | 231779 | 2020-06-12 | Wyandotte | Kansas | 20209 | 1679 | 76 |
234884 | 234884 | 2020-06-13 | Wyandotte | Kansas | 20209 | 1711 | 76 |
237991 | 237991 | 2020-06-14 | Wyandotte | Kansas | 20209 | 1733 | 76 |
241100 | 241100 | 2020-06-15 | Wyandotte | Kansas | 20209 | 1750 | 76 |
244211 | 244211 | 2020-06-16 | Wyandotte | Kansas | 20209 | 1768 | 76 |
247324 | 247324 | 2020-06-17 | Wyandotte | Kansas | 20209 | 1812 | 76 |
250436 | 250436 | 2020-06-18 | Wyandotte | Kansas | 20209 | 1853 | 77 |
253551 | 253551 | 2020-06-19 | Wyandotte | Kansas | 20209 | 1890 | 77 |
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);