ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
800 rows where county = "Montgomery" and fips = 24031 sorted by county
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date | county ▼ | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
11447 | 11447 | 2020-03-25 | Montgomery | Maryland | 24031 | 127 | 1 |
13028 | 13028 | 2020-03-26 | Montgomery | Maryland | 24031 | 164 | 1 |
14736 | 14736 | 2020-03-27 | Montgomery | Maryland | 24031 | 208 | 1 |
16556 | 16556 | 2020-03-28 | Montgomery | Maryland | 24031 | 255 | 1 |
18471 | 18471 | 2020-03-29 | Montgomery | Maryland | 24031 | 301 | 1 |
20487 | 20487 | 2020-03-30 | Montgomery | Maryland | 24031 | 341 | 1 |
22596 | 22596 | 2020-03-31 | Montgomery | Maryland | 24031 | 388 | 1 |
24774 | 24774 | 2020-04-01 | Montgomery | Maryland | 24031 | 447 | 1 |
27026 | 27026 | 2020-04-02 | Montgomery | Maryland | 24031 | 498 | 6 |
29345 | 29345 | 2020-04-03 | Montgomery | Maryland | 24031 | 566 | 9 |
31723 | 31723 | 2020-04-04 | Montgomery | Maryland | 24031 | 640 | 9 |
34148 | 34148 | 2020-04-05 | Montgomery | Maryland | 24031 | 693 | 13 |
36607 | 36607 | 2020-04-06 | Montgomery | Maryland | 24031 | 793 | 19 |
39115 | 39115 | 2020-04-07 | Montgomery | Maryland | 24031 | 871 | 21 |
41667 | 41667 | 2020-04-08 | Montgomery | Maryland | 24031 | 1088 | 26 |
44243 | 44243 | 2020-04-09 | Montgomery | Maryland | 24031 | 1214 | 29 |
46851 | 46851 | 2020-04-10 | Montgomery | Maryland | 24031 | 1388 | 34 |
49493 | 49493 | 2020-04-11 | Montgomery | Maryland | 24031 | 1537 | 36 |
52163 | 52163 | 2020-04-12 | Montgomery | Maryland | 24031 | 1631 | 42 |
54844 | 54844 | 2020-04-13 | Montgomery | Maryland | 24031 | 1756 | 48 |
57542 | 57542 | 2020-04-14 | Montgomery | Maryland | 24031 | 1883 | 54 |
60250 | 60250 | 2020-04-15 | Montgomery | Maryland | 24031 | 1947 | 58 |
62971 | 62971 | 2020-04-16 | Montgomery | Maryland | 24031 | 2147 | 70 |
65709 | 65709 | 2020-04-17 | Montgomery | Maryland | 24031 | 2295 | 78 |
68459 | 68459 | 2020-04-18 | Montgomery | Maryland | 24031 | 2420 | 86 |
71223 | 71223 | 2020-04-19 | Montgomery | Maryland | 24031 | 2523 | 96 |
73995 | 73995 | 2020-04-20 | Montgomery | Maryland | 24031 | 2664 | 106 |
76775 | 76775 | 2020-04-21 | Montgomery | Maryland | 24031 | 2785 | 116 |
79561 | 79561 | 2020-04-22 | Montgomery | Maryland | 24031 | 2884 | 126 |
82356 | 82356 | 2020-04-23 | Montgomery | Maryland | 24031 | 3078 | 139 |
85160 | 85160 | 2020-04-24 | Montgomery | Maryland | 24031 | 3246 | 154 |
87970 | 87970 | 2020-04-25 | Montgomery | Maryland | 24031 | 3502 | 171 |
90786 | 90786 | 2020-04-26 | Montgomery | Maryland | 24031 | 3665 | 180 |
93607 | 93607 | 2020-04-27 | Montgomery | Maryland | 24031 | 3863 | 210 |
96442 | 96442 | 2020-04-28 | Montgomery | Maryland | 24031 | 4023 | 221 |
99288 | 99288 | 2020-04-29 | Montgomery | Maryland | 24031 | 4176 | 242 |
102140 | 102140 | 2020-04-30 | Montgomery | Maryland | 24031 | 4326 | 255 |
105000 | 105000 | 2020-05-01 | Montgomery | Maryland | 24031 | 4780 | 262 |
107864 | 107864 | 2020-05-02 | Montgomery | Maryland | 24031 | 4945 | 282 |
110736 | 110736 | 2020-05-03 | Montgomery | Maryland | 24031 | 5177 | 295 |
113614 | 113614 | 2020-05-04 | Montgomery | Maryland | 24031 | 5411 | 301 |
116495 | 116495 | 2020-05-05 | Montgomery | Maryland | 24031 | 5569 | 320 |
119456 | 119456 | 2020-05-06 | Montgomery | Maryland | 24031 | 5819 | 333 |
122428 | 122428 | 2020-05-07 | Montgomery | Maryland | 24031 | 6062 | 345 |
125410 | 125410 | 2020-05-08 | Montgomery | Maryland | 24031 | 6347 | 355 |
128397 | 128397 | 2020-05-09 | Montgomery | Maryland | 24031 | 6588 | 369 |
131387 | 131387 | 2020-05-10 | Montgomery | Maryland | 24031 | 6796 | 382 |
134378 | 134378 | 2020-05-11 | Montgomery | Maryland | 24031 | 6944 | 388 |
137368 | 137368 | 2020-05-12 | Montgomery | Maryland | 24031 | 7164 | 407 |
140362 | 140362 | 2020-05-13 | Montgomery | Maryland | 24031 | 7319 | 422 |
143357 | 143357 | 2020-05-14 | Montgomery | Maryland | 24031 | 7588 | 437 |
146357 | 146357 | 2020-05-15 | Montgomery | Maryland | 24031 | 7797 | 449 |
149362 | 149362 | 2020-05-16 | Montgomery | Maryland | 24031 | 8026 | 461 |
152373 | 152373 | 2020-05-17 | Montgomery | Maryland | 24031 | 8244 | 475 |
155387 | 155387 | 2020-05-18 | Montgomery | Maryland | 24031 | 8455 | 480 |
158405 | 158405 | 2020-05-19 | Montgomery | Maryland | 24031 | 8988 | 503 |
161431 | 161431 | 2020-05-20 | Montgomery | Maryland | 24031 | 9093 | 515 |
164460 | 164460 | 2020-05-21 | Montgomery | Maryland | 24031 | 9297 | 528 |
167496 | 167496 | 2020-05-22 | Montgomery | Maryland | 24031 | 9470 | 540 |
170533 | 170533 | 2020-05-23 | Montgomery | Maryland | 24031 | 9735 | 550 |
173575 | 173575 | 2020-05-24 | Montgomery | Maryland | 24031 | 9958 | 558 |
176618 | 176618 | 2020-05-25 | Montgomery | Maryland | 24031 | 10147 | 562 |
179662 | 179662 | 2020-05-26 | Montgomery | Maryland | 24031 | 10327 | 567 |
182708 | 182708 | 2020-05-27 | Montgomery | Maryland | 24031 | 10504 | 572 |
185763 | 185763 | 2020-05-28 | Montgomery | Maryland | 24031 | 10791 | 581 |
188821 | 188821 | 2020-05-29 | Montgomery | Maryland | 24031 | 11075 | 595 |
191885 | 191885 | 2020-05-30 | Montgomery | Maryland | 24031 | 11291 | 605 |
194953 | 194953 | 2020-05-31 | Montgomery | Maryland | 24031 | 11401 | 612 |
198024 | 198024 | 2020-06-01 | Montgomery | Maryland | 24031 | 11516 | 616 |
201096 | 201096 | 2020-06-02 | Montgomery | Maryland | 24031 | 11771 | 624 |
204173 | 204173 | 2020-06-03 | Montgomery | Maryland | 24031 | 11964 | 633 |
207254 | 207254 | 2020-06-04 | Montgomery | Maryland | 24031 | 12266 | 636 |
210335 | 210335 | 2020-06-05 | Montgomery | Maryland | 24031 | 12473 | 645 |
213419 | 213419 | 2020-06-06 | Montgomery | Maryland | 24031 | 12662 | 652 |
216507 | 216507 | 2020-06-07 | Montgomery | Maryland | 24031 | 12773 | 656 |
219599 | 219599 | 2020-06-08 | Montgomery | Maryland | 24031 | 12857 | 659 |
222694 | 222694 | 2020-06-09 | Montgomery | Maryland | 24031 | 13007 | 667 |
225790 | 225790 | 2020-06-10 | Montgomery | Maryland | 24031 | 13163 | 672 |
228892 | 228892 | 2020-06-11 | Montgomery | Maryland | 24031 | 13315 | 674 |
231996 | 231996 | 2020-06-12 | Montgomery | Maryland | 24031 | 13387 | 679 |
235101 | 235101 | 2020-06-13 | Montgomery | Maryland | 24031 | 13573 | 686 |
238208 | 238208 | 2020-06-14 | Montgomery | Maryland | 24031 | 13646 | 690 |
241317 | 241317 | 2020-06-15 | Montgomery | Maryland | 24031 | 13696 | 694 |
244428 | 244428 | 2020-06-16 | Montgomery | Maryland | 24031 | 13749 | 698 |
247541 | 247541 | 2020-06-17 | Montgomery | Maryland | 24031 | 13859 | 704 |
250653 | 250653 | 2020-06-18 | Montgomery | Maryland | 24031 | 13902 | 707 |
253768 | 253768 | 2020-06-19 | Montgomery | Maryland | 24031 | 13968 | 710 |
256888 | 256888 | 2020-06-20 | Montgomery | Maryland | 24031 | 14044 | 714 |
260014 | 260014 | 2020-06-21 | Montgomery | Maryland | 24031 | 14119 | 720 |
263143 | 263143 | 2020-06-22 | Montgomery | Maryland | 24031 | 14181 | 723 |
266269 | 266269 | 2020-06-23 | Montgomery | Maryland | 24031 | 14244 | 725 |
269402 | 269402 | 2020-06-24 | Montgomery | Maryland | 24031 | 14323 | 728 |
272539 | 272539 | 2020-06-25 | Montgomery | Maryland | 24031 | 14421 | 731 |
275682 | 275682 | 2020-06-26 | Montgomery | Maryland | 24031 | 14510 | 730 |
278830 | 278830 | 2020-06-27 | Montgomery | Maryland | 24031 | 14559 | 734 |
281978 | 281978 | 2020-06-28 | Montgomery | Maryland | 24031 | 14646 | 735 |
285123 | 285123 | 2020-06-29 | Montgomery | Maryland | 24031 | 14714 | 736 |
288273 | 288273 | 2020-06-30 | Montgomery | Maryland | 24031 | 14776 | 738 |
291424 | 291424 | 2020-07-01 | Montgomery | Maryland | 24031 | 14842 | 739 |
294578 | 294578 | 2020-07-02 | Montgomery | Maryland | 24031 | 14938 | 743 |
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);