ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
778 rows where county = "Bristol city" and state = "Virginia" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
388846 | 388846 | 2020-07-31 | Bristol city | Virginia | 51520 | 57 | 0 |
385629 | 385629 | 2020-07-30 | Bristol city | Virginia | 51520 | 50 | 0 |
382411 | 382411 | 2020-07-29 | Bristol city | Virginia | 51520 | 48 | 0 |
379194 | 379194 | 2020-07-28 | Bristol city | Virginia | 51520 | 44 | 0 |
375978 | 375978 | 2020-07-27 | Bristol city | Virginia | 51520 | 41 | 0 |
372764 | 372764 | 2020-07-26 | Bristol city | Virginia | 51520 | 40 | 0 |
369552 | 369552 | 2020-07-25 | Bristol city | Virginia | 51520 | 39 | 0 |
366343 | 366343 | 2020-07-24 | Bristol city | Virginia | 51520 | 34 | 0 |
363137 | 363137 | 2020-07-23 | Bristol city | Virginia | 51520 | 31 | 0 |
359931 | 359931 | 2020-07-22 | Bristol city | Virginia | 51520 | 27 | 0 |
356726 | 356726 | 2020-07-21 | Bristol city | Virginia | 51520 | 25 | 0 |
353523 | 353523 | 2020-07-20 | Bristol city | Virginia | 51520 | 23 | 0 |
350321 | 350321 | 2020-07-19 | Bristol city | Virginia | 51520 | 21 | 0 |
347120 | 347120 | 2020-07-18 | Bristol city | Virginia | 51520 | 18 | 0 |
343920 | 343920 | 2020-07-17 | Bristol city | Virginia | 51520 | 15 | 0 |
340721 | 340721 | 2020-07-16 | Bristol city | Virginia | 51520 | 15 | 0 |
337525 | 337525 | 2020-07-15 | Bristol city | Virginia | 51520 | 14 | 0 |
334330 | 334330 | 2020-07-14 | Bristol city | Virginia | 51520 | 14 | 0 |
331137 | 331137 | 2020-07-13 | Bristol city | Virginia | 51520 | 13 | 0 |
327951 | 327951 | 2020-07-12 | Bristol city | Virginia | 51520 | 13 | 0 |
324766 | 324766 | 2020-07-11 | Bristol city | Virginia | 51520 | 12 | 0 |
321585 | 321585 | 2020-07-10 | Bristol city | Virginia | 51520 | 10 | 0 |
318406 | 318406 | 2020-07-09 | Bristol city | Virginia | 51520 | 8 | 0 |
315233 | 315233 | 2020-07-08 | Bristol city | Virginia | 51520 | 7 | 0 |
312058 | 312058 | 2020-07-07 | Bristol city | Virginia | 51520 | 5 | 0 |
308889 | 308889 | 2020-07-06 | Bristol city | Virginia | 51520 | 5 | 0 |
305721 | 305721 | 2020-07-05 | Bristol city | Virginia | 51520 | 5 | 0 |
302557 | 302557 | 2020-07-04 | Bristol city | Virginia | 51520 | 5 | 0 |
299393 | 299393 | 2020-07-03 | Bristol city | Virginia | 51520 | 5 | 0 |
296231 | 296231 | 2020-07-02 | Bristol city | Virginia | 51520 | 4 | 0 |
293076 | 293076 | 2020-07-01 | Bristol city | Virginia | 51520 | 4 | 0 |
289923 | 289923 | 2020-06-30 | Bristol city | Virginia | 51520 | 4 | 0 |
286773 | 286773 | 2020-06-29 | Bristol city | Virginia | 51520 | 4 | 0 |
283627 | 283627 | 2020-06-28 | Bristol city | Virginia | 51520 | 4 | 0 |
280481 | 280481 | 2020-06-27 | Bristol city | Virginia | 51520 | 4 | 0 |
277333 | 277333 | 2020-06-26 | Bristol city | Virginia | 51520 | 4 | 0 |
274185 | 274185 | 2020-06-25 | Bristol city | Virginia | 51520 | 4 | 0 |
271045 | 271045 | 2020-06-24 | Bristol city | Virginia | 51520 | 4 | 0 |
267911 | 267911 | 2020-06-23 | Bristol city | Virginia | 51520 | 4 | 0 |
264782 | 264782 | 2020-06-22 | Bristol city | Virginia | 51520 | 4 | 0 |
261653 | 261653 | 2020-06-21 | Bristol city | Virginia | 51520 | 4 | 0 |
258526 | 258526 | 2020-06-20 | Bristol city | Virginia | 51520 | 4 | 0 |
255399 | 255399 | 2020-06-19 | Bristol city | Virginia | 51520 | 4 | 0 |
252280 | 252280 | 2020-06-18 | Bristol city | Virginia | 51520 | 4 | 0 |
249165 | 249165 | 2020-06-17 | Bristol city | Virginia | 51520 | 4 | 0 |
246053 | 246053 | 2020-06-16 | Bristol city | Virginia | 51520 | 4 | 0 |
242941 | 242941 | 2020-06-15 | Bristol city | Virginia | 51520 | 4 | 0 |
239830 | 239830 | 2020-06-14 | Bristol city | Virginia | 51520 | 4 | 0 |
236722 | 236722 | 2020-06-13 | Bristol city | Virginia | 51520 | 4 | 0 |
233615 | 233615 | 2020-06-12 | Bristol city | Virginia | 51520 | 4 | 0 |
230510 | 230510 | 2020-06-11 | Bristol city | Virginia | 51520 | 4 | 0 |
227406 | 227406 | 2020-06-10 | Bristol city | Virginia | 51520 | 4 | 0 |
224306 | 224306 | 2020-06-09 | Bristol city | Virginia | 51520 | 4 | 0 |
221210 | 221210 | 2020-06-08 | Bristol city | Virginia | 51520 | 4 | 0 |
218118 | 218118 | 2020-06-07 | Bristol city | Virginia | 51520 | 4 | 0 |
215028 | 215028 | 2020-06-06 | Bristol city | Virginia | 51520 | 4 | 0 |
211941 | 211941 | 2020-06-05 | Bristol city | Virginia | 51520 | 4 | 0 |
208856 | 208856 | 2020-06-04 | Bristol city | Virginia | 51520 | 4 | 0 |
205774 | 205774 | 2020-06-03 | Bristol city | Virginia | 51520 | 4 | 0 |
202695 | 202695 | 2020-06-02 | Bristol city | Virginia | 51520 | 4 | 0 |
199619 | 199619 | 2020-06-01 | Bristol city | Virginia | 51520 | 4 | 0 |
196546 | 196546 | 2020-05-31 | Bristol city | Virginia | 51520 | 4 | 0 |
193476 | 193476 | 2020-05-30 | Bristol city | Virginia | 51520 | 4 | 0 |
190410 | 190410 | 2020-05-29 | Bristol city | Virginia | 51520 | 4 | 0 |
187346 | 187346 | 2020-05-28 | Bristol city | Virginia | 51520 | 4 | 0 |
184289 | 184289 | 2020-05-27 | Bristol city | Virginia | 51520 | 4 | 0 |
181238 | 181238 | 2020-05-26 | Bristol city | Virginia | 51520 | 4 | 0 |
178194 | 178194 | 2020-05-25 | Bristol city | Virginia | 51520 | 4 | 0 |
175149 | 175149 | 2020-05-24 | Bristol city | Virginia | 51520 | 4 | 0 |
172106 | 172106 | 2020-05-23 | Bristol city | Virginia | 51520 | 4 | 0 |
169065 | 169065 | 2020-05-22 | Bristol city | Virginia | 51520 | 4 | 0 |
166029 | 166029 | 2020-05-21 | Bristol city | Virginia | 51520 | 4 | 0 |
163000 | 163000 | 2020-05-20 | Bristol city | Virginia | 51520 | 3 | 0 |
159972 | 159972 | 2020-05-19 | Bristol city | Virginia | 51520 | 3 | 0 |
156948 | 156948 | 2020-05-18 | Bristol city | Virginia | 51520 | 3 | 0 |
153931 | 153931 | 2020-05-17 | Bristol city | Virginia | 51520 | 3 | 0 |
150920 | 150920 | 2020-05-16 | Bristol city | Virginia | 51520 | 3 | 0 |
147911 | 147911 | 2020-05-15 | Bristol city | Virginia | 51520 | 3 | 0 |
144908 | 144908 | 2020-05-14 | Bristol city | Virginia | 51520 | 3 | 0 |
141911 | 141911 | 2020-05-13 | Bristol city | Virginia | 51520 | 3 | 0 |
138915 | 138915 | 2020-05-12 | Bristol city | Virginia | 51520 | 3 | 0 |
135924 | 135924 | 2020-05-11 | Bristol city | Virginia | 51520 | 3 | 0 |
132934 | 132934 | 2020-05-10 | Bristol city | Virginia | 51520 | 3 | 0 |
129944 | 129944 | 2020-05-09 | Bristol city | Virginia | 51520 | 2 | 0 |
126955 | 126955 | 2020-05-08 | Bristol city | Virginia | 51520 | 2 | 0 |
123970 | 123970 | 2020-05-07 | Bristol city | Virginia | 51520 | 2 | 0 |
120989 | 120989 | 2020-05-06 | Bristol city | Virginia | 51520 | 2 | 0 |
118025 | 118025 | 2020-05-05 | Bristol city | Virginia | 51520 | 2 | 0 |
115066 | 115066 | 2020-05-04 | Bristol city | Virginia | 51520 | 2 | 0 |
112183 | 112183 | 2020-05-03 | Bristol city | Virginia | 51520 | 2 | 0 |
109309 | 109309 | 2020-05-02 | Bristol city | Virginia | 51520 | 1 | 0 |
106440 | 106440 | 2020-05-01 | Bristol city | Virginia | 51520 | 1 | 0 |
103576 | 103576 | 2020-04-30 | Bristol city | Virginia | 51520 | 1 | 0 |
100721 | 100721 | 2020-04-29 | Bristol city | Virginia | 51520 | 1 | 0 |
97871 | 97871 | 2020-04-28 | Bristol city | Virginia | 51520 | 1 | 0 |
95029 | 95029 | 2020-04-27 | Bristol city | Virginia | 51520 | 1 | 0 |
92200 | 92200 | 2020-04-26 | Bristol city | Virginia | 51520 | 1 | 0 |
89383 | 89383 | 2020-04-25 | Bristol city | Virginia | 51520 | 1 | 0 |
86568 | 86568 | 2020-04-24 | Bristol city | Virginia | 51520 | 1 | 0 |
83761 | 83761 | 2020-04-23 | Bristol city | Virginia | 51520 | 1 | 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);