ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
776 rows where fips = 51685 and state = "Virginia" sorted by rowid
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid ▼ | date | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
19499 | 19499 | 2020-03-29 | Manassas Park city | Virginia | 51685 | 1 | 0 |
21564 | 21564 | 2020-03-30 | Manassas Park city | Virginia | 51685 | 1 | 0 |
23710 | 23710 | 2020-03-31 | Manassas Park city | Virginia | 51685 | 1 | 0 |
25926 | 25926 | 2020-04-01 | Manassas Park city | Virginia | 51685 | 1 | 0 |
28216 | 28216 | 2020-04-02 | Manassas Park city | Virginia | 51685 | 1 | 0 |
30563 | 30563 | 2020-04-03 | Manassas Park city | Virginia | 51685 | 2 | 0 |
32962 | 32962 | 2020-04-04 | Manassas Park city | Virginia | 51685 | 2 | 0 |
35400 | 35400 | 2020-04-05 | Manassas Park city | Virginia | 51685 | 2 | 0 |
37883 | 37883 | 2020-04-06 | Manassas Park city | Virginia | 51685 | 4 | 0 |
40417 | 40417 | 2020-04-07 | Manassas Park city | Virginia | 51685 | 4 | 0 |
42986 | 42986 | 2020-04-08 | Manassas Park city | Virginia | 51685 | 5 | 0 |
45581 | 45581 | 2020-04-09 | Manassas Park city | Virginia | 51685 | 5 | 0 |
48207 | 48207 | 2020-04-10 | Manassas Park city | Virginia | 51685 | 7 | 0 |
50865 | 50865 | 2020-04-11 | Manassas Park city | Virginia | 51685 | 10 | 0 |
53540 | 53540 | 2020-04-12 | Manassas Park city | Virginia | 51685 | 10 | 0 |
56230 | 56230 | 2020-04-13 | Manassas Park city | Virginia | 51685 | 10 | 0 |
58936 | 58936 | 2020-04-14 | Manassas Park city | Virginia | 51685 | 13 | 0 |
61655 | 61655 | 2020-04-15 | Manassas Park city | Virginia | 51685 | 14 | 0 |
64388 | 64388 | 2020-04-16 | Manassas Park city | Virginia | 51685 | 16 | 0 |
67136 | 67136 | 2020-04-17 | Manassas Park city | Virginia | 51685 | 21 | 0 |
69898 | 69898 | 2020-04-18 | Manassas Park city | Virginia | 51685 | 21 | 0 |
72668 | 72668 | 2020-04-19 | Manassas Park city | Virginia | 51685 | 25 | 0 |
75444 | 75444 | 2020-04-20 | Manassas Park city | Virginia | 51685 | 30 | 0 |
78226 | 78226 | 2020-04-21 | Manassas Park city | Virginia | 51685 | 31 | 1 |
81019 | 81019 | 2020-04-22 | Manassas Park city | Virginia | 51685 | 34 | 1 |
83820 | 83820 | 2020-04-23 | Manassas Park city | Virginia | 51685 | 38 | 1 |
86627 | 86627 | 2020-04-24 | Manassas Park city | Virginia | 51685 | 44 | 1 |
89442 | 89442 | 2020-04-25 | Manassas Park city | Virginia | 51685 | 44 | 1 |
92259 | 92259 | 2020-04-26 | Manassas Park city | Virginia | 51685 | 45 | 1 |
95088 | 95088 | 2020-04-27 | Manassas Park city | Virginia | 51685 | 50 | 1 |
97931 | 97931 | 2020-04-28 | Manassas Park city | Virginia | 51685 | 53 | 1 |
100781 | 100781 | 2020-04-29 | Manassas Park city | Virginia | 51685 | 60 | 1 |
103636 | 103636 | 2020-04-30 | Manassas Park city | Virginia | 51685 | 61 | 1 |
106500 | 106500 | 2020-05-01 | Manassas Park city | Virginia | 51685 | 68 | 1 |
109369 | 109369 | 2020-05-02 | Manassas Park city | Virginia | 51685 | 76 | 1 |
112243 | 112243 | 2020-05-03 | Manassas Park city | Virginia | 51685 | 82 | 1 |
115126 | 115126 | 2020-05-04 | Manassas Park city | Virginia | 51685 | 88 | 2 |
118085 | 118085 | 2020-05-05 | Manassas Park city | Virginia | 51685 | 96 | 2 |
121049 | 121049 | 2020-05-06 | Manassas Park city | Virginia | 51685 | 96 | 2 |
124030 | 124030 | 2020-05-07 | Manassas Park city | Virginia | 51685 | 106 | 2 |
127015 | 127015 | 2020-05-08 | Manassas Park city | Virginia | 51685 | 114 | 2 |
130005 | 130005 | 2020-05-09 | Manassas Park city | Virginia | 51685 | 116 | 2 |
132995 | 132995 | 2020-05-10 | Manassas Park city | Virginia | 51685 | 120 | 2 |
135985 | 135985 | 2020-05-11 | Manassas Park city | Virginia | 51685 | 135 | 2 |
138976 | 138976 | 2020-05-12 | Manassas Park city | Virginia | 51685 | 139 | 3 |
141972 | 141972 | 2020-05-13 | Manassas Park city | Virginia | 51685 | 152 | 3 |
144969 | 144969 | 2020-05-14 | Manassas Park city | Virginia | 51685 | 170 | 3 |
147972 | 147972 | 2020-05-15 | Manassas Park city | Virginia | 51685 | 176 | 3 |
150981 | 150981 | 2020-05-16 | Manassas Park city | Virginia | 51685 | 183 | 3 |
153992 | 153992 | 2020-05-17 | Manassas Park city | Virginia | 51685 | 187 | 3 |
157009 | 157009 | 2020-05-18 | Manassas Park city | Virginia | 51685 | 198 | 3 |
160033 | 160033 | 2020-05-19 | Manassas Park city | Virginia | 51685 | 202 | 3 |
163061 | 163061 | 2020-05-20 | Manassas Park city | Virginia | 51685 | 207 | 3 |
166090 | 166090 | 2020-05-21 | Manassas Park city | Virginia | 51685 | 223 | 3 |
169126 | 169126 | 2020-05-22 | Manassas Park city | Virginia | 51685 | 228 | 4 |
172167 | 172167 | 2020-05-23 | Manassas Park city | Virginia | 51685 | 230 | 4 |
175210 | 175210 | 2020-05-24 | Manassas Park city | Virginia | 51685 | 239 | 4 |
178255 | 178255 | 2020-05-25 | Manassas Park city | Virginia | 51685 | 261 | 5 |
181299 | 181299 | 2020-05-26 | Manassas Park city | Virginia | 51685 | 277 | 6 |
184350 | 184350 | 2020-05-27 | Manassas Park city | Virginia | 51685 | 280 | 6 |
187407 | 187407 | 2020-05-28 | Manassas Park city | Virginia | 51685 | 281 | 6 |
190471 | 190471 | 2020-05-29 | Manassas Park city | Virginia | 51685 | 287 | 6 |
193537 | 193537 | 2020-05-30 | Manassas Park city | Virginia | 51685 | 299 | 6 |
196607 | 196607 | 2020-05-31 | Manassas Park city | Virginia | 51685 | 305 | 6 |
199680 | 199680 | 2020-06-01 | Manassas Park city | Virginia | 51685 | 317 | 6 |
202756 | 202756 | 2020-06-02 | Manassas Park city | Virginia | 51685 | 327 | 6 |
205835 | 205835 | 2020-06-03 | Manassas Park city | Virginia | 51685 | 332 | 6 |
208917 | 208917 | 2020-06-04 | Manassas Park city | Virginia | 51685 | 339 | 6 |
212002 | 212002 | 2020-06-05 | Manassas Park city | Virginia | 51685 | 343 | 6 |
215089 | 215089 | 2020-06-06 | Manassas Park city | Virginia | 51685 | 351 | 6 |
218179 | 218179 | 2020-06-07 | Manassas Park city | Virginia | 51685 | 355 | 6 |
221271 | 221271 | 2020-06-08 | Manassas Park city | Virginia | 51685 | 359 | 6 |
224367 | 224367 | 2020-06-09 | Manassas Park city | Virginia | 51685 | 359 | 6 |
227467 | 227467 | 2020-06-10 | Manassas Park city | Virginia | 51685 | 360 | 6 |
230571 | 230571 | 2020-06-11 | Manassas Park city | Virginia | 51685 | 361 | 6 |
233676 | 233676 | 2020-06-12 | Manassas Park city | Virginia | 51685 | 369 | 6 |
236783 | 236783 | 2020-06-13 | Manassas Park city | Virginia | 51685 | 372 | 6 |
239891 | 239891 | 2020-06-14 | Manassas Park city | Virginia | 51685 | 378 | 6 |
243002 | 243002 | 2020-06-15 | Manassas Park city | Virginia | 51685 | 384 | 6 |
246115 | 246115 | 2020-06-16 | Manassas Park city | Virginia | 51685 | 388 | 6 |
249227 | 249227 | 2020-06-17 | Manassas Park city | Virginia | 51685 | 390 | 6 |
252342 | 252342 | 2020-06-18 | Manassas Park city | Virginia | 51685 | 393 | 6 |
255461 | 255461 | 2020-06-19 | Manassas Park city | Virginia | 51685 | 402 | 5 |
258588 | 258588 | 2020-06-20 | Manassas Park city | Virginia | 51685 | 407 | 5 |
261715 | 261715 | 2020-06-21 | Manassas Park city | Virginia | 51685 | 410 | 5 |
264844 | 264844 | 2020-06-22 | Manassas Park city | Virginia | 51685 | 414 | 5 |
267973 | 267973 | 2020-06-23 | Manassas Park city | Virginia | 51685 | 416 | 5 |
271107 | 271107 | 2020-06-24 | Manassas Park city | Virginia | 51685 | 416 | 5 |
274247 | 274247 | 2020-06-25 | Manassas Park city | Virginia | 51685 | 417 | 5 |
277395 | 277395 | 2020-06-26 | Manassas Park city | Virginia | 51685 | 419 | 5 |
280543 | 280543 | 2020-06-27 | Manassas Park city | Virginia | 51685 | 422 | 5 |
283689 | 283689 | 2020-06-28 | Manassas Park city | Virginia | 51685 | 428 | 5 |
286835 | 286835 | 2020-06-29 | Manassas Park city | Virginia | 51685 | 427 | 5 |
289985 | 289985 | 2020-06-30 | Manassas Park city | Virginia | 51685 | 431 | 6 |
293138 | 293138 | 2020-07-01 | Manassas Park city | Virginia | 51685 | 430 | 6 |
296293 | 296293 | 2020-07-02 | Manassas Park city | Virginia | 51685 | 431 | 6 |
299455 | 299455 | 2020-07-03 | Manassas Park city | Virginia | 51685 | 434 | 6 |
302619 | 302619 | 2020-07-04 | Manassas Park city | Virginia | 51685 | 435 | 6 |
305783 | 305783 | 2020-07-05 | Manassas Park city | Virginia | 51685 | 444 | 6 |
308951 | 308951 | 2020-07-06 | Manassas Park city | Virginia | 51685 | 445 | 6 |
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);