ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
777 rows where county = "Montgomery" and state = "Virginia" sorted by fips
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date | county | state | fips ▼ | cases | deaths |
---|---|---|---|---|---|---|---|
17541 | 17541 | 2020-03-28 | Montgomery | Virginia | 51121 | 1 | 0 |
19503 | 19503 | 2020-03-29 | Montgomery | Virginia | 51121 | 1 | 0 |
21568 | 21568 | 2020-03-30 | Montgomery | Virginia | 51121 | 1 | 0 |
23714 | 23714 | 2020-03-31 | Montgomery | Virginia | 51121 | 1 | 0 |
25930 | 25930 | 2020-04-01 | Montgomery | Virginia | 51121 | 1 | 0 |
28220 | 28220 | 2020-04-02 | Montgomery | Virginia | 51121 | 1 | 0 |
30567 | 30567 | 2020-04-03 | Montgomery | Virginia | 51121 | 1 | 0 |
32966 | 32966 | 2020-04-04 | Montgomery | Virginia | 51121 | 6 | 0 |
35404 | 35404 | 2020-04-05 | Montgomery | Virginia | 51121 | 6 | 0 |
37887 | 37887 | 2020-04-06 | Montgomery | Virginia | 51121 | 7 | 0 |
40421 | 40421 | 2020-04-07 | Montgomery | Virginia | 51121 | 16 | 0 |
42990 | 42990 | 2020-04-08 | Montgomery | Virginia | 51121 | 16 | 0 |
45586 | 45586 | 2020-04-09 | Montgomery | Virginia | 51121 | 17 | 0 |
48212 | 48212 | 2020-04-10 | Montgomery | Virginia | 51121 | 18 | 0 |
50870 | 50870 | 2020-04-11 | Montgomery | Virginia | 51121 | 31 | 0 |
53545 | 53545 | 2020-04-12 | Montgomery | Virginia | 51121 | 32 | 0 |
56235 | 56235 | 2020-04-13 | Montgomery | Virginia | 51121 | 32 | 0 |
58941 | 58941 | 2020-04-14 | Montgomery | Virginia | 51121 | 33 | 0 |
61660 | 61660 | 2020-04-15 | Montgomery | Virginia | 51121 | 34 | 0 |
64393 | 64393 | 2020-04-16 | Montgomery | Virginia | 51121 | 34 | 0 |
67141 | 67141 | 2020-04-17 | Montgomery | Virginia | 51121 | 40 | 0 |
69903 | 69903 | 2020-04-18 | Montgomery | Virginia | 51121 | 42 | 0 |
72673 | 72673 | 2020-04-19 | Montgomery | Virginia | 51121 | 42 | 0 |
75449 | 75449 | 2020-04-20 | Montgomery | Virginia | 51121 | 44 | 0 |
78231 | 78231 | 2020-04-21 | Montgomery | Virginia | 51121 | 48 | 0 |
81024 | 81024 | 2020-04-22 | Montgomery | Virginia | 51121 | 50 | 0 |
83825 | 83825 | 2020-04-23 | Montgomery | Virginia | 51121 | 50 | 0 |
86632 | 86632 | 2020-04-24 | Montgomery | Virginia | 51121 | 50 | 0 |
89447 | 89447 | 2020-04-25 | Montgomery | Virginia | 51121 | 51 | 1 |
92264 | 92264 | 2020-04-26 | Montgomery | Virginia | 51121 | 51 | 1 |
95093 | 95093 | 2020-04-27 | Montgomery | Virginia | 51121 | 54 | 1 |
97937 | 97937 | 2020-04-28 | Montgomery | Virginia | 51121 | 54 | 1 |
100787 | 100787 | 2020-04-29 | Montgomery | Virginia | 51121 | 55 | 1 |
103642 | 103642 | 2020-04-30 | Montgomery | Virginia | 51121 | 56 | 1 |
106506 | 106506 | 2020-05-01 | Montgomery | Virginia | 51121 | 56 | 1 |
109375 | 109375 | 2020-05-02 | Montgomery | Virginia | 51121 | 56 | 1 |
112249 | 112249 | 2020-05-03 | Montgomery | Virginia | 51121 | 56 | 1 |
115132 | 115132 | 2020-05-04 | Montgomery | Virginia | 51121 | 59 | 1 |
118091 | 118091 | 2020-05-05 | Montgomery | Virginia | 51121 | 61 | 1 |
121055 | 121055 | 2020-05-06 | Montgomery | Virginia | 51121 | 61 | 1 |
124036 | 124036 | 2020-05-07 | Montgomery | Virginia | 51121 | 61 | 1 |
127021 | 127021 | 2020-05-08 | Montgomery | Virginia | 51121 | 61 | 1 |
130011 | 130011 | 2020-05-09 | Montgomery | Virginia | 51121 | 64 | 1 |
133001 | 133001 | 2020-05-10 | Montgomery | Virginia | 51121 | 65 | 1 |
135991 | 135991 | 2020-05-11 | Montgomery | Virginia | 51121 | 66 | 1 |
138982 | 138982 | 2020-05-12 | Montgomery | Virginia | 51121 | 66 | 1 |
141978 | 141978 | 2020-05-13 | Montgomery | Virginia | 51121 | 66 | 1 |
144975 | 144975 | 2020-05-14 | Montgomery | Virginia | 51121 | 66 | 1 |
147978 | 147978 | 2020-05-15 | Montgomery | Virginia | 51121 | 66 | 1 |
150987 | 150987 | 2020-05-16 | Montgomery | Virginia | 51121 | 66 | 1 |
153998 | 153998 | 2020-05-17 | Montgomery | Virginia | 51121 | 66 | 1 |
157015 | 157015 | 2020-05-18 | Montgomery | Virginia | 51121 | 66 | 1 |
160039 | 160039 | 2020-05-19 | Montgomery | Virginia | 51121 | 66 | 1 |
163067 | 163067 | 2020-05-20 | Montgomery | Virginia | 51121 | 66 | 1 |
166096 | 166096 | 2020-05-21 | Montgomery | Virginia | 51121 | 67 | 1 |
169132 | 169132 | 2020-05-22 | Montgomery | Virginia | 51121 | 67 | 1 |
172173 | 172173 | 2020-05-23 | Montgomery | Virginia | 51121 | 69 | 1 |
175216 | 175216 | 2020-05-24 | Montgomery | Virginia | 51121 | 69 | 1 |
178261 | 178261 | 2020-05-25 | Montgomery | Virginia | 51121 | 69 | 1 |
181305 | 181305 | 2020-05-26 | Montgomery | Virginia | 51121 | 69 | 1 |
184356 | 184356 | 2020-05-27 | Montgomery | Virginia | 51121 | 70 | 1 |
187413 | 187413 | 2020-05-28 | Montgomery | Virginia | 51121 | 72 | 1 |
190477 | 190477 | 2020-05-29 | Montgomery | Virginia | 51121 | 73 | 1 |
193543 | 193543 | 2020-05-30 | Montgomery | Virginia | 51121 | 73 | 1 |
196613 | 196613 | 2020-05-31 | Montgomery | Virginia | 51121 | 77 | 1 |
199686 | 199686 | 2020-06-01 | Montgomery | Virginia | 51121 | 78 | 1 |
202762 | 202762 | 2020-06-02 | Montgomery | Virginia | 51121 | 80 | 1 |
205841 | 205841 | 2020-06-03 | Montgomery | Virginia | 51121 | 80 | 1 |
208923 | 208923 | 2020-06-04 | Montgomery | Virginia | 51121 | 82 | 1 |
212008 | 212008 | 2020-06-05 | Montgomery | Virginia | 51121 | 85 | 1 |
215095 | 215095 | 2020-06-06 | Montgomery | Virginia | 51121 | 91 | 1 |
218185 | 218185 | 2020-06-07 | Montgomery | Virginia | 51121 | 91 | 1 |
221277 | 221277 | 2020-06-08 | Montgomery | Virginia | 51121 | 94 | 1 |
224373 | 224373 | 2020-06-09 | Montgomery | Virginia | 51121 | 95 | 1 |
227473 | 227473 | 2020-06-10 | Montgomery | Virginia | 51121 | 96 | 1 |
230577 | 230577 | 2020-06-11 | Montgomery | Virginia | 51121 | 96 | 2 |
233682 | 233682 | 2020-06-12 | Montgomery | Virginia | 51121 | 96 | 2 |
236789 | 236789 | 2020-06-13 | Montgomery | Virginia | 51121 | 96 | 2 |
239897 | 239897 | 2020-06-14 | Montgomery | Virginia | 51121 | 96 | 2 |
243008 | 243008 | 2020-06-15 | Montgomery | Virginia | 51121 | 95 | 2 |
246121 | 246121 | 2020-06-16 | Montgomery | Virginia | 51121 | 97 | 2 |
249233 | 249233 | 2020-06-17 | Montgomery | Virginia | 51121 | 97 | 2 |
252348 | 252348 | 2020-06-18 | Montgomery | Virginia | 51121 | 97 | 2 |
255467 | 255467 | 2020-06-19 | Montgomery | Virginia | 51121 | 97 | 2 |
258594 | 258594 | 2020-06-20 | Montgomery | Virginia | 51121 | 107 | 2 |
261721 | 261721 | 2020-06-21 | Montgomery | Virginia | 51121 | 110 | 2 |
264850 | 264850 | 2020-06-22 | Montgomery | Virginia | 51121 | 110 | 2 |
267979 | 267979 | 2020-06-23 | Montgomery | Virginia | 51121 | 112 | 2 |
271113 | 271113 | 2020-06-24 | Montgomery | Virginia | 51121 | 116 | 2 |
274253 | 274253 | 2020-06-25 | Montgomery | Virginia | 51121 | 116 | 2 |
277401 | 277401 | 2020-06-26 | Montgomery | Virginia | 51121 | 122 | 2 |
280549 | 280549 | 2020-06-27 | Montgomery | Virginia | 51121 | 126 | 2 |
283695 | 283695 | 2020-06-28 | Montgomery | Virginia | 51121 | 136 | 2 |
286841 | 286841 | 2020-06-29 | Montgomery | Virginia | 51121 | 143 | 2 |
289991 | 289991 | 2020-06-30 | Montgomery | Virginia | 51121 | 145 | 2 |
293144 | 293144 | 2020-07-01 | Montgomery | Virginia | 51121 | 147 | 2 |
296299 | 296299 | 2020-07-02 | Montgomery | Virginia | 51121 | 149 | 2 |
299461 | 299461 | 2020-07-03 | Montgomery | Virginia | 51121 | 154 | 2 |
302625 | 302625 | 2020-07-04 | Montgomery | Virginia | 51121 | 155 | 2 |
305789 | 305789 | 2020-07-05 | Montgomery | Virginia | 51121 | 158 | 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);