ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
798 rows where fips = 51059 and state = "Virginia" sorted by state
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date | county | state ▼ | fips | cases | deaths |
---|---|---|---|---|---|---|---|
740 | 740 | 2020-03-07 | Fairfax | Virginia | 51059 | 1 | 0 |
852 | 852 | 2020-03-08 | Fairfax | Virginia | 51059 | 2 | 0 |
982 | 982 | 2020-03-09 | Fairfax | Virginia | 51059 | 4 | 0 |
1144 | 1144 | 2020-03-10 | Fairfax | Virginia | 51059 | 4 | 0 |
1343 | 1343 | 2020-03-11 | Fairfax | Virginia | 51059 | 4 | 0 |
1591 | 1591 | 2020-03-12 | Fairfax | Virginia | 51059 | 4 | 0 |
1900 | 1900 | 2020-03-13 | Fairfax | Virginia | 51059 | 6 | 0 |
2272 | 2272 | 2020-03-14 | Fairfax | Virginia | 51059 | 10 | 0 |
2699 | 2699 | 2020-03-15 | Fairfax | Virginia | 51059 | 10 | 0 |
3171 | 3171 | 2020-03-16 | Fairfax | Virginia | 51059 | 10 | 0 |
3708 | 3708 | 2020-03-17 | Fairfax | Virginia | 51059 | 12 | 0 |
4341 | 4341 | 2020-03-18 | Fairfax | Virginia | 51059 | 14 | 0 |
5097 | 5097 | 2020-03-19 | Fairfax | Virginia | 51059 | 16 | 0 |
5994 | 5994 | 2020-03-20 | Fairfax | Virginia | 51059 | 16 | 0 |
7021 | 7021 | 2020-03-21 | Fairfax | Virginia | 51059 | 22 | 1 |
8154 | 8154 | 2020-03-22 | Fairfax | Virginia | 51059 | 31 | 1 |
9376 | 9376 | 2020-03-23 | Fairfax | Virginia | 51059 | 43 | 1 |
10723 | 10723 | 2020-03-24 | Fairfax | Virginia | 51059 | 46 | 1 |
12235 | 12235 | 2020-03-25 | Fairfax | Virginia | 51059 | 76 | 1 |
13872 | 13872 | 2020-03-26 | Fairfax | Virginia | 51059 | 124 | 1 |
15639 | 15639 | 2020-03-27 | Fairfax | Virginia | 51059 | 124 | 1 |
17513 | 17513 | 2020-03-28 | Fairfax | Virginia | 51059 | 156 | 1 |
19473 | 19473 | 2020-03-29 | Fairfax | Virginia | 51059 | 187 | 1 |
21536 | 21536 | 2020-03-30 | Fairfax | Virginia | 51059 | 225 | 2 |
23680 | 23680 | 2020-03-31 | Fairfax | Virginia | 51059 | 244 | 2 |
25896 | 25896 | 2020-04-01 | Fairfax | Virginia | 51059 | 288 | 5 |
28186 | 28186 | 2020-04-02 | Fairfax | Virginia | 51059 | 328 | 5 |
30532 | 30532 | 2020-04-03 | Fairfax | Virginia | 51059 | 372 | 5 |
32931 | 32931 | 2020-04-04 | Fairfax | Virginia | 51059 | 387 | 5 |
35369 | 35369 | 2020-04-05 | Fairfax | Virginia | 51059 | 426 | 5 |
37851 | 37851 | 2020-04-06 | Fairfax | Virginia | 51059 | 488 | 6 |
40384 | 40384 | 2020-04-07 | Fairfax | Virginia | 51059 | 532 | 9 |
42953 | 42953 | 2020-04-08 | Fairfax | Virginia | 51059 | 570 | 9 |
45547 | 45547 | 2020-04-09 | Fairfax | Virginia | 51059 | 690 | 16 |
48172 | 48172 | 2020-04-10 | Fairfax | Virginia | 51059 | 777 | 16 |
50830 | 50830 | 2020-04-11 | Fairfax | Virginia | 51059 | 946 | 16 |
53505 | 53505 | 2020-04-12 | Fairfax | Virginia | 51059 | 1008 | 16 |
56194 | 56194 | 2020-04-13 | Fairfax | Virginia | 51059 | 1164 | 20 |
58900 | 58900 | 2020-04-14 | Fairfax | Virginia | 51059 | 1207 | 20 |
61619 | 61619 | 2020-04-15 | Fairfax | Virginia | 51059 | 1298 | 29 |
64352 | 64352 | 2020-04-16 | Fairfax | Virginia | 51059 | 1375 | 30 |
67100 | 67100 | 2020-04-17 | Fairfax | Virginia | 51059 | 1476 | 37 |
69862 | 69862 | 2020-04-18 | Fairfax | Virginia | 51059 | 1633 | 37 |
72632 | 72632 | 2020-04-19 | Fairfax | Virginia | 51059 | 1809 | 37 |
75408 | 75408 | 2020-04-20 | Fairfax | Virginia | 51059 | 1925 | 59 |
78190 | 78190 | 2020-04-21 | Fairfax | Virginia | 51059 | 2077 | 64 |
80982 | 80982 | 2020-04-22 | Fairfax | Virginia | 51059 | 2256 | 66 |
83783 | 83783 | 2020-04-23 | Fairfax | Virginia | 51059 | 2362 | 76 |
86590 | 86590 | 2020-04-24 | Fairfax | Virginia | 51059 | 2534 | 85 |
89405 | 89405 | 2020-04-25 | Fairfax | Virginia | 51059 | 2745 | 90 |
92222 | 92222 | 2020-04-26 | Fairfax | Virginia | 51059 | 2889 | 95 |
95051 | 95051 | 2020-04-27 | Fairfax | Virginia | 51059 | 3002 | 100 |
97893 | 97893 | 2020-04-28 | Fairfax | Virginia | 51059 | 3278 | 114 |
100743 | 100743 | 2020-04-29 | Fairfax | Virginia | 51059 | 3448 | 124 |
103598 | 103598 | 2020-04-30 | Fairfax | Virginia | 51059 | 3611 | 134 |
106462 | 106462 | 2020-05-01 | Fairfax | Virginia | 51059 | 3897 | 137 |
109331 | 109331 | 2020-05-02 | Fairfax | Virginia | 51059 | 4046 | 153 |
112205 | 112205 | 2020-05-03 | Fairfax | Virginia | 51059 | 4340 | 184 |
115088 | 115088 | 2020-05-04 | Fairfax | Virginia | 51059 | 4615 | 198 |
118047 | 118047 | 2020-05-05 | Fairfax | Virginia | 51059 | 4834 | 201 |
121011 | 121011 | 2020-05-06 | Fairfax | Virginia | 51059 | 4834 | 201 |
123992 | 123992 | 2020-05-07 | Fairfax | Virginia | 51059 | 5045 | 211 |
126977 | 126977 | 2020-05-08 | Fairfax | Virginia | 51059 | 5338 | 227 |
129967 | 129967 | 2020-05-09 | Fairfax | Virginia | 51059 | 5610 | 230 |
132957 | 132957 | 2020-05-10 | Fairfax | Virginia | 51059 | 5892 | 239 |
135947 | 135947 | 2020-05-11 | Fairfax | Virginia | 51059 | 6200 | 243 |
138938 | 138938 | 2020-05-12 | Fairfax | Virginia | 51059 | 6470 | 253 |
141934 | 141934 | 2020-05-13 | Fairfax | Virginia | 51059 | 6666 | 262 |
144931 | 144931 | 2020-05-14 | Fairfax | Virginia | 51059 | 6951 | 267 |
147934 | 147934 | 2020-05-15 | Fairfax | Virginia | 51059 | 7159 | 273 |
150943 | 150943 | 2020-05-16 | Fairfax | Virginia | 51059 | 7386 | 278 |
153954 | 153954 | 2020-05-17 | Fairfax | Virginia | 51059 | 7643 | 282 |
156971 | 156971 | 2020-05-18 | Fairfax | Virginia | 51059 | 7843 | 284 |
159995 | 159995 | 2020-05-19 | Fairfax | Virginia | 51059 | 8020 | 292 |
163023 | 163023 | 2020-05-20 | Fairfax | Virginia | 51059 | 8163 | 302 |
166052 | 166052 | 2020-05-21 | Fairfax | Virginia | 51059 | 8580 | 309 |
169088 | 169088 | 2020-05-22 | Fairfax | Virginia | 51059 | 8734 | 321 |
172129 | 172129 | 2020-05-23 | Fairfax | Virginia | 51059 | 8945 | 326 |
175172 | 175172 | 2020-05-24 | Fairfax | Virginia | 51059 | 8989 | 327 |
178217 | 178217 | 2020-05-25 | Fairfax | Virginia | 51059 | 9482 | 331 |
181261 | 181261 | 2020-05-26 | Fairfax | Virginia | 51059 | 9839 | 340 |
184312 | 184312 | 2020-05-27 | Fairfax | Virginia | 51059 | 10069 | 364 |
187369 | 187369 | 2020-05-28 | Fairfax | Virginia | 51059 | 10503 | 371 |
190433 | 190433 | 2020-05-29 | Fairfax | Virginia | 51059 | 10738 | 378 |
193499 | 193499 | 2020-05-30 | Fairfax | Virginia | 51059 | 10906 | 383 |
196569 | 196569 | 2020-05-31 | Fairfax | Virginia | 51059 | 11110 | 383 |
199642 | 199642 | 2020-06-01 | Fairfax | Virginia | 51059 | 11219 | 387 |
202718 | 202718 | 2020-06-02 | Fairfax | Virginia | 51059 | 11426 | 391 |
205797 | 205797 | 2020-06-03 | Fairfax | Virginia | 51059 | 11596 | 396 |
208879 | 208879 | 2020-06-04 | Fairfax | Virginia | 51059 | 11815 | 403 |
211964 | 211964 | 2020-06-05 | Fairfax | Virginia | 51059 | 11904 | 410 |
215051 | 215051 | 2020-06-06 | Fairfax | Virginia | 51059 | 12056 | 413 |
218141 | 218141 | 2020-06-07 | Fairfax | Virginia | 51059 | 12455 | 414 |
221233 | 221233 | 2020-06-08 | Fairfax | Virginia | 51059 | 12603 | 414 |
224329 | 224329 | 2020-06-09 | Fairfax | Virginia | 51059 | 12695 | 416 |
227429 | 227429 | 2020-06-10 | Fairfax | Virginia | 51059 | 12746 | 422 |
230533 | 230533 | 2020-06-11 | Fairfax | Virginia | 51059 | 12812 | 418 |
233638 | 233638 | 2020-06-12 | Fairfax | Virginia | 51059 | 12863 | 421 |
236745 | 236745 | 2020-06-13 | Fairfax | Virginia | 51059 | 12939 | 423 |
239853 | 239853 | 2020-06-14 | Fairfax | Virginia | 51059 | 13017 | 423 |
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);