ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
751 rows where county = "Gray" and state = "Kansas" sorted by date
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
Link | rowid | date ▼ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
82100 | 82100 | 2020-04-23 | Gray | Kansas | 20069 | 1 | 0 |
84902 | 84902 | 2020-04-24 | Gray | Kansas | 20069 | 2 | 0 |
87711 | 87711 | 2020-04-25 | Gray | Kansas | 20069 | 2 | 0 |
90527 | 90527 | 2020-04-26 | Gray | Kansas | 20069 | 2 | 0 |
93348 | 93348 | 2020-04-27 | Gray | Kansas | 20069 | 3 | 0 |
96180 | 96180 | 2020-04-28 | Gray | Kansas | 20069 | 4 | 0 |
99026 | 99026 | 2020-04-29 | Gray | Kansas | 20069 | 4 | 0 |
101877 | 101877 | 2020-04-30 | Gray | Kansas | 20069 | 4 | 0 |
104737 | 104737 | 2020-05-01 | Gray | Kansas | 20069 | 5 | 0 |
107602 | 107602 | 2020-05-02 | Gray | Kansas | 20069 | 5 | 0 |
110473 | 110473 | 2020-05-03 | Gray | Kansas | 20069 | 5 | 0 |
113350 | 113350 | 2020-05-04 | Gray | Kansas | 20069 | 5 | 0 |
116232 | 116232 | 2020-05-05 | Gray | Kansas | 20069 | 6 | 0 |
119193 | 119193 | 2020-05-06 | Gray | Kansas | 20069 | 6 | 0 |
122163 | 122163 | 2020-05-07 | Gray | Kansas | 20069 | 6 | 0 |
125145 | 125145 | 2020-05-08 | Gray | Kansas | 20069 | 6 | 0 |
128133 | 128133 | 2020-05-09 | Gray | Kansas | 20069 | 7 | 0 |
131123 | 131123 | 2020-05-10 | Gray | Kansas | 20069 | 7 | 0 |
134114 | 134114 | 2020-05-11 | Gray | Kansas | 20069 | 8 | 0 |
137104 | 137104 | 2020-05-12 | Gray | Kansas | 20069 | 8 | 0 |
140097 | 140097 | 2020-05-13 | Gray | Kansas | 20069 | 9 | 0 |
143093 | 143093 | 2020-05-14 | Gray | Kansas | 20069 | 9 | 0 |
146093 | 146093 | 2020-05-15 | Gray | Kansas | 20069 | 12 | 0 |
149097 | 149097 | 2020-05-16 | Gray | Kansas | 20069 | 12 | 0 |
152108 | 152108 | 2020-05-17 | Gray | Kansas | 20069 | 12 | 0 |
155120 | 155120 | 2020-05-18 | Gray | Kansas | 20069 | 14 | 0 |
158137 | 158137 | 2020-05-19 | Gray | Kansas | 20069 | 14 | 0 |
161162 | 161162 | 2020-05-20 | Gray | Kansas | 20069 | 16 | 0 |
164191 | 164191 | 2020-05-21 | Gray | Kansas | 20069 | 16 | 0 |
167224 | 167224 | 2020-05-22 | Gray | Kansas | 20069 | 21 | 0 |
170262 | 170262 | 2020-05-23 | Gray | Kansas | 20069 | 21 | 0 |
173303 | 173303 | 2020-05-24 | Gray | Kansas | 20069 | 21 | 0 |
176347 | 176347 | 2020-05-25 | Gray | Kansas | 20069 | 22 | 0 |
179391 | 179391 | 2020-05-26 | Gray | Kansas | 20069 | 22 | 0 |
182436 | 182436 | 2020-05-27 | Gray | Kansas | 20069 | 22 | 0 |
185490 | 185490 | 2020-05-28 | Gray | Kansas | 20069 | 22 | 0 |
188548 | 188548 | 2020-05-29 | Gray | Kansas | 20069 | 22 | 0 |
191612 | 191612 | 2020-05-30 | Gray | Kansas | 20069 | 22 | 0 |
194680 | 194680 | 2020-05-31 | Gray | Kansas | 20069 | 22 | 0 |
197750 | 197750 | 2020-06-01 | Gray | Kansas | 20069 | 22 | 0 |
200822 | 200822 | 2020-06-02 | Gray | Kansas | 20069 | 22 | 0 |
203898 | 203898 | 2020-06-03 | Gray | Kansas | 20069 | 22 | 0 |
206979 | 206979 | 2020-06-04 | Gray | Kansas | 20069 | 22 | 0 |
210060 | 210060 | 2020-06-05 | Gray | Kansas | 20069 | 22 | 0 |
213145 | 213145 | 2020-06-06 | Gray | Kansas | 20069 | 22 | 0 |
216232 | 216232 | 2020-06-07 | Gray | Kansas | 20069 | 22 | 0 |
219324 | 219324 | 2020-06-08 | Gray | Kansas | 20069 | 22 | 0 |
222419 | 222419 | 2020-06-09 | Gray | Kansas | 20069 | 22 | 0 |
225514 | 225514 | 2020-06-10 | Gray | Kansas | 20069 | 23 | 0 |
228616 | 228616 | 2020-06-11 | Gray | Kansas | 20069 | 23 | 0 |
231719 | 231719 | 2020-06-12 | Gray | Kansas | 20069 | 23 | 0 |
234825 | 234825 | 2020-06-13 | Gray | Kansas | 20069 | 23 | 0 |
237932 | 237932 | 2020-06-14 | Gray | Kansas | 20069 | 23 | 0 |
241041 | 241041 | 2020-06-15 | Gray | Kansas | 20069 | 23 | 0 |
244152 | 244152 | 2020-06-16 | Gray | Kansas | 20069 | 23 | 0 |
247265 | 247265 | 2020-06-17 | Gray | Kansas | 20069 | 23 | 0 |
250377 | 250377 | 2020-06-18 | Gray | Kansas | 20069 | 23 | 0 |
253492 | 253492 | 2020-06-19 | Gray | Kansas | 20069 | 24 | 0 |
256612 | 256612 | 2020-06-20 | Gray | Kansas | 20069 | 24 | 0 |
259738 | 259738 | 2020-06-21 | Gray | Kansas | 20069 | 24 | 0 |
262865 | 262865 | 2020-06-22 | Gray | Kansas | 20069 | 24 | 0 |
265993 | 265993 | 2020-06-23 | Gray | Kansas | 20069 | 24 | 0 |
269123 | 269123 | 2020-06-24 | Gray | Kansas | 20069 | 24 | 0 |
272260 | 272260 | 2020-06-25 | Gray | Kansas | 20069 | 24 | 0 |
275403 | 275403 | 2020-06-26 | Gray | Kansas | 20069 | 26 | 0 |
278551 | 278551 | 2020-06-27 | Gray | Kansas | 20069 | 26 | 0 |
281699 | 281699 | 2020-06-28 | Gray | Kansas | 20069 | 26 | 0 |
284844 | 284844 | 2020-06-29 | Gray | Kansas | 20069 | 26 | 0 |
287993 | 287993 | 2020-06-30 | Gray | Kansas | 20069 | 26 | 0 |
291143 | 291143 | 2020-07-01 | Gray | Kansas | 20069 | 26 | 0 |
294297 | 294297 | 2020-07-02 | Gray | Kansas | 20069 | 26 | 0 |
297455 | 297455 | 2020-07-03 | Gray | Kansas | 20069 | 27 | 0 |
300617 | 300617 | 2020-07-04 | Gray | Kansas | 20069 | 27 | 0 |
303781 | 303781 | 2020-07-05 | Gray | Kansas | 20069 | 27 | 0 |
306947 | 306947 | 2020-07-06 | Gray | Kansas | 20069 | 27 | 0 |
310115 | 310115 | 2020-07-07 | Gray | Kansas | 20069 | 27 | 0 |
313285 | 313285 | 2020-07-08 | Gray | Kansas | 20069 | 28 | 0 |
316459 | 316459 | 2020-07-09 | Gray | Kansas | 20069 | 28 | 0 |
319632 | 319632 | 2020-07-10 | Gray | Kansas | 20069 | 30 | 0 |
322811 | 322811 | 2020-07-11 | Gray | Kansas | 20069 | 30 | 0 |
325993 | 325993 | 2020-07-12 | Gray | Kansas | 20069 | 30 | 0 |
329179 | 329179 | 2020-07-13 | Gray | Kansas | 20069 | 34 | 0 |
332366 | 332366 | 2020-07-14 | Gray | Kansas | 20069 | 34 | 0 |
335559 | 335559 | 2020-07-15 | Gray | Kansas | 20069 | 36 | 0 |
338755 | 338755 | 2020-07-16 | Gray | Kansas | 20069 | 36 | 0 |
341951 | 341951 | 2020-07-17 | Gray | Kansas | 20069 | 39 | 0 |
345151 | 345151 | 2020-07-18 | Gray | Kansas | 20069 | 39 | 0 |
348352 | 348352 | 2020-07-19 | Gray | Kansas | 20069 | 39 | 0 |
351552 | 351552 | 2020-07-20 | Gray | Kansas | 20069 | 42 | 0 |
354754 | 354754 | 2020-07-21 | Gray | Kansas | 20069 | 42 | 0 |
357956 | 357956 | 2020-07-22 | Gray | Kansas | 20069 | 44 | 0 |
361161 | 361161 | 2020-07-23 | Gray | Kansas | 20069 | 44 | 0 |
364368 | 364368 | 2020-07-24 | Gray | Kansas | 20069 | 47 | 0 |
367575 | 367575 | 2020-07-25 | Gray | Kansas | 20069 | 47 | 0 |
370785 | 370785 | 2020-07-26 | Gray | Kansas | 20069 | 47 | 0 |
373997 | 373997 | 2020-07-27 | Gray | Kansas | 20069 | 54 | 0 |
377212 | 377212 | 2020-07-28 | Gray | Kansas | 20069 | 54 | 0 |
380429 | 380429 | 2020-07-29 | Gray | Kansas | 20069 | 57 | 0 |
383646 | 383646 | 2020-07-30 | Gray | Kansas | 20069 | 57 | 0 |
386864 | 386864 | 2020-07-31 | Gray | Kansas | 20069 | 64 | 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);