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)
Suggested facets: date (date)
Link | rowid | date | county | state | fips ▼ | cases | deaths |
---|---|---|---|---|---|---|---|
1623 | 1623 | 2020-03-13 | Montgomery | Alabama | 1101 | 1 | 0 |
1939 | 1939 | 2020-03-14 | Montgomery | Alabama | 1101 | 1 | 0 |
2315 | 2315 | 2020-03-15 | Montgomery | Alabama | 1101 | 1 | 0 |
2744 | 2744 | 2020-03-16 | Montgomery | Alabama | 1101 | 2 | 0 |
3221 | 3221 | 2020-03-17 | Montgomery | Alabama | 1101 | 2 | 0 |
3768 | 3768 | 2020-03-18 | Montgomery | Alabama | 1101 | 2 | 0 |
4410 | 4410 | 2020-03-19 | Montgomery | Alabama | 1101 | 3 | 0 |
5180 | 5180 | 2020-03-20 | Montgomery | Alabama | 1101 | 3 | 0 |
6097 | 6097 | 2020-03-21 | Montgomery | Alabama | 1101 | 3 | 0 |
7131 | 7131 | 2020-03-22 | Montgomery | Alabama | 1101 | 3 | 0 |
8271 | 8271 | 2020-03-23 | Montgomery | Alabama | 1101 | 4 | 0 |
9498 | 9498 | 2020-03-24 | Montgomery | Alabama | 1101 | 9 | 0 |
10864 | 10864 | 2020-03-25 | Montgomery | Alabama | 1101 | 13 | 0 |
12403 | 12403 | 2020-03-26 | Montgomery | Alabama | 1101 | 17 | 0 |
14064 | 14064 | 2020-03-27 | Montgomery | Alabama | 1101 | 18 | 0 |
15843 | 15843 | 2020-03-28 | Montgomery | Alabama | 1101 | 18 | 0 |
17727 | 17727 | 2020-03-29 | Montgomery | Alabama | 1101 | 22 | 0 |
19699 | 19699 | 2020-03-30 | Montgomery | Alabama | 1101 | 29 | 0 |
21771 | 21771 | 2020-03-31 | Montgomery | Alabama | 1101 | 31 | 1 |
23927 | 23927 | 2020-04-01 | Montgomery | Alabama | 1101 | 35 | 1 |
26149 | 26149 | 2020-04-02 | Montgomery | Alabama | 1101 | 46 | 1 |
28446 | 28446 | 2020-04-03 | Montgomery | Alabama | 1101 | 61 | 1 |
30803 | 30803 | 2020-04-04 | Montgomery | Alabama | 1101 | 63 | 1 |
33207 | 33207 | 2020-04-05 | Montgomery | Alabama | 1101 | 71 | 1 |
35646 | 35646 | 2020-04-06 | Montgomery | Alabama | 1101 | 71 | 1 |
38134 | 38134 | 2020-04-07 | Montgomery | Alabama | 1101 | 74 | 1 |
40676 | 40676 | 2020-04-08 | Montgomery | Alabama | 1101 | 81 | 2 |
43249 | 43249 | 2020-04-09 | Montgomery | Alabama | 1101 | 90 | 3 |
45847 | 45847 | 2020-04-10 | Montgomery | Alabama | 1101 | 92 | 4 |
48476 | 48476 | 2020-04-11 | Montgomery | Alabama | 1101 | 106 | 4 |
51138 | 51138 | 2020-04-12 | Montgomery | Alabama | 1101 | 120 | 4 |
53816 | 53816 | 2020-04-13 | Montgomery | Alabama | 1101 | 149 | 5 |
56508 | 56508 | 2020-04-14 | Montgomery | Alabama | 1101 | 161 | 5 |
59216 | 59216 | 2020-04-15 | Montgomery | Alabama | 1101 | 189 | 5 |
61934 | 61934 | 2020-04-16 | Montgomery | Alabama | 1101 | 201 | 5 |
64667 | 64667 | 2020-04-17 | Montgomery | Alabama | 1101 | 207 | 5 |
67415 | 67415 | 2020-04-18 | Montgomery | Alabama | 1101 | 217 | 3 |
70177 | 70177 | 2020-04-19 | Montgomery | Alabama | 1101 | 226 | 3 |
72946 | 72946 | 2020-04-20 | Montgomery | Alabama | 1101 | 231 | 3 |
75722 | 75722 | 2020-04-21 | Montgomery | Alabama | 1101 | 245 | 3 |
78505 | 78505 | 2020-04-22 | Montgomery | Alabama | 1101 | 253 | 3 |
81298 | 81298 | 2020-04-23 | Montgomery | Alabama | 1101 | 263 | 3 |
84099 | 84099 | 2020-04-24 | Montgomery | Alabama | 1101 | 274 | 4 |
86907 | 86907 | 2020-04-25 | Montgomery | Alabama | 1101 | 284 | 4 |
89723 | 89723 | 2020-04-26 | Montgomery | Alabama | 1101 | 289 | 4 |
92541 | 92541 | 2020-04-27 | Montgomery | Alabama | 1101 | 292 | 5 |
95371 | 95371 | 2020-04-28 | Montgomery | Alabama | 1101 | 302 | 5 |
98216 | 98216 | 2020-04-29 | Montgomery | Alabama | 1101 | 318 | 6 |
101066 | 101066 | 2020-04-30 | Montgomery | Alabama | 1101 | 337 | 6 |
103921 | 103921 | 2020-05-01 | Montgomery | Alabama | 1101 | 355 | 6 |
106786 | 106786 | 2020-05-02 | Montgomery | Alabama | 1101 | 379 | 6 |
109655 | 109655 | 2020-05-03 | Montgomery | Alabama | 1101 | 409 | 7 |
112530 | 112530 | 2020-05-04 | Montgomery | Alabama | 1101 | 438 | 8 |
115413 | 115413 | 2020-05-05 | Montgomery | Alabama | 1101 | 456 | 8 |
118372 | 118372 | 2020-05-06 | Montgomery | Alabama | 1101 | 477 | 12 |
121338 | 121338 | 2020-05-07 | Montgomery | Alabama | 1101 | 515 | 13 |
124318 | 124318 | 2020-05-08 | Montgomery | Alabama | 1101 | 533 | 15 |
127303 | 127303 | 2020-05-09 | Montgomery | Alabama | 1101 | 576 | 15 |
130293 | 130293 | 2020-05-10 | Montgomery | Alabama | 1101 | 608 | 15 |
133283 | 133283 | 2020-05-11 | Montgomery | Alabama | 1101 | 642 | 15 |
136273 | 136273 | 2020-05-12 | Montgomery | Alabama | 1101 | 684 | 18 |
139264 | 139264 | 2020-05-13 | Montgomery | Alabama | 1101 | 705 | 19 |
142260 | 142260 | 2020-05-14 | Montgomery | Alabama | 1101 | 753 | 20 |
145259 | 145259 | 2020-05-15 | Montgomery | Alabama | 1101 | 787 | 20 |
148262 | 148262 | 2020-05-16 | Montgomery | Alabama | 1101 | 816 | 20 |
151271 | 151271 | 2020-05-17 | Montgomery | Alabama | 1101 | 823 | 20 |
154283 | 154283 | 2020-05-18 | Montgomery | Alabama | 1101 | 863 | 20 |
157299 | 157299 | 2020-05-19 | Montgomery | Alabama | 1101 | 907 | 24 |
160323 | 160323 | 2020-05-20 | Montgomery | Alabama | 1101 | 994 | 27 |
163351 | 163351 | 2020-05-21 | Montgomery | Alabama | 1101 | 1052 | 28 |
166383 | 166383 | 2020-05-22 | Montgomery | Alabama | 1101 | 1096 | 29 |
169419 | 169419 | 2020-05-23 | Montgomery | Alabama | 1101 | 1147 | 30 |
172460 | 172460 | 2020-05-24 | Montgomery | Alabama | 1101 | 1186 | 30 |
175503 | 175503 | 2020-05-25 | Montgomery | Alabama | 1101 | 1274 | 33 |
178548 | 178548 | 2020-05-26 | Montgomery | Alabama | 1101 | 1384 | 34 |
181592 | 181592 | 2020-05-27 | Montgomery | Alabama | 1101 | 1446 | 34 |
184644 | 184644 | 2020-05-28 | Montgomery | Alabama | 1101 | 1541 | 34 |
187701 | 187701 | 2020-05-29 | Montgomery | Alabama | 1101 | 1590 | 38 |
190765 | 190765 | 2020-05-30 | Montgomery | Alabama | 1101 | 1632 | 38 |
193831 | 193831 | 2020-05-31 | Montgomery | Alabama | 1101 | 1710 | 40 |
196901 | 196901 | 2020-06-01 | Montgomery | Alabama | 1101 | 1778 | 44 |
199974 | 199974 | 2020-06-02 | Montgomery | Alabama | 1101 | 1824 | 44 |
203050 | 203050 | 2020-06-03 | Montgomery | Alabama | 1101 | 1845 | 44 |
206129 | 206129 | 2020-06-04 | Montgomery | Alabama | 1101 | 1881 | 44 |
209211 | 209211 | 2020-06-05 | Montgomery | Alabama | 1101 | 1929 | 45 |
212296 | 212296 | 2020-06-06 | Montgomery | Alabama | 1101 | 2023 | 48 |
215383 | 215383 | 2020-06-07 | Montgomery | Alabama | 1101 | 2084 | 49 |
218473 | 218473 | 2020-06-08 | Montgomery | Alabama | 1101 | 2158 | 55 |
221565 | 221565 | 2020-06-09 | Montgomery | Alabama | 1101 | 2256 | 57 |
224661 | 224661 | 2020-06-10 | Montgomery | Alabama | 1101 | 2326 | 62 |
227762 | 227762 | 2020-06-11 | Montgomery | Alabama | 1101 | 2472 | 66 |
230866 | 230866 | 2020-06-12 | Montgomery | Alabama | 1101 | 2581 | 69 |
233971 | 233971 | 2020-06-13 | Montgomery | Alabama | 1101 | 2683 | 69 |
237078 | 237078 | 2020-06-14 | Montgomery | Alabama | 1101 | 2830 | 69 |
240186 | 240186 | 2020-06-15 | Montgomery | Alabama | 1101 | 2910 | 69 |
243297 | 243297 | 2020-06-16 | Montgomery | Alabama | 1101 | 2961 | 71 |
246410 | 246410 | 2020-06-17 | Montgomery | Alabama | 1101 | 2996 | 72 |
249522 | 249522 | 2020-06-18 | Montgomery | Alabama | 1101 | 3101 | 75 |
252637 | 252637 | 2020-06-19 | Montgomery | Alabama | 1101 | 3149 | 77 |
255756 | 255756 | 2020-06-20 | Montgomery | Alabama | 1101 | 3222 | 81 |
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);