ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
14,081 rows where county = "Montgomery" sorted by fips
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date | county | state | fips ▼ | cases | deaths |
---|---|---|---|---|---|---|---|
258883 | 258883 | 2020-06-21 | Montgomery | Alabama | 1101 | 3258 | 81 |
262010 | 262010 | 2020-06-22 | Montgomery | Alabama | 1101 | 3297 | 81 |
265139 | 265139 | 2020-06-23 | Montgomery | Alabama | 1101 | 3351 | 87 |
268268 | 268268 | 2020-06-24 | Montgomery | Alabama | 1101 | 3441 | 90 |
271402 | 271402 | 2020-06-25 | Montgomery | Alabama | 1101 | 3514 | 91 |
274542 | 274542 | 2020-06-26 | Montgomery | Alabama | 1101 | 3569 | 94 |
277690 | 277690 | 2020-06-27 | Montgomery | Alabama | 1101 | 3624 | 95 |
280838 | 280838 | 2020-06-28 | Montgomery | Alabama | 1101 | 3630 | 95 |
283984 | 283984 | 2020-06-29 | Montgomery | Alabama | 1101 | 3777 | 96 |
287130 | 287130 | 2020-06-30 | Montgomery | Alabama | 1101 | 3839 | 97 |
290280 | 290280 | 2020-07-01 | Montgomery | Alabama | 1101 | 3890 | 102 |
293433 | 293433 | 2020-07-02 | Montgomery | Alabama | 1101 | 3925 | 104 |
296588 | 296588 | 2020-07-03 | Montgomery | Alabama | 1101 | 3994 | 105 |
299750 | 299750 | 2020-07-04 | Montgomery | Alabama | 1101 | 4068 | 105 |
302914 | 302914 | 2020-07-05 | Montgomery | Alabama | 1101 | 4174 | 105 |
306078 | 306078 | 2020-07-06 | Montgomery | Alabama | 1101 | 4205 | 105 |
309247 | 309247 | 2020-07-07 | Montgomery | Alabama | 1101 | 4293 | 107 |
312416 | 312416 | 2020-07-08 | Montgomery | Alabama | 1101 | 4321 | 111 |
315591 | 315591 | 2020-07-09 | Montgomery | Alabama | 1101 | 4386 | 111 |
318764 | 318764 | 2020-07-10 | Montgomery | Alabama | 1101 | 4445 | 113 |
321943 | 321943 | 2020-07-11 | Montgomery | Alabama | 1101 | 4478 | 114 |
325124 | 325124 | 2020-07-12 | Montgomery | Alabama | 1101 | 4595 | 114 |
328310 | 328310 | 2020-07-13 | Montgomery | Alabama | 1101 | 4649 | 114 |
331496 | 331496 | 2020-07-14 | Montgomery | Alabama | 1101 | 4739 | 116 |
334689 | 334689 | 2020-07-15 | Montgomery | Alabama | 1101 | 4783 | 120 |
337884 | 337884 | 2020-07-16 | Montgomery | Alabama | 1101 | 4864 | 121 |
341080 | 341080 | 2020-07-17 | Montgomery | Alabama | 1101 | 4913 | 124 |
344279 | 344279 | 2020-07-18 | Montgomery | Alabama | 1101 | 5045 | 126 |
347479 | 347479 | 2020-07-19 | Montgomery | Alabama | 1101 | 5120 | 127 |
350680 | 350680 | 2020-07-20 | Montgomery | Alabama | 1101 | 5241 | 127 |
353882 | 353882 | 2020-07-21 | Montgomery | Alabama | 1101 | 5310 | 128 |
357085 | 357085 | 2020-07-22 | Montgomery | Alabama | 1101 | 5397 | 130 |
360290 | 360290 | 2020-07-23 | Montgomery | Alabama | 1101 | 5499 | 133 |
363496 | 363496 | 2020-07-24 | Montgomery | Alabama | 1101 | 5599 | 137 |
366703 | 366703 | 2020-07-25 | Montgomery | Alabama | 1101 | 5684 | 138 |
369913 | 369913 | 2020-07-26 | Montgomery | Alabama | 1101 | 5724 | 140 |
373125 | 373125 | 2020-07-27 | Montgomery | Alabama | 1101 | 5850 | 141 |
376339 | 376339 | 2020-07-28 | Montgomery | Alabama | 1101 | 5921 | 141 |
379555 | 379555 | 2020-07-29 | Montgomery | Alabama | 1101 | 5971 | 141 |
382772 | 382772 | 2020-07-30 | Montgomery | Alabama | 1101 | 6045 | 142 |
385990 | 385990 | 2020-07-31 | Montgomery | Alabama | 1101 | 6139 | 144 |
389207 | 389207 | 2020-08-01 | Montgomery | Alabama | 1101 | 6189 | 144 |
392424 | 392424 | 2020-08-02 | Montgomery | Alabama | 1101 | 6294 | 146 |
395640 | 395640 | 2020-08-03 | Montgomery | Alabama | 1101 | 6347 | 146 |
398856 | 398856 | 2020-08-04 | Montgomery | Alabama | 1101 | 6406 | 150 |
402072 | 402072 | 2020-08-05 | Montgomery | Alabama | 1101 | 6455 | 151 |
405290 | 405290 | 2020-08-06 | Montgomery | Alabama | 1101 | 6564 | 151 |
408510 | 408510 | 2020-08-07 | Montgomery | Alabama | 1101 | 6654 | 151 |
411729 | 411729 | 2020-08-08 | Montgomery | Alabama | 1101 | 6742 | 151 |
414949 | 414949 | 2020-08-09 | Montgomery | Alabama | 1101 | 6970 | 151 |
418170 | 418170 | 2020-08-10 | Montgomery | Alabama | 1101 | 6970 | 152 |
421391 | 421391 | 2020-08-11 | Montgomery | Alabama | 1101 | 6969 | 154 |
424612 | 424612 | 2020-08-12 | Montgomery | Alabama | 1101 | 7099 | 156 |
427836 | 427836 | 2020-08-13 | Montgomery | Alabama | 1101 | 7145 | 156 |
431064 | 431064 | 2020-08-14 | Montgomery | Alabama | 1101 | 7156 | 156 |
434289 | 434289 | 2020-08-15 | Montgomery | Alabama | 1101 | 7219 | 156 |
437515 | 437515 | 2020-08-16 | Montgomery | Alabama | 1101 | 7303 | 156 |
440741 | 440741 | 2020-08-17 | Montgomery | Alabama | 1101 | 7317 | 156 |
443967 | 443967 | 2020-08-18 | Montgomery | Alabama | 1101 | 7382 | 156 |
447194 | 447194 | 2020-08-19 | Montgomery | Alabama | 1101 | 7416 | 156 |
450422 | 450422 | 2020-08-20 | Montgomery | Alabama | 1101 | 7457 | 159 |
453650 | 453650 | 2020-08-21 | Montgomery | Alabama | 1101 | 7539 | 159 |
456878 | 456878 | 2020-08-22 | Montgomery | Alabama | 1101 | 7561 | 158 |
460105 | 460105 | 2020-08-23 | Montgomery | Alabama | 1101 | 7576 | 158 |
463334 | 463334 | 2020-08-24 | Montgomery | Alabama | 1101 | 7642 | 158 |
466563 | 466563 | 2020-08-25 | Montgomery | Alabama | 1101 | 7658 | 158 |
469792 | 469792 | 2020-08-26 | Montgomery | Alabama | 1101 | 7697 | 159 |
473024 | 473024 | 2020-08-27 | Montgomery | Alabama | 1101 | 7786 | 160 |
476257 | 476257 | 2020-08-28 | Montgomery | Alabama | 1101 | 7818 | 162 |
479490 | 479490 | 2020-08-29 | Montgomery | Alabama | 1101 | 7881 | 163 |
482724 | 482724 | 2020-08-30 | Montgomery | Alabama | 1101 | 7976 | 163 |
485959 | 485959 | 2020-08-31 | Montgomery | Alabama | 1101 | 7992 | 163 |
489192 | 489192 | 2020-09-01 | Montgomery | Alabama | 1101 | 8053 | 164 |
492425 | 492425 | 2020-09-02 | Montgomery | Alabama | 1101 | 8069 | 164 |
495659 | 495659 | 2020-09-03 | Montgomery | Alabama | 1101 | 8100 | 164 |
498892 | 498892 | 2020-09-04 | Montgomery | Alabama | 1101 | 8131 | 166 |
502126 | 502126 | 2020-09-05 | Montgomery | Alabama | 1101 | 8171 | 166 |
505360 | 505360 | 2020-09-06 | Montgomery | Alabama | 1101 | 8196 | 166 |
508592 | 508592 | 2020-09-07 | Montgomery | Alabama | 1101 | 8236 | 166 |
511825 | 511825 | 2020-09-08 | Montgomery | Alabama | 1101 | 8246 | 166 |
515058 | 515058 | 2020-09-09 | Montgomery | Alabama | 1101 | 8268 | 166 |
518293 | 518293 | 2020-09-10 | Montgomery | Alabama | 1101 | 8310 | 169 |
521530 | 521530 | 2020-09-11 | Montgomery | Alabama | 1101 | 8349 | 170 |
524766 | 524766 | 2020-09-12 | Montgomery | Alabama | 1101 | 8390 | 170 |
528002 | 528002 | 2020-09-13 | Montgomery | Alabama | 1101 | 8446 | 170 |
531239 | 531239 | 2020-09-14 | Montgomery | Alabama | 1101 | 8487 | 170 |
534474 | 534474 | 2020-09-15 | Montgomery | Alabama | 1101 | 8509 | 170 |
537710 | 537710 | 2020-09-16 | Montgomery | Alabama | 1101 | 8546 | 170 |
540947 | 540947 | 2020-09-17 | Montgomery | Alabama | 1101 | 8560 | 170 |
544183 | 544183 | 2020-09-18 | Montgomery | Alabama | 1101 | 8598 | 173 |
547420 | 547420 | 2020-09-19 | Montgomery | Alabama | 1101 | 8628 | 173 |
550659 | 550659 | 2020-09-20 | Montgomery | Alabama | 1101 | 8674 | 173 |
553898 | 553898 | 2020-09-21 | Montgomery | Alabama | 1101 | 8688 | 173 |
557135 | 557135 | 2020-09-22 | Montgomery | Alabama | 1101 | 8711 | 175 |
560371 | 560371 | 2020-09-23 | Montgomery | Alabama | 1101 | 8748 | 177 |
563610 | 563610 | 2020-09-24 | Montgomery | Alabama | 1101 | 8778 | 179 |
566851 | 566851 | 2020-09-25 | Montgomery | Alabama | 1101 | 8811 | 183 |
570092 | 570092 | 2020-09-26 | Montgomery | Alabama | 1101 | 8834 | 184 |
573334 | 573334 | 2020-09-27 | Montgomery | Alabama | 1101 | 8852 | 184 |
576578 | 576578 | 2020-09-28 | Montgomery | Alabama | 1101 | 8865 | 184 |
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);