ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
776 rows where county = "Montgomery" and fips = 20125 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
535378 | 535378 | 2020-09-15 | Montgomery | Kansas | 20125 | 333 | 5 |
532143 | 532143 | 2020-09-14 | Montgomery | Kansas | 20125 | 333 | 5 |
528906 | 528906 | 2020-09-13 | Montgomery | Kansas | 20125 | 321 | 5 |
525670 | 525670 | 2020-09-12 | Montgomery | Kansas | 20125 | 321 | 5 |
522434 | 522434 | 2020-09-11 | Montgomery | Kansas | 20125 | 321 | 5 |
519197 | 519197 | 2020-09-10 | Montgomery | Kansas | 20125 | 286 | 5 |
515962 | 515962 | 2020-09-09 | Montgomery | Kansas | 20125 | 286 | 5 |
512729 | 512729 | 2020-09-08 | Montgomery | Kansas | 20125 | 286 | 5 |
509496 | 509496 | 2020-09-07 | Montgomery | Kansas | 20125 | 282 | 5 |
506264 | 506264 | 2020-09-06 | Montgomery | Kansas | 20125 | 282 | 5 |
503030 | 503030 | 2020-09-05 | Montgomery | Kansas | 20125 | 282 | 5 |
499796 | 499796 | 2020-09-04 | Montgomery | Kansas | 20125 | 281 | 5 |
496563 | 496563 | 2020-09-03 | Montgomery | Kansas | 20125 | 269 | 5 |
493329 | 493329 | 2020-09-02 | Montgomery | Kansas | 20125 | 266 | 5 |
490096 | 490096 | 2020-09-01 | Montgomery | Kansas | 20125 | 257 | 5 |
486863 | 486863 | 2020-08-31 | Montgomery | Kansas | 20125 | 252 | 5 |
483628 | 483628 | 2020-08-30 | Montgomery | Kansas | 20125 | 244 | 5 |
480394 | 480394 | 2020-08-29 | Montgomery | Kansas | 20125 | 244 | 5 |
477161 | 477161 | 2020-08-28 | Montgomery | Kansas | 20125 | 233 | 5 |
473928 | 473928 | 2020-08-27 | Montgomery | Kansas | 20125 | 224 | 5 |
470696 | 470696 | 2020-08-26 | Montgomery | Kansas | 20125 | 217 | 5 |
467467 | 467467 | 2020-08-25 | Montgomery | Kansas | 20125 | 214 | 5 |
464238 | 464238 | 2020-08-24 | Montgomery | Kansas | 20125 | 208 | 5 |
461009 | 461009 | 2020-08-23 | Montgomery | Kansas | 20125 | 205 | 5 |
457782 | 457782 | 2020-08-22 | Montgomery | Kansas | 20125 | 205 | 5 |
454554 | 454554 | 2020-08-21 | Montgomery | Kansas | 20125 | 201 | 5 |
451326 | 451326 | 2020-08-20 | Montgomery | Kansas | 20125 | 195 | 5 |
448098 | 448098 | 2020-08-19 | Montgomery | Kansas | 20125 | 190 | 5 |
444871 | 444871 | 2020-08-18 | Montgomery | Kansas | 20125 | 190 | 5 |
441645 | 441645 | 2020-08-17 | Montgomery | Kansas | 20125 | 190 | 5 |
438418 | 438418 | 2020-08-16 | Montgomery | Kansas | 20125 | 186 | 5 |
435193 | 435193 | 2020-08-15 | Montgomery | Kansas | 20125 | 186 | 5 |
431968 | 431968 | 2020-08-14 | Montgomery | Kansas | 20125 | 183 | 5 |
428740 | 428740 | 2020-08-13 | Montgomery | Kansas | 20125 | 177 | 5 |
425516 | 425516 | 2020-08-12 | Montgomery | Kansas | 20125 | 170 | 5 |
422295 | 422295 | 2020-08-11 | Montgomery | Kansas | 20125 | 170 | 5 |
419072 | 419072 | 2020-08-10 | Montgomery | Kansas | 20125 | 170 | 5 |
415851 | 415851 | 2020-08-09 | Montgomery | Kansas | 20125 | 167 | 5 |
412631 | 412631 | 2020-08-08 | Montgomery | Kansas | 20125 | 167 | 5 |
409411 | 409411 | 2020-08-07 | Montgomery | Kansas | 20125 | 166 | 5 |
406192 | 406192 | 2020-08-06 | Montgomery | Kansas | 20125 | 164 | 5 |
402974 | 402974 | 2020-08-05 | Montgomery | Kansas | 20125 | 162 | 5 |
399757 | 399757 | 2020-08-04 | Montgomery | Kansas | 20125 | 162 | 5 |
396542 | 396542 | 2020-08-03 | Montgomery | Kansas | 20125 | 161 | 5 |
393326 | 393326 | 2020-08-02 | Montgomery | Kansas | 20125 | 152 | 5 |
390109 | 390109 | 2020-08-01 | Montgomery | Kansas | 20125 | 152 | 5 |
386892 | 386892 | 2020-07-31 | Montgomery | Kansas | 20125 | 152 | 5 |
383674 | 383674 | 2020-07-30 | Montgomery | Kansas | 20125 | 145 | 4 |
380457 | 380457 | 2020-07-29 | Montgomery | Kansas | 20125 | 134 | 4 |
377240 | 377240 | 2020-07-28 | Montgomery | Kansas | 20125 | 134 | 4 |
374025 | 374025 | 2020-07-27 | Montgomery | Kansas | 20125 | 132 | 4 |
370813 | 370813 | 2020-07-26 | Montgomery | Kansas | 20125 | 120 | 4 |
367603 | 367603 | 2020-07-25 | Montgomery | Kansas | 20125 | 120 | 4 |
364396 | 364396 | 2020-07-24 | Montgomery | Kansas | 20125 | 119 | 4 |
361189 | 361189 | 2020-07-23 | Montgomery | Kansas | 20125 | 106 | 3 |
357984 | 357984 | 2020-07-22 | Montgomery | Kansas | 20125 | 106 | 3 |
354782 | 354782 | 2020-07-21 | Montgomery | Kansas | 20125 | 102 | 3 |
351580 | 351580 | 2020-07-20 | Montgomery | Kansas | 20125 | 102 | 3 |
348380 | 348380 | 2020-07-19 | Montgomery | Kansas | 20125 | 74 | 3 |
345179 | 345179 | 2020-07-18 | Montgomery | Kansas | 20125 | 74 | 3 |
341979 | 341979 | 2020-07-17 | Montgomery | Kansas | 20125 | 74 | 3 |
338783 | 338783 | 2020-07-16 | Montgomery | Kansas | 20125 | 69 | 3 |
335587 | 335587 | 2020-07-15 | Montgomery | Kansas | 20125 | 69 | 3 |
332394 | 332394 | 2020-07-14 | Montgomery | Kansas | 20125 | 67 | 3 |
329207 | 329207 | 2020-07-13 | Montgomery | Kansas | 20125 | 67 | 3 |
326021 | 326021 | 2020-07-12 | Montgomery | Kansas | 20125 | 58 | 3 |
322838 | 322838 | 2020-07-11 | Montgomery | Kansas | 20125 | 58 | 3 |
319659 | 319659 | 2020-07-10 | Montgomery | Kansas | 20125 | 58 | 3 |
316485 | 316485 | 2020-07-09 | Montgomery | Kansas | 20125 | 53 | 3 |
313311 | 313311 | 2020-07-08 | Montgomery | Kansas | 20125 | 53 | 3 |
310141 | 310141 | 2020-07-07 | Montgomery | Kansas | 20125 | 49 | 3 |
306973 | 306973 | 2020-07-06 | Montgomery | Kansas | 20125 | 49 | 3 |
303806 | 303806 | 2020-07-05 | Montgomery | Kansas | 20125 | 41 | 3 |
300642 | 300642 | 2020-07-04 | Montgomery | Kansas | 20125 | 41 | 3 |
297480 | 297480 | 2020-07-03 | Montgomery | Kansas | 20125 | 41 | 3 |
294322 | 294322 | 2020-07-02 | Montgomery | Kansas | 20125 | 36 | 3 |
291168 | 291168 | 2020-07-01 | Montgomery | Kansas | 20125 | 36 | 3 |
288018 | 288018 | 2020-06-30 | Montgomery | Kansas | 20125 | 36 | 3 |
284869 | 284869 | 2020-06-29 | Montgomery | Kansas | 20125 | 36 | 3 |
281724 | 281724 | 2020-06-28 | Montgomery | Kansas | 20125 | 29 | 3 |
278576 | 278576 | 2020-06-27 | Montgomery | Kansas | 20125 | 29 | 3 |
275428 | 275428 | 2020-06-26 | Montgomery | Kansas | 20125 | 29 | 3 |
272285 | 272285 | 2020-06-25 | Montgomery | Kansas | 20125 | 25 | 3 |
269148 | 269148 | 2020-06-24 | Montgomery | Kansas | 20125 | 25 | 3 |
266016 | 266016 | 2020-06-23 | Montgomery | Kansas | 20125 | 25 | 3 |
262888 | 262888 | 2020-06-22 | Montgomery | Kansas | 20125 | 25 | 3 |
259761 | 259761 | 2020-06-21 | Montgomery | Kansas | 20125 | 25 | 3 |
256635 | 256635 | 2020-06-20 | Montgomery | Kansas | 20125 | 25 | 3 |
253515 | 253515 | 2020-06-19 | Montgomery | Kansas | 20125 | 25 | 3 |
250400 | 250400 | 2020-06-18 | Montgomery | Kansas | 20125 | 23 | 2 |
247288 | 247288 | 2020-06-17 | Montgomery | Kansas | 20125 | 23 | 2 |
244175 | 244175 | 2020-06-16 | Montgomery | Kansas | 20125 | 22 | 2 |
241064 | 241064 | 2020-06-15 | Montgomery | Kansas | 20125 | 22 | 2 |
237955 | 237955 | 2020-06-14 | Montgomery | Kansas | 20125 | 21 | 2 |
234848 | 234848 | 2020-06-13 | Montgomery | Kansas | 20125 | 21 | 2 |
231742 | 231742 | 2020-06-12 | Montgomery | Kansas | 20125 | 21 | 2 |
228639 | 228639 | 2020-06-11 | Montgomery | Kansas | 20125 | 20 | 2 |
225537 | 225537 | 2020-06-10 | Montgomery | Kansas | 20125 | 20 | 2 |
222442 | 222442 | 2020-06-09 | Montgomery | Kansas | 20125 | 20 | 2 |
219347 | 219347 | 2020-06-08 | Montgomery | Kansas | 20125 | 20 | 2 |
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);