ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
1,553 rows where county = "Page" sorted by fips descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date, deaths, date (date)
Link | rowid | date | county | state | fips ▲ | cases | deaths |
---|---|---|---|---|---|---|---|
23723 | 23723 | 2020-03-31 | Page | Virginia | 51139 | 1 | 0 |
25939 | 25939 | 2020-04-01 | Page | Virginia | 51139 | 1 | 0 |
28229 | 28229 | 2020-04-02 | Page | Virginia | 51139 | 2 | 0 |
30576 | 30576 | 2020-04-03 | Page | Virginia | 51139 | 2 | 0 |
32975 | 32975 | 2020-04-04 | Page | Virginia | 51139 | 2 | 0 |
35413 | 35413 | 2020-04-05 | Page | Virginia | 51139 | 2 | 0 |
37896 | 37896 | 2020-04-06 | Page | Virginia | 51139 | 2 | 0 |
40430 | 40430 | 2020-04-07 | Page | Virginia | 51139 | 3 | 0 |
42999 | 42999 | 2020-04-08 | Page | Virginia | 51139 | 3 | 0 |
45595 | 45595 | 2020-04-09 | Page | Virginia | 51139 | 5 | 0 |
48221 | 48221 | 2020-04-10 | Page | Virginia | 51139 | 5 | 0 |
50879 | 50879 | 2020-04-11 | Page | Virginia | 51139 | 6 | 0 |
53554 | 53554 | 2020-04-12 | Page | Virginia | 51139 | 6 | 0 |
56244 | 56244 | 2020-04-13 | Page | Virginia | 51139 | 6 | 0 |
58950 | 58950 | 2020-04-14 | Page | Virginia | 51139 | 6 | 0 |
61669 | 61669 | 2020-04-15 | Page | Virginia | 51139 | 6 | 0 |
64402 | 64402 | 2020-04-16 | Page | Virginia | 51139 | 7 | 0 |
67150 | 67150 | 2020-04-17 | Page | Virginia | 51139 | 10 | 0 |
69912 | 69912 | 2020-04-18 | Page | Virginia | 51139 | 13 | 0 |
72682 | 72682 | 2020-04-19 | Page | Virginia | 51139 | 13 | 0 |
75458 | 75458 | 2020-04-20 | Page | Virginia | 51139 | 14 | 0 |
78241 | 78241 | 2020-04-21 | Page | Virginia | 51139 | 14 | 0 |
81034 | 81034 | 2020-04-22 | Page | Virginia | 51139 | 16 | 0 |
83835 | 83835 | 2020-04-23 | Page | Virginia | 51139 | 22 | 0 |
86642 | 86642 | 2020-04-24 | Page | Virginia | 51139 | 30 | 0 |
89457 | 89457 | 2020-04-25 | Page | Virginia | 51139 | 82 | 0 |
92274 | 92274 | 2020-04-26 | Page | Virginia | 51139 | 84 | 0 |
95103 | 95103 | 2020-04-27 | Page | Virginia | 51139 | 87 | 0 |
97947 | 97947 | 2020-04-28 | Page | Virginia | 51139 | 89 | 0 |
100797 | 100797 | 2020-04-29 | Page | Virginia | 51139 | 91 | 1 |
103652 | 103652 | 2020-04-30 | Page | Virginia | 51139 | 100 | 1 |
106516 | 106516 | 2020-05-01 | Page | Virginia | 51139 | 104 | 1 |
109385 | 109385 | 2020-05-02 | Page | Virginia | 51139 | 107 | 2 |
112259 | 112259 | 2020-05-03 | Page | Virginia | 51139 | 109 | 2 |
115142 | 115142 | 2020-05-04 | Page | Virginia | 51139 | 113 | 2 |
118101 | 118101 | 2020-05-05 | Page | Virginia | 51139 | 113 | 5 |
121065 | 121065 | 2020-05-06 | Page | Virginia | 51139 | 113 | 5 |
124046 | 124046 | 2020-05-07 | Page | Virginia | 51139 | 122 | 11 |
127031 | 127031 | 2020-05-08 | Page | Virginia | 51139 | 123 | 11 |
130021 | 130021 | 2020-05-09 | Page | Virginia | 51139 | 128 | 12 |
133011 | 133011 | 2020-05-10 | Page | Virginia | 51139 | 128 | 12 |
136001 | 136001 | 2020-05-11 | Page | Virginia | 51139 | 129 | 12 |
138992 | 138992 | 2020-05-12 | Page | Virginia | 51139 | 129 | 12 |
141988 | 141988 | 2020-05-13 | Page | Virginia | 51139 | 140 | 16 |
144985 | 144985 | 2020-05-14 | Page | Virginia | 51139 | 143 | 16 |
147988 | 147988 | 2020-05-15 | Page | Virginia | 51139 | 145 | 16 |
150997 | 150997 | 2020-05-16 | Page | Virginia | 51139 | 158 | 16 |
154008 | 154008 | 2020-05-17 | Page | Virginia | 51139 | 161 | 16 |
157025 | 157025 | 2020-05-18 | Page | Virginia | 51139 | 161 | 16 |
160049 | 160049 | 2020-05-19 | Page | Virginia | 51139 | 165 | 17 |
163077 | 163077 | 2020-05-20 | Page | Virginia | 51139 | 166 | 17 |
166106 | 166106 | 2020-05-21 | Page | Virginia | 51139 | 166 | 19 |
169142 | 169142 | 2020-05-22 | Page | Virginia | 51139 | 172 | 19 |
172183 | 172183 | 2020-05-23 | Page | Virginia | 51139 | 186 | 21 |
175226 | 175226 | 2020-05-24 | Page | Virginia | 51139 | 188 | 21 |
178271 | 178271 | 2020-05-25 | Page | Virginia | 51139 | 197 | 21 |
181315 | 181315 | 2020-05-26 | Page | Virginia | 51139 | 199 | 21 |
184366 | 184366 | 2020-05-27 | Page | Virginia | 51139 | 208 | 21 |
187423 | 187423 | 2020-05-28 | Page | Virginia | 51139 | 213 | 21 |
190487 | 190487 | 2020-05-29 | Page | Virginia | 51139 | 214 | 21 |
193553 | 193553 | 2020-05-30 | Page | Virginia | 51139 | 219 | 21 |
196623 | 196623 | 2020-05-31 | Page | Virginia | 51139 | 220 | 21 |
199696 | 199696 | 2020-06-01 | Page | Virginia | 51139 | 225 | 21 |
202772 | 202772 | 2020-06-02 | Page | Virginia | 51139 | 230 | 24 |
205851 | 205851 | 2020-06-03 | Page | Virginia | 51139 | 231 | 24 |
208933 | 208933 | 2020-06-04 | Page | Virginia | 51139 | 231 | 24 |
212018 | 212018 | 2020-06-05 | Page | Virginia | 51139 | 233 | 24 |
215105 | 215105 | 2020-06-06 | Page | Virginia | 51139 | 237 | 24 |
218195 | 218195 | 2020-06-07 | Page | Virginia | 51139 | 244 | 24 |
221287 | 221287 | 2020-06-08 | Page | Virginia | 51139 | 245 | 24 |
224383 | 224383 | 2020-06-09 | Page | Virginia | 51139 | 246 | 24 |
227483 | 227483 | 2020-06-10 | Page | Virginia | 51139 | 247 | 24 |
230587 | 230587 | 2020-06-11 | Page | Virginia | 51139 | 249 | 24 |
233692 | 233692 | 2020-06-12 | Page | Virginia | 51139 | 250 | 24 |
236799 | 236799 | 2020-06-13 | Page | Virginia | 51139 | 251 | 24 |
239907 | 239907 | 2020-06-14 | Page | Virginia | 51139 | 251 | 24 |
243018 | 243018 | 2020-06-15 | Page | Virginia | 51139 | 252 | 24 |
246131 | 246131 | 2020-06-16 | Page | Virginia | 51139 | 256 | 24 |
249243 | 249243 | 2020-06-17 | Page | Virginia | 51139 | 256 | 24 |
252358 | 252358 | 2020-06-18 | Page | Virginia | 51139 | 259 | 24 |
255477 | 255477 | 2020-06-19 | Page | Virginia | 51139 | 261 | 24 |
258604 | 258604 | 2020-06-20 | Page | Virginia | 51139 | 261 | 24 |
261731 | 261731 | 2020-06-21 | Page | Virginia | 51139 | 263 | 24 |
264860 | 264860 | 2020-06-22 | Page | Virginia | 51139 | 263 | 24 |
267989 | 267989 | 2020-06-23 | Page | Virginia | 51139 | 264 | 24 |
271123 | 271123 | 2020-06-24 | Page | Virginia | 51139 | 264 | 24 |
274263 | 274263 | 2020-06-25 | Page | Virginia | 51139 | 266 | 24 |
277411 | 277411 | 2020-06-26 | Page | Virginia | 51139 | 266 | 24 |
280559 | 280559 | 2020-06-27 | Page | Virginia | 51139 | 267 | 24 |
283705 | 283705 | 2020-06-28 | Page | Virginia | 51139 | 267 | 24 |
286851 | 286851 | 2020-06-29 | Page | Virginia | 51139 | 267 | 24 |
290001 | 290001 | 2020-06-30 | Page | Virginia | 51139 | 269 | 24 |
293154 | 293154 | 2020-07-01 | Page | Virginia | 51139 | 275 | 24 |
296309 | 296309 | 2020-07-02 | Page | Virginia | 51139 | 278 | 23 |
299471 | 299471 | 2020-07-03 | Page | Virginia | 51139 | 281 | 23 |
302635 | 302635 | 2020-07-04 | Page | Virginia | 51139 | 281 | 23 |
305799 | 305799 | 2020-07-05 | Page | Virginia | 51139 | 283 | 23 |
308967 | 308967 | 2020-07-06 | Page | Virginia | 51139 | 285 | 23 |
312136 | 312136 | 2020-07-07 | Page | Virginia | 51139 | 290 | 23 |
315311 | 315311 | 2020-07-08 | Page | Virginia | 51139 | 293 | 23 |
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);