ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
780 rows where county = "Shawnee", fips = 20177 and state = "Kansas" sorted by rowid
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
11335 | 11335 | 2020-03-25 | Shawnee | Kansas | 20177 | 3 | 0 |
12903 | 12903 | 2020-03-26 | Shawnee | Kansas | 20177 | 4 | 0 |
14606 | 14606 | 2020-03-27 | Shawnee | Kansas | 20177 | 5 | 0 |
16414 | 16414 | 2020-03-28 | Shawnee | Kansas | 20177 | 7 | 1 |
18321 | 18321 | 2020-03-29 | Shawnee | Kansas | 20177 | 13 | 1 |
20335 | 20335 | 2020-03-30 | Shawnee | Kansas | 20177 | 14 | 1 |
22434 | 22434 | 2020-03-31 | Shawnee | Kansas | 20177 | 17 | 1 |
24610 | 24610 | 2020-04-01 | Shawnee | Kansas | 20177 | 18 | 2 |
26854 | 26854 | 2020-04-02 | Shawnee | Kansas | 20177 | 20 | 2 |
29170 | 29170 | 2020-04-03 | Shawnee | Kansas | 20177 | 24 | 2 |
31544 | 31544 | 2020-04-04 | Shawnee | Kansas | 20177 | 27 | 2 |
33959 | 33959 | 2020-04-05 | Shawnee | Kansas | 20177 | 38 | 3 |
36417 | 36417 | 2020-04-06 | Shawnee | Kansas | 20177 | 40 | 3 |
38922 | 38922 | 2020-04-07 | Shawnee | Kansas | 20177 | 43 | 3 |
41469 | 41469 | 2020-04-08 | Shawnee | Kansas | 20177 | 53 | 3 |
44045 | 44045 | 2020-04-09 | Shawnee | Kansas | 20177 | 56 | 3 |
46652 | 46652 | 2020-04-10 | Shawnee | Kansas | 20177 | 59 | 3 |
49289 | 49289 | 2020-04-11 | Shawnee | Kansas | 20177 | 73 | 3 |
51954 | 51954 | 2020-04-12 | Shawnee | Kansas | 20177 | 75 | 4 |
54636 | 54636 | 2020-04-13 | Shawnee | Kansas | 20177 | 78 | 5 |
57330 | 57330 | 2020-04-14 | Shawnee | Kansas | 20177 | 80 | 5 |
60038 | 60038 | 2020-04-15 | Shawnee | Kansas | 20177 | 82 | 5 |
62759 | 62759 | 2020-04-16 | Shawnee | Kansas | 20177 | 82 | 5 |
65495 | 65495 | 2020-04-17 | Shawnee | Kansas | 20177 | 90 | 5 |
68244 | 68244 | 2020-04-18 | Shawnee | Kansas | 20177 | 90 | 5 |
71005 | 71005 | 2020-04-19 | Shawnee | Kansas | 20177 | 91 | 5 |
73777 | 73777 | 2020-04-20 | Shawnee | Kansas | 20177 | 91 | 5 |
76557 | 76557 | 2020-04-21 | Shawnee | Kansas | 20177 | 94 | 5 |
79342 | 79342 | 2020-04-22 | Shawnee | Kansas | 20177 | 95 | 5 |
82138 | 82138 | 2020-04-23 | Shawnee | Kansas | 20177 | 98 | 5 |
84941 | 84941 | 2020-04-24 | Shawnee | Kansas | 20177 | 100 | 5 |
87750 | 87750 | 2020-04-25 | Shawnee | Kansas | 20177 | 100 | 5 |
90566 | 90566 | 2020-04-26 | Shawnee | Kansas | 20177 | 101 | 5 |
93387 | 93387 | 2020-04-27 | Shawnee | Kansas | 20177 | 106 | 5 |
96220 | 96220 | 2020-04-28 | Shawnee | Kansas | 20177 | 108 | 5 |
99066 | 99066 | 2020-04-29 | Shawnee | Kansas | 20177 | 112 | 5 |
101918 | 101918 | 2020-04-30 | Shawnee | Kansas | 20177 | 117 | 5 |
104779 | 104779 | 2020-05-01 | Shawnee | Kansas | 20177 | 121 | 5 |
107644 | 107644 | 2020-05-02 | Shawnee | Kansas | 20177 | 126 | 5 |
110515 | 110515 | 2020-05-03 | Shawnee | Kansas | 20177 | 127 | 5 |
113392 | 113392 | 2020-05-04 | Shawnee | Kansas | 20177 | 128 | 5 |
116274 | 116274 | 2020-05-05 | Shawnee | Kansas | 20177 | 133 | 5 |
119235 | 119235 | 2020-05-06 | Shawnee | Kansas | 20177 | 137 | 5 |
122205 | 122205 | 2020-05-07 | Shawnee | Kansas | 20177 | 140 | 5 |
125187 | 125187 | 2020-05-08 | Shawnee | Kansas | 20177 | 149 | 5 |
128175 | 128175 | 2020-05-09 | Shawnee | Kansas | 20177 | 160 | 5 |
131165 | 131165 | 2020-05-10 | Shawnee | Kansas | 20177 | 160 | 5 |
134156 | 134156 | 2020-05-11 | Shawnee | Kansas | 20177 | 166 | 5 |
137146 | 137146 | 2020-05-12 | Shawnee | Kansas | 20177 | 173 | 5 |
140139 | 140139 | 2020-05-13 | Shawnee | Kansas | 20177 | 178 | 5 |
143135 | 143135 | 2020-05-14 | Shawnee | Kansas | 20177 | 179 | 5 |
146135 | 146135 | 2020-05-15 | Shawnee | Kansas | 20177 | 184 | 5 |
149139 | 149139 | 2020-05-16 | Shawnee | Kansas | 20177 | 185 | 5 |
152150 | 152150 | 2020-05-17 | Shawnee | Kansas | 20177 | 185 | 5 |
155163 | 155163 | 2020-05-18 | Shawnee | Kansas | 20177 | 198 | 5 |
158180 | 158180 | 2020-05-19 | Shawnee | Kansas | 20177 | 199 | 5 |
161205 | 161205 | 2020-05-20 | Shawnee | Kansas | 20177 | 217 | 6 |
164234 | 164234 | 2020-05-21 | Shawnee | Kansas | 20177 | 234 | 6 |
167269 | 167269 | 2020-05-22 | Shawnee | Kansas | 20177 | 249 | 6 |
170307 | 170307 | 2020-05-23 | Shawnee | Kansas | 20177 | 254 | 6 |
173348 | 173348 | 2020-05-24 | Shawnee | Kansas | 20177 | 254 | 6 |
176392 | 176392 | 2020-05-25 | Shawnee | Kansas | 20177 | 265 | 6 |
179436 | 179436 | 2020-05-26 | Shawnee | Kansas | 20177 | 269 | 7 |
182481 | 182481 | 2020-05-27 | Shawnee | Kansas | 20177 | 272 | 7 |
185535 | 185535 | 2020-05-28 | Shawnee | Kansas | 20177 | 272 | 7 |
188593 | 188593 | 2020-05-29 | Shawnee | Kansas | 20177 | 294 | 7 |
191657 | 191657 | 2020-05-30 | Shawnee | Kansas | 20177 | 300 | 7 |
194725 | 194725 | 2020-05-31 | Shawnee | Kansas | 20177 | 300 | 7 |
197795 | 197795 | 2020-06-01 | Shawnee | Kansas | 20177 | 328 | 7 |
200867 | 200867 | 2020-06-02 | Shawnee | Kansas | 20177 | 328 | 7 |
203944 | 203944 | 2020-06-03 | Shawnee | Kansas | 20177 | 336 | 7 |
207025 | 207025 | 2020-06-04 | Shawnee | Kansas | 20177 | 348 | 7 |
210106 | 210106 | 2020-06-05 | Shawnee | Kansas | 20177 | 369 | 7 |
213191 | 213191 | 2020-06-06 | Shawnee | Kansas | 20177 | 372 | 7 |
216278 | 216278 | 2020-06-07 | Shawnee | Kansas | 20177 | 372 | 7 |
219370 | 219370 | 2020-06-08 | Shawnee | Kansas | 20177 | 384 | 7 |
222465 | 222465 | 2020-06-09 | Shawnee | Kansas | 20177 | 394 | 7 |
225560 | 225560 | 2020-06-10 | Shawnee | Kansas | 20177 | 409 | 8 |
228662 | 228662 | 2020-06-11 | Shawnee | Kansas | 20177 | 420 | 8 |
231765 | 231765 | 2020-06-12 | Shawnee | Kansas | 20177 | 439 | 8 |
234871 | 234871 | 2020-06-13 | Shawnee | Kansas | 20177 | 439 | 8 |
237978 | 237978 | 2020-06-14 | Shawnee | Kansas | 20177 | 439 | 8 |
241087 | 241087 | 2020-06-15 | Shawnee | Kansas | 20177 | 461 | 9 |
244198 | 244198 | 2020-06-16 | Shawnee | Kansas | 20177 | 461 | 9 |
247311 | 247311 | 2020-06-17 | Shawnee | Kansas | 20177 | 465 | 9 |
250423 | 250423 | 2020-06-18 | Shawnee | Kansas | 20177 | 469 | 9 |
253538 | 253538 | 2020-06-19 | Shawnee | Kansas | 20177 | 485 | 9 |
256658 | 256658 | 2020-06-20 | Shawnee | Kansas | 20177 | 491 | 9 |
259784 | 259784 | 2020-06-21 | Shawnee | Kansas | 20177 | 491 | 9 |
262911 | 262911 | 2020-06-22 | Shawnee | Kansas | 20177 | 515 | 9 |
266039 | 266039 | 2020-06-23 | Shawnee | Kansas | 20177 | 515 | 9 |
269171 | 269171 | 2020-06-24 | Shawnee | Kansas | 20177 | 543 | 9 |
272308 | 272308 | 2020-06-25 | Shawnee | Kansas | 20177 | 546 | 9 |
275451 | 275451 | 2020-06-26 | Shawnee | Kansas | 20177 | 576 | 9 |
278599 | 278599 | 2020-06-27 | Shawnee | Kansas | 20177 | 596 | 9 |
281747 | 281747 | 2020-06-28 | Shawnee | Kansas | 20177 | 596 | 9 |
284893 | 284893 | 2020-06-29 | Shawnee | Kansas | 20177 | 630 | 11 |
288042 | 288042 | 2020-06-30 | Shawnee | Kansas | 20177 | 646 | 11 |
291192 | 291192 | 2020-07-01 | Shawnee | Kansas | 20177 | 670 | 12 |
294346 | 294346 | 2020-07-02 | Shawnee | Kansas | 20177 | 709 | 13 |
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);