ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
796 rows where fips = 51810 sorted by state descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid | date | county | state ▲ | fips | cases | deaths |
---|---|---|---|---|---|---|---|
983 | 983 | 2020-03-09 | Virginia Beach city | Virginia | 51810 | 1 | 0 |
1146 | 1146 | 2020-03-10 | Virginia Beach city | Virginia | 51810 | 2 | 0 |
1345 | 1345 | 2020-03-11 | Virginia Beach city | Virginia | 51810 | 2 | 0 |
1597 | 1597 | 2020-03-12 | Virginia Beach city | Virginia | 51810 | 2 | 0 |
1907 | 1907 | 2020-03-13 | Virginia Beach city | Virginia | 51810 | 2 | 0 |
2280 | 2280 | 2020-03-14 | Virginia Beach city | Virginia | 51810 | 3 | 0 |
2707 | 2707 | 2020-03-15 | Virginia Beach city | Virginia | 51810 | 4 | 0 |
3180 | 3180 | 2020-03-16 | Virginia Beach city | Virginia | 51810 | 4 | 0 |
3719 | 3719 | 2020-03-17 | Virginia Beach city | Virginia | 51810 | 4 | 0 |
4353 | 4353 | 2020-03-18 | Virginia Beach city | Virginia | 51810 | 4 | 0 |
5109 | 5109 | 2020-03-19 | Virginia Beach city | Virginia | 51810 | 4 | 0 |
6010 | 6010 | 2020-03-20 | Virginia Beach city | Virginia | 51810 | 4 | 0 |
7041 | 7041 | 2020-03-21 | Virginia Beach city | Virginia | 51810 | 4 | 0 |
8178 | 8178 | 2020-03-22 | Virginia Beach city | Virginia | 51810 | 17 | 0 |
9401 | 9401 | 2020-03-23 | Virginia Beach city | Virginia | 51810 | 17 | 0 |
10750 | 10750 | 2020-03-24 | Virginia Beach city | Virginia | 51810 | 17 | 0 |
12272 | 12272 | 2020-03-25 | Virginia Beach city | Virginia | 51810 | 23 | 0 |
13920 | 13920 | 2020-03-26 | Virginia Beach city | Virginia | 51810 | 26 | 0 |
15688 | 15688 | 2020-03-27 | Virginia Beach city | Virginia | 51810 | 29 | 0 |
17568 | 17568 | 2020-03-28 | Virginia Beach city | Virginia | 51810 | 35 | 0 |
19531 | 19531 | 2020-03-29 | Virginia Beach city | Virginia | 51810 | 49 | 0 |
21598 | 21598 | 2020-03-30 | Virginia Beach city | Virginia | 51810 | 52 | 0 |
23746 | 23746 | 2020-03-31 | Virginia Beach city | Virginia | 51810 | 65 | 0 |
25964 | 25964 | 2020-04-01 | Virginia Beach city | Virginia | 51810 | 88 | 0 |
28254 | 28254 | 2020-04-02 | Virginia Beach city | Virginia | 51810 | 111 | 0 |
30604 | 30604 | 2020-04-03 | Virginia Beach city | Virginia | 51810 | 128 | 1 |
33004 | 33004 | 2020-04-04 | Virginia Beach city | Virginia | 51810 | 160 | 1 |
35442 | 35442 | 2020-04-05 | Virginia Beach city | Virginia | 51810 | 170 | 1 |
37926 | 37926 | 2020-04-06 | Virginia Beach city | Virginia | 51810 | 178 | 1 |
40461 | 40461 | 2020-04-07 | Virginia Beach city | Virginia | 51810 | 200 | 1 |
43030 | 43030 | 2020-04-08 | Virginia Beach city | Virginia | 51810 | 207 | 1 |
45626 | 45626 | 2020-04-09 | Virginia Beach city | Virginia | 51810 | 219 | 1 |
48253 | 48253 | 2020-04-10 | Virginia Beach city | Virginia | 51810 | 224 | 1 |
50911 | 50911 | 2020-04-11 | Virginia Beach city | Virginia | 51810 | 236 | 1 |
53586 | 53586 | 2020-04-12 | Virginia Beach city | Virginia | 51810 | 243 | 1 |
56276 | 56276 | 2020-04-13 | Virginia Beach city | Virginia | 51810 | 251 | 1 |
58982 | 58982 | 2020-04-14 | Virginia Beach city | Virginia | 51810 | 252 | 5 |
61701 | 61701 | 2020-04-15 | Virginia Beach city | Virginia | 51810 | 256 | 5 |
64434 | 64434 | 2020-04-16 | Virginia Beach city | Virginia | 51810 | 258 | 5 |
67182 | 67182 | 2020-04-17 | Virginia Beach city | Virginia | 51810 | 265 | 5 |
69944 | 69944 | 2020-04-18 | Virginia Beach city | Virginia | 51810 | 271 | 5 |
72714 | 72714 | 2020-04-19 | Virginia Beach city | Virginia | 51810 | 273 | 8 |
75490 | 75490 | 2020-04-20 | Virginia Beach city | Virginia | 51810 | 281 | 8 |
78273 | 78273 | 2020-04-21 | Virginia Beach city | Virginia | 51810 | 288 | 8 |
81066 | 81066 | 2020-04-22 | Virginia Beach city | Virginia | 51810 | 313 | 8 |
83867 | 83867 | 2020-04-23 | Virginia Beach city | Virginia | 51810 | 328 | 8 |
86674 | 86674 | 2020-04-24 | Virginia Beach city | Virginia | 51810 | 331 | 10 |
89489 | 89489 | 2020-04-25 | Virginia Beach city | Virginia | 51810 | 335 | 10 |
92306 | 92306 | 2020-04-26 | Virginia Beach city | Virginia | 51810 | 345 | 10 |
95135 | 95135 | 2020-04-27 | Virginia Beach city | Virginia | 51810 | 355 | 10 |
97980 | 97980 | 2020-04-28 | Virginia Beach city | Virginia | 51810 | 359 | 12 |
100830 | 100830 | 2020-04-29 | Virginia Beach city | Virginia | 51810 | 365 | 12 |
103685 | 103685 | 2020-04-30 | Virginia Beach city | Virginia | 51810 | 385 | 14 |
106549 | 106549 | 2020-05-01 | Virginia Beach city | Virginia | 51810 | 396 | 14 |
109418 | 109418 | 2020-05-02 | Virginia Beach city | Virginia | 51810 | 413 | 15 |
112292 | 112292 | 2020-05-03 | Virginia Beach city | Virginia | 51810 | 413 | 15 |
115175 | 115175 | 2020-05-04 | Virginia Beach city | Virginia | 51810 | 439 | 15 |
118134 | 118134 | 2020-05-05 | Virginia Beach city | Virginia | 51810 | 445 | 15 |
121098 | 121098 | 2020-05-06 | Virginia Beach city | Virginia | 51810 | 445 | 15 |
124078 | 124078 | 2020-05-07 | Virginia Beach city | Virginia | 51810 | 454 | 17 |
127063 | 127063 | 2020-05-08 | Virginia Beach city | Virginia | 51810 | 469 | 17 |
130053 | 130053 | 2020-05-09 | Virginia Beach city | Virginia | 51810 | 478 | 17 |
133043 | 133043 | 2020-05-10 | Virginia Beach city | Virginia | 51810 | 491 | 17 |
136033 | 136033 | 2020-05-11 | Virginia Beach city | Virginia | 51810 | 505 | 17 |
139024 | 139024 | 2020-05-12 | Virginia Beach city | Virginia | 51810 | 509 | 18 |
142020 | 142020 | 2020-05-13 | Virginia Beach city | Virginia | 51810 | 519 | 18 |
145017 | 145017 | 2020-05-14 | Virginia Beach city | Virginia | 51810 | 528 | 19 |
148020 | 148020 | 2020-05-15 | Virginia Beach city | Virginia | 51810 | 535 | 19 |
151029 | 151029 | 2020-05-16 | Virginia Beach city | Virginia | 51810 | 539 | 19 |
154040 | 154040 | 2020-05-17 | Virginia Beach city | Virginia | 51810 | 548 | 19 |
157057 | 157057 | 2020-05-18 | Virginia Beach city | Virginia | 51810 | 557 | 19 |
160081 | 160081 | 2020-05-19 | Virginia Beach city | Virginia | 51810 | 559 | 19 |
163109 | 163109 | 2020-05-20 | Virginia Beach city | Virginia | 51810 | 564 | 19 |
166138 | 166138 | 2020-05-21 | Virginia Beach city | Virginia | 51810 | 584 | 19 |
169174 | 169174 | 2020-05-22 | Virginia Beach city | Virginia | 51810 | 591 | 19 |
172215 | 172215 | 2020-05-23 | Virginia Beach city | Virginia | 51810 | 598 | 19 |
175258 | 175258 | 2020-05-24 | Virginia Beach city | Virginia | 51810 | 603 | 19 |
178303 | 178303 | 2020-05-25 | Virginia Beach city | Virginia | 51810 | 618 | 20 |
181347 | 181347 | 2020-05-26 | Virginia Beach city | Virginia | 51810 | 638 | 23 |
184398 | 184398 | 2020-05-27 | Virginia Beach city | Virginia | 51810 | 646 | 22 |
187455 | 187455 | 2020-05-28 | Virginia Beach city | Virginia | 51810 | 662 | 22 |
190519 | 190519 | 2020-05-29 | Virginia Beach city | Virginia | 51810 | 680 | 23 |
193585 | 193585 | 2020-05-30 | Virginia Beach city | Virginia | 51810 | 699 | 23 |
196655 | 196655 | 2020-05-31 | Virginia Beach city | Virginia | 51810 | 708 | 23 |
199728 | 199728 | 2020-06-01 | Virginia Beach city | Virginia | 51810 | 745 | 23 |
202804 | 202804 | 2020-06-02 | Virginia Beach city | Virginia | 51810 | 752 | 23 |
205883 | 205883 | 2020-06-03 | Virginia Beach city | Virginia | 51810 | 752 | 23 |
208965 | 208965 | 2020-06-04 | Virginia Beach city | Virginia | 51810 | 770 | 24 |
212050 | 212050 | 2020-06-05 | Virginia Beach city | Virginia | 51810 | 784 | 25 |
215137 | 215137 | 2020-06-06 | Virginia Beach city | Virginia | 51810 | 798 | 25 |
218227 | 218227 | 2020-06-07 | Virginia Beach city | Virginia | 51810 | 801 | 25 |
221319 | 221319 | 2020-06-08 | Virginia Beach city | Virginia | 51810 | 810 | 25 |
224415 | 224415 | 2020-06-09 | Virginia Beach city | Virginia | 51810 | 815 | 27 |
227515 | 227515 | 2020-06-10 | Virginia Beach city | Virginia | 51810 | 823 | 27 |
230619 | 230619 | 2020-06-11 | Virginia Beach city | Virginia | 51810 | 832 | 27 |
233724 | 233724 | 2020-06-12 | Virginia Beach city | Virginia | 51810 | 847 | 27 |
236831 | 236831 | 2020-06-13 | Virginia Beach city | Virginia | 51810 | 869 | 27 |
239939 | 239939 | 2020-06-14 | Virginia Beach city | Virginia | 51810 | 890 | 27 |
243050 | 243050 | 2020-06-15 | Virginia Beach city | Virginia | 51810 | 899 | 27 |
246163 | 246163 | 2020-06-16 | Virginia Beach city | Virginia | 51810 | 909 | 27 |
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);