ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
778 rows where fips = 51520 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 |
---|---|---|---|---|---|---|---|
15632 | 15632 | 2020-03-27 | Bristol city | Virginia | 51520 | 1 | 0 |
17506 | 17506 | 2020-03-28 | Bristol city | Virginia | 51520 | 1 | 0 |
19466 | 19466 | 2020-03-29 | Bristol city | Virginia | 51520 | 1 | 0 |
21529 | 21529 | 2020-03-30 | Bristol city | Virginia | 51520 | 1 | 0 |
23668 | 23668 | 2020-03-31 | Bristol city | Virginia | 51520 | 1 | 0 |
25884 | 25884 | 2020-04-01 | Bristol city | Virginia | 51520 | 1 | 0 |
28173 | 28173 | 2020-04-02 | Bristol city | Virginia | 51520 | 1 | 0 |
30516 | 30516 | 2020-04-03 | Bristol city | Virginia | 51520 | 1 | 0 |
32914 | 32914 | 2020-04-04 | Bristol city | Virginia | 51520 | 1 | 0 |
35352 | 35352 | 2020-04-05 | Bristol city | Virginia | 51520 | 1 | 0 |
37834 | 37834 | 2020-04-06 | Bristol city | Virginia | 51520 | 1 | 0 |
40364 | 40364 | 2020-04-07 | Bristol city | Virginia | 51520 | 1 | 0 |
42933 | 42933 | 2020-04-08 | Bristol city | Virginia | 51520 | 1 | 0 |
45527 | 45527 | 2020-04-09 | Bristol city | Virginia | 51520 | 1 | 0 |
48151 | 48151 | 2020-04-10 | Bristol city | Virginia | 51520 | 1 | 0 |
50809 | 50809 | 2020-04-11 | Bristol city | Virginia | 51520 | 1 | 0 |
53484 | 53484 | 2020-04-12 | Bristol city | Virginia | 51520 | 1 | 0 |
56173 | 56173 | 2020-04-13 | Bristol city | Virginia | 51520 | 1 | 0 |
58879 | 58879 | 2020-04-14 | Bristol city | Virginia | 51520 | 1 | 0 |
61598 | 61598 | 2020-04-15 | Bristol city | Virginia | 51520 | 1 | 0 |
64330 | 64330 | 2020-04-16 | Bristol city | Virginia | 51520 | 1 | 0 |
67078 | 67078 | 2020-04-17 | Bristol city | Virginia | 51520 | 1 | 0 |
69840 | 69840 | 2020-04-18 | Bristol city | Virginia | 51520 | 1 | 0 |
72610 | 72610 | 2020-04-19 | Bristol city | Virginia | 51520 | 1 | 0 |
75386 | 75386 | 2020-04-20 | Bristol city | Virginia | 51520 | 1 | 0 |
78168 | 78168 | 2020-04-21 | Bristol city | Virginia | 51520 | 1 | 0 |
80960 | 80960 | 2020-04-22 | Bristol city | Virginia | 51520 | 1 | 0 |
83761 | 83761 | 2020-04-23 | Bristol city | Virginia | 51520 | 1 | 0 |
86568 | 86568 | 2020-04-24 | Bristol city | Virginia | 51520 | 1 | 0 |
89383 | 89383 | 2020-04-25 | Bristol city | Virginia | 51520 | 1 | 0 |
92200 | 92200 | 2020-04-26 | Bristol city | Virginia | 51520 | 1 | 0 |
95029 | 95029 | 2020-04-27 | Bristol city | Virginia | 51520 | 1 | 0 |
97871 | 97871 | 2020-04-28 | Bristol city | Virginia | 51520 | 1 | 0 |
100721 | 100721 | 2020-04-29 | Bristol city | Virginia | 51520 | 1 | 0 |
103576 | 103576 | 2020-04-30 | Bristol city | Virginia | 51520 | 1 | 0 |
106440 | 106440 | 2020-05-01 | Bristol city | Virginia | 51520 | 1 | 0 |
109309 | 109309 | 2020-05-02 | Bristol city | Virginia | 51520 | 1 | 0 |
112183 | 112183 | 2020-05-03 | Bristol city | Virginia | 51520 | 2 | 0 |
115066 | 115066 | 2020-05-04 | Bristol city | Virginia | 51520 | 2 | 0 |
118025 | 118025 | 2020-05-05 | Bristol city | Virginia | 51520 | 2 | 0 |
120989 | 120989 | 2020-05-06 | Bristol city | Virginia | 51520 | 2 | 0 |
123970 | 123970 | 2020-05-07 | Bristol city | Virginia | 51520 | 2 | 0 |
126955 | 126955 | 2020-05-08 | Bristol city | Virginia | 51520 | 2 | 0 |
129944 | 129944 | 2020-05-09 | Bristol city | Virginia | 51520 | 2 | 0 |
132934 | 132934 | 2020-05-10 | Bristol city | Virginia | 51520 | 3 | 0 |
135924 | 135924 | 2020-05-11 | Bristol city | Virginia | 51520 | 3 | 0 |
138915 | 138915 | 2020-05-12 | Bristol city | Virginia | 51520 | 3 | 0 |
141911 | 141911 | 2020-05-13 | Bristol city | Virginia | 51520 | 3 | 0 |
144908 | 144908 | 2020-05-14 | Bristol city | Virginia | 51520 | 3 | 0 |
147911 | 147911 | 2020-05-15 | Bristol city | Virginia | 51520 | 3 | 0 |
150920 | 150920 | 2020-05-16 | Bristol city | Virginia | 51520 | 3 | 0 |
153931 | 153931 | 2020-05-17 | Bristol city | Virginia | 51520 | 3 | 0 |
156948 | 156948 | 2020-05-18 | Bristol city | Virginia | 51520 | 3 | 0 |
159972 | 159972 | 2020-05-19 | Bristol city | Virginia | 51520 | 3 | 0 |
163000 | 163000 | 2020-05-20 | Bristol city | Virginia | 51520 | 3 | 0 |
166029 | 166029 | 2020-05-21 | Bristol city | Virginia | 51520 | 4 | 0 |
169065 | 169065 | 2020-05-22 | Bristol city | Virginia | 51520 | 4 | 0 |
172106 | 172106 | 2020-05-23 | Bristol city | Virginia | 51520 | 4 | 0 |
175149 | 175149 | 2020-05-24 | Bristol city | Virginia | 51520 | 4 | 0 |
178194 | 178194 | 2020-05-25 | Bristol city | Virginia | 51520 | 4 | 0 |
181238 | 181238 | 2020-05-26 | Bristol city | Virginia | 51520 | 4 | 0 |
184289 | 184289 | 2020-05-27 | Bristol city | Virginia | 51520 | 4 | 0 |
187346 | 187346 | 2020-05-28 | Bristol city | Virginia | 51520 | 4 | 0 |
190410 | 190410 | 2020-05-29 | Bristol city | Virginia | 51520 | 4 | 0 |
193476 | 193476 | 2020-05-30 | Bristol city | Virginia | 51520 | 4 | 0 |
196546 | 196546 | 2020-05-31 | Bristol city | Virginia | 51520 | 4 | 0 |
199619 | 199619 | 2020-06-01 | Bristol city | Virginia | 51520 | 4 | 0 |
202695 | 202695 | 2020-06-02 | Bristol city | Virginia | 51520 | 4 | 0 |
205774 | 205774 | 2020-06-03 | Bristol city | Virginia | 51520 | 4 | 0 |
208856 | 208856 | 2020-06-04 | Bristol city | Virginia | 51520 | 4 | 0 |
211941 | 211941 | 2020-06-05 | Bristol city | Virginia | 51520 | 4 | 0 |
215028 | 215028 | 2020-06-06 | Bristol city | Virginia | 51520 | 4 | 0 |
218118 | 218118 | 2020-06-07 | Bristol city | Virginia | 51520 | 4 | 0 |
221210 | 221210 | 2020-06-08 | Bristol city | Virginia | 51520 | 4 | 0 |
224306 | 224306 | 2020-06-09 | Bristol city | Virginia | 51520 | 4 | 0 |
227406 | 227406 | 2020-06-10 | Bristol city | Virginia | 51520 | 4 | 0 |
230510 | 230510 | 2020-06-11 | Bristol city | Virginia | 51520 | 4 | 0 |
233615 | 233615 | 2020-06-12 | Bristol city | Virginia | 51520 | 4 | 0 |
236722 | 236722 | 2020-06-13 | Bristol city | Virginia | 51520 | 4 | 0 |
239830 | 239830 | 2020-06-14 | Bristol city | Virginia | 51520 | 4 | 0 |
242941 | 242941 | 2020-06-15 | Bristol city | Virginia | 51520 | 4 | 0 |
246053 | 246053 | 2020-06-16 | Bristol city | Virginia | 51520 | 4 | 0 |
249165 | 249165 | 2020-06-17 | Bristol city | Virginia | 51520 | 4 | 0 |
252280 | 252280 | 2020-06-18 | Bristol city | Virginia | 51520 | 4 | 0 |
255399 | 255399 | 2020-06-19 | Bristol city | Virginia | 51520 | 4 | 0 |
258526 | 258526 | 2020-06-20 | Bristol city | Virginia | 51520 | 4 | 0 |
261653 | 261653 | 2020-06-21 | Bristol city | Virginia | 51520 | 4 | 0 |
264782 | 264782 | 2020-06-22 | Bristol city | Virginia | 51520 | 4 | 0 |
267911 | 267911 | 2020-06-23 | Bristol city | Virginia | 51520 | 4 | 0 |
271045 | 271045 | 2020-06-24 | Bristol city | Virginia | 51520 | 4 | 0 |
274185 | 274185 | 2020-06-25 | Bristol city | Virginia | 51520 | 4 | 0 |
277333 | 277333 | 2020-06-26 | Bristol city | Virginia | 51520 | 4 | 0 |
280481 | 280481 | 2020-06-27 | Bristol city | Virginia | 51520 | 4 | 0 |
283627 | 283627 | 2020-06-28 | Bristol city | Virginia | 51520 | 4 | 0 |
286773 | 286773 | 2020-06-29 | Bristol city | Virginia | 51520 | 4 | 0 |
289923 | 289923 | 2020-06-30 | Bristol city | Virginia | 51520 | 4 | 0 |
293076 | 293076 | 2020-07-01 | Bristol city | Virginia | 51520 | 4 | 0 |
296231 | 296231 | 2020-07-02 | Bristol city | Virginia | 51520 | 4 | 0 |
299393 | 299393 | 2020-07-03 | Bristol city | Virginia | 51520 | 5 | 0 |
302557 | 302557 | 2020-07-04 | Bristol city | Virginia | 51520 | 5 | 0 |
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);