ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
781 rows where county = "Montgomery" and state = "North Carolina" sorted by county
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date | county ▼ | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
10376 | 10376 | 2020-03-24 | Montgomery | North Carolina | 37123 | 1 | 0 |
11820 | 11820 | 2020-03-25 | Montgomery | North Carolina | 37123 | 1 | 0 |
13424 | 13424 | 2020-03-26 | Montgomery | North Carolina | 37123 | 3 | 0 |
15159 | 15159 | 2020-03-27 | Montgomery | North Carolina | 37123 | 3 | 0 |
16991 | 16991 | 2020-03-28 | Montgomery | North Carolina | 37123 | 3 | 0 |
18922 | 18922 | 2020-03-29 | Montgomery | North Carolina | 37123 | 3 | 0 |
20962 | 20962 | 2020-03-30 | Montgomery | North Carolina | 37123 | 3 | 0 |
23089 | 23089 | 2020-03-31 | Montgomery | North Carolina | 37123 | 6 | 0 |
25283 | 25283 | 2020-04-01 | Montgomery | North Carolina | 37123 | 7 | 0 |
27548 | 27548 | 2020-04-02 | Montgomery | North Carolina | 37123 | 8 | 1 |
29875 | 29875 | 2020-04-03 | Montgomery | North Carolina | 37123 | 8 | 1 |
32262 | 32262 | 2020-04-04 | Montgomery | North Carolina | 37123 | 9 | 1 |
34693 | 34693 | 2020-04-05 | Montgomery | North Carolina | 37123 | 9 | 1 |
37162 | 37162 | 2020-04-06 | Montgomery | North Carolina | 37123 | 9 | 1 |
39677 | 39677 | 2020-04-07 | Montgomery | North Carolina | 37123 | 10 | 1 |
42234 | 42234 | 2020-04-08 | Montgomery | North Carolina | 37123 | 10 | 1 |
44818 | 44818 | 2020-04-09 | Montgomery | North Carolina | 37123 | 12 | 1 |
47431 | 47431 | 2020-04-10 | Montgomery | North Carolina | 37123 | 12 | 1 |
50086 | 50086 | 2020-04-11 | Montgomery | North Carolina | 37123 | 12 | 1 |
52759 | 52759 | 2020-04-12 | Montgomery | North Carolina | 37123 | 12 | 1 |
55443 | 55443 | 2020-04-13 | Montgomery | North Carolina | 37123 | 12 | 1 |
58143 | 58143 | 2020-04-14 | Montgomery | North Carolina | 37123 | 14 | 1 |
60857 | 60857 | 2020-04-15 | Montgomery | North Carolina | 37123 | 15 | 1 |
63583 | 63583 | 2020-04-16 | Montgomery | North Carolina | 37123 | 15 | 1 |
66326 | 66326 | 2020-04-17 | Montgomery | North Carolina | 37123 | 17 | 1 |
69083 | 69083 | 2020-04-18 | Montgomery | North Carolina | 37123 | 17 | 1 |
71849 | 71849 | 2020-04-19 | Montgomery | North Carolina | 37123 | 18 | 1 |
74624 | 74624 | 2020-04-20 | Montgomery | North Carolina | 37123 | 18 | 1 |
77405 | 77405 | 2020-04-21 | Montgomery | North Carolina | 37123 | 18 | 1 |
80194 | 80194 | 2020-04-22 | Montgomery | North Carolina | 37123 | 18 | 1 |
82993 | 82993 | 2020-04-23 | Montgomery | North Carolina | 37123 | 19 | 1 |
85797 | 85797 | 2020-04-24 | Montgomery | North Carolina | 37123 | 20 | 1 |
88610 | 88610 | 2020-04-25 | Montgomery | North Carolina | 37123 | 20 | 1 |
91425 | 91425 | 2020-04-26 | Montgomery | North Carolina | 37123 | 21 | 1 |
94251 | 94251 | 2020-04-27 | Montgomery | North Carolina | 37123 | 22 | 1 |
97088 | 97088 | 2020-04-28 | Montgomery | North Carolina | 37123 | 28 | 1 |
99936 | 99936 | 2020-04-29 | Montgomery | North Carolina | 37123 | 31 | 1 |
102789 | 102789 | 2020-04-30 | Montgomery | North Carolina | 37123 | 33 | 1 |
105651 | 105651 | 2020-05-01 | Montgomery | North Carolina | 37123 | 35 | 2 |
108518 | 108518 | 2020-05-02 | Montgomery | North Carolina | 37123 | 36 | 2 |
111391 | 111391 | 2020-05-03 | Montgomery | North Carolina | 37123 | 36 | 2 |
114272 | 114272 | 2020-05-04 | Montgomery | North Carolina | 37123 | 36 | 2 |
117152 | 117152 | 2020-05-05 | Montgomery | North Carolina | 37123 | 38 | 2 |
120113 | 120113 | 2020-05-06 | Montgomery | North Carolina | 37123 | 41 | 2 |
123088 | 123088 | 2020-05-07 | Montgomery | North Carolina | 37123 | 43 | 2 |
126071 | 126071 | 2020-05-08 | Montgomery | North Carolina | 37123 | 41 | 2 |
129060 | 129060 | 2020-05-09 | Montgomery | North Carolina | 37123 | 41 | 2 |
132049 | 132049 | 2020-05-10 | Montgomery | North Carolina | 37123 | 41 | 2 |
135040 | 135040 | 2020-05-11 | Montgomery | North Carolina | 37123 | 42 | 2 |
138030 | 138030 | 2020-05-12 | Montgomery | North Carolina | 37123 | 43 | 2 |
141026 | 141026 | 2020-05-13 | Montgomery | North Carolina | 37123 | 43 | 2 |
144021 | 144021 | 2020-05-14 | Montgomery | North Carolina | 37123 | 47 | 3 |
147022 | 147022 | 2020-05-15 | Montgomery | North Carolina | 37123 | 48 | 3 |
150029 | 150029 | 2020-05-16 | Montgomery | North Carolina | 37123 | 56 | 3 |
153039 | 153039 | 2020-05-17 | Montgomery | North Carolina | 37123 | 56 | 3 |
156056 | 156056 | 2020-05-18 | Montgomery | North Carolina | 37123 | 57 | 3 |
159075 | 159075 | 2020-05-19 | Montgomery | North Carolina | 37123 | 65 | 3 |
162102 | 162102 | 2020-05-20 | Montgomery | North Carolina | 37123 | 68 | 3 |
165131 | 165131 | 2020-05-21 | Montgomery | North Carolina | 37123 | 74 | 3 |
168166 | 168166 | 2020-05-22 | Montgomery | North Carolina | 37123 | 78 | 3 |
171205 | 171205 | 2020-05-23 | Montgomery | North Carolina | 37123 | 84 | 3 |
174247 | 174247 | 2020-05-24 | Montgomery | North Carolina | 37123 | 84 | 3 |
177291 | 177291 | 2020-05-25 | Montgomery | North Carolina | 37123 | 86 | 3 |
180334 | 180334 | 2020-05-26 | Montgomery | North Carolina | 37123 | 88 | 3 |
183382 | 183382 | 2020-05-27 | Montgomery | North Carolina | 37123 | 93 | 3 |
186439 | 186439 | 2020-05-28 | Montgomery | North Carolina | 37123 | 104 | 4 |
189499 | 189499 | 2020-05-29 | Montgomery | North Carolina | 37123 | 110 | 4 |
192563 | 192563 | 2020-05-30 | Montgomery | North Carolina | 37123 | 123 | 4 |
195633 | 195633 | 2020-05-31 | Montgomery | North Carolina | 37123 | 128 | 4 |
198706 | 198706 | 2020-06-01 | Montgomery | North Carolina | 37123 | 128 | 4 |
201780 | 201780 | 2020-06-02 | Montgomery | North Carolina | 37123 | 132 | 4 |
204857 | 204857 | 2020-06-03 | Montgomery | North Carolina | 37123 | 141 | 4 |
207938 | 207938 | 2020-06-04 | Montgomery | North Carolina | 37123 | 142 | 4 |
211020 | 211020 | 2020-06-05 | Montgomery | North Carolina | 37123 | 149 | 4 |
214104 | 214104 | 2020-06-06 | Montgomery | North Carolina | 37123 | 155 | 4 |
217194 | 217194 | 2020-06-07 | Montgomery | North Carolina | 37123 | 160 | 4 |
220286 | 220286 | 2020-06-08 | Montgomery | North Carolina | 37123 | 165 | 4 |
223380 | 223380 | 2020-06-09 | Montgomery | North Carolina | 37123 | 164 | 5 |
226480 | 226480 | 2020-06-10 | Montgomery | North Carolina | 37123 | 170 | 5 |
229584 | 229584 | 2020-06-11 | Montgomery | North Carolina | 37123 | 172 | 5 |
232689 | 232689 | 2020-06-12 | Montgomery | North Carolina | 37123 | 185 | 5 |
235794 | 235794 | 2020-06-13 | Montgomery | North Carolina | 37123 | 198 | 5 |
238902 | 238902 | 2020-06-14 | Montgomery | North Carolina | 37123 | 204 | 5 |
242011 | 242011 | 2020-06-15 | Montgomery | North Carolina | 37123 | 210 | 5 |
245123 | 245123 | 2020-06-16 | Montgomery | North Carolina | 37123 | 211 | 5 |
248236 | 248236 | 2020-06-17 | Montgomery | North Carolina | 37123 | 218 | 5 |
251351 | 251351 | 2020-06-18 | Montgomery | North Carolina | 37123 | 229 | 5 |
254466 | 254466 | 2020-06-19 | Montgomery | North Carolina | 37123 | 234 | 5 |
257589 | 257589 | 2020-06-20 | Montgomery | North Carolina | 37123 | 245 | 6 |
260716 | 260716 | 2020-06-21 | Montgomery | North Carolina | 37123 | 246 | 6 |
263844 | 263844 | 2020-06-22 | Montgomery | North Carolina | 37123 | 252 | 6 |
266972 | 266972 | 2020-06-23 | Montgomery | North Carolina | 37123 | 253 | 7 |
270106 | 270106 | 2020-06-24 | Montgomery | North Carolina | 37123 | 260 | 7 |
273245 | 273245 | 2020-06-25 | Montgomery | North Carolina | 37123 | 269 | 7 |
276391 | 276391 | 2020-06-26 | Montgomery | North Carolina | 37123 | 274 | 7 |
279539 | 279539 | 2020-06-27 | Montgomery | North Carolina | 37123 | 284 | 7 |
282685 | 282685 | 2020-06-28 | Montgomery | North Carolina | 37123 | 298 | 7 |
285830 | 285830 | 2020-06-29 | Montgomery | North Carolina | 37123 | 305 | 7 |
288980 | 288980 | 2020-06-30 | Montgomery | North Carolina | 37123 | 309 | 7 |
292132 | 292132 | 2020-07-01 | Montgomery | North Carolina | 37123 | 317 | 7 |
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);