ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where county = "Gloucester" and state = "Virginia" sorted by county
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date | county ▼ | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
5995 | 5995 | 2020-03-20 | Gloucester | Virginia | 51073 | 1 | 0 |
7023 | 7023 | 2020-03-21 | Gloucester | Virginia | 51073 | 2 | 0 |
8157 | 8157 | 2020-03-22 | Gloucester | Virginia | 51073 | 2 | 0 |
9379 | 9379 | 2020-03-23 | Gloucester | Virginia | 51073 | 2 | 0 |
10726 | 10726 | 2020-03-24 | Gloucester | Virginia | 51073 | 2 | 0 |
12240 | 12240 | 2020-03-25 | Gloucester | Virginia | 51073 | 2 | 0 |
13878 | 13878 | 2020-03-26 | Gloucester | Virginia | 51073 | 3 | 0 |
15646 | 15646 | 2020-03-27 | Gloucester | Virginia | 51073 | 3 | 0 |
17520 | 17520 | 2020-03-28 | Gloucester | Virginia | 51073 | 6 | 0 |
19480 | 19480 | 2020-03-29 | Gloucester | Virginia | 51073 | 6 | 0 |
21543 | 21543 | 2020-03-30 | Gloucester | Virginia | 51073 | 7 | 0 |
23688 | 23688 | 2020-03-31 | Gloucester | Virginia | 51073 | 7 | 0 |
25904 | 25904 | 2020-04-01 | Gloucester | Virginia | 51073 | 8 | 0 |
28194 | 28194 | 2020-04-02 | Gloucester | Virginia | 51073 | 8 | 0 |
30540 | 30540 | 2020-04-03 | Gloucester | Virginia | 51073 | 8 | 0 |
32939 | 32939 | 2020-04-04 | Gloucester | Virginia | 51073 | 9 | 0 |
35377 | 35377 | 2020-04-05 | Gloucester | Virginia | 51073 | 10 | 0 |
37860 | 37860 | 2020-04-06 | Gloucester | Virginia | 51073 | 12 | 0 |
40393 | 40393 | 2020-04-07 | Gloucester | Virginia | 51073 | 15 | 0 |
42962 | 42962 | 2020-04-08 | Gloucester | Virginia | 51073 | 16 | 0 |
45557 | 45557 | 2020-04-09 | Gloucester | Virginia | 51073 | 16 | 0 |
48183 | 48183 | 2020-04-10 | Gloucester | Virginia | 51073 | 18 | 0 |
50841 | 50841 | 2020-04-11 | Gloucester | Virginia | 51073 | 20 | 0 |
53516 | 53516 | 2020-04-12 | Gloucester | Virginia | 51073 | 20 | 0 |
56206 | 56206 | 2020-04-13 | Gloucester | Virginia | 51073 | 20 | 0 |
58912 | 58912 | 2020-04-14 | Gloucester | Virginia | 51073 | 20 | 0 |
61631 | 61631 | 2020-04-15 | Gloucester | Virginia | 51073 | 20 | 0 |
64364 | 64364 | 2020-04-16 | Gloucester | Virginia | 51073 | 20 | 0 |
67112 | 67112 | 2020-04-17 | Gloucester | Virginia | 51073 | 20 | 0 |
69874 | 69874 | 2020-04-18 | Gloucester | Virginia | 51073 | 21 | 0 |
72644 | 72644 | 2020-04-19 | Gloucester | Virginia | 51073 | 21 | 0 |
75420 | 75420 | 2020-04-20 | Gloucester | Virginia | 51073 | 21 | 0 |
78202 | 78202 | 2020-04-21 | Gloucester | Virginia | 51073 | 21 | 1 |
80994 | 80994 | 2020-04-22 | Gloucester | Virginia | 51073 | 21 | 1 |
83795 | 83795 | 2020-04-23 | Gloucester | Virginia | 51073 | 21 | 1 |
86602 | 86602 | 2020-04-24 | Gloucester | Virginia | 51073 | 21 | 1 |
89417 | 89417 | 2020-04-25 | Gloucester | Virginia | 51073 | 22 | 1 |
92234 | 92234 | 2020-04-26 | Gloucester | Virginia | 51073 | 22 | 1 |
95063 | 95063 | 2020-04-27 | Gloucester | Virginia | 51073 | 22 | 1 |
97905 | 97905 | 2020-04-28 | Gloucester | Virginia | 51073 | 22 | 1 |
100755 | 100755 | 2020-04-29 | Gloucester | Virginia | 51073 | 23 | 1 |
103610 | 103610 | 2020-04-30 | Gloucester | Virginia | 51073 | 23 | 1 |
106474 | 106474 | 2020-05-01 | Gloucester | Virginia | 51073 | 24 | 1 |
109343 | 109343 | 2020-05-02 | Gloucester | Virginia | 51073 | 24 | 1 |
112217 | 112217 | 2020-05-03 | Gloucester | Virginia | 51073 | 25 | 1 |
115100 | 115100 | 2020-05-04 | Gloucester | Virginia | 51073 | 27 | 1 |
118059 | 118059 | 2020-05-05 | Gloucester | Virginia | 51073 | 26 | 1 |
121023 | 121023 | 2020-05-06 | Gloucester | Virginia | 51073 | 26 | 1 |
124004 | 124004 | 2020-05-07 | Gloucester | Virginia | 51073 | 27 | 1 |
126989 | 126989 | 2020-05-08 | Gloucester | Virginia | 51073 | 27 | 1 |
129979 | 129979 | 2020-05-09 | Gloucester | Virginia | 51073 | 27 | 1 |
132969 | 132969 | 2020-05-10 | Gloucester | Virginia | 51073 | 27 | 1 |
135959 | 135959 | 2020-05-11 | Gloucester | Virginia | 51073 | 27 | 1 |
138950 | 138950 | 2020-05-12 | Gloucester | Virginia | 51073 | 27 | 1 |
141946 | 141946 | 2020-05-13 | Gloucester | Virginia | 51073 | 28 | 1 |
144943 | 144943 | 2020-05-14 | Gloucester | Virginia | 51073 | 28 | 1 |
147946 | 147946 | 2020-05-15 | Gloucester | Virginia | 51073 | 28 | 1 |
150955 | 150955 | 2020-05-16 | Gloucester | Virginia | 51073 | 28 | 1 |
153966 | 153966 | 2020-05-17 | Gloucester | Virginia | 51073 | 28 | 1 |
156983 | 156983 | 2020-05-18 | Gloucester | Virginia | 51073 | 28 | 1 |
160007 | 160007 | 2020-05-19 | Gloucester | Virginia | 51073 | 28 | 1 |
163035 | 163035 | 2020-05-20 | Gloucester | Virginia | 51073 | 29 | 1 |
166064 | 166064 | 2020-05-21 | Gloucester | Virginia | 51073 | 30 | 1 |
169100 | 169100 | 2020-05-22 | Gloucester | Virginia | 51073 | 30 | 1 |
172141 | 172141 | 2020-05-23 | Gloucester | Virginia | 51073 | 30 | 1 |
175184 | 175184 | 2020-05-24 | Gloucester | Virginia | 51073 | 30 | 1 |
178229 | 178229 | 2020-05-25 | Gloucester | Virginia | 51073 | 30 | 1 |
181273 | 181273 | 2020-05-26 | Gloucester | Virginia | 51073 | 30 | 1 |
184324 | 184324 | 2020-05-27 | Gloucester | Virginia | 51073 | 30 | 1 |
187381 | 187381 | 2020-05-28 | Gloucester | Virginia | 51073 | 30 | 1 |
190445 | 190445 | 2020-05-29 | Gloucester | Virginia | 51073 | 30 | 1 |
193511 | 193511 | 2020-05-30 | Gloucester | Virginia | 51073 | 31 | 1 |
196581 | 196581 | 2020-05-31 | Gloucester | Virginia | 51073 | 31 | 1 |
199654 | 199654 | 2020-06-01 | Gloucester | Virginia | 51073 | 31 | 1 |
202730 | 202730 | 2020-06-02 | Gloucester | Virginia | 51073 | 31 | 1 |
205809 | 205809 | 2020-06-03 | Gloucester | Virginia | 51073 | 31 | 1 |
208891 | 208891 | 2020-06-04 | Gloucester | Virginia | 51073 | 31 | 1 |
211976 | 211976 | 2020-06-05 | Gloucester | Virginia | 51073 | 32 | 1 |
215063 | 215063 | 2020-06-06 | Gloucester | Virginia | 51073 | 32 | 1 |
218153 | 218153 | 2020-06-07 | Gloucester | Virginia | 51073 | 32 | 1 |
221245 | 221245 | 2020-06-08 | Gloucester | Virginia | 51073 | 33 | 1 |
224341 | 224341 | 2020-06-09 | Gloucester | Virginia | 51073 | 33 | 1 |
227441 | 227441 | 2020-06-10 | Gloucester | Virginia | 51073 | 33 | 1 |
230545 | 230545 | 2020-06-11 | Gloucester | Virginia | 51073 | 34 | 1 |
233650 | 233650 | 2020-06-12 | Gloucester | Virginia | 51073 | 35 | 1 |
236757 | 236757 | 2020-06-13 | Gloucester | Virginia | 51073 | 36 | 1 |
239865 | 239865 | 2020-06-14 | Gloucester | Virginia | 51073 | 37 | 1 |
242976 | 242976 | 2020-06-15 | Gloucester | Virginia | 51073 | 38 | 1 |
246089 | 246089 | 2020-06-16 | Gloucester | Virginia | 51073 | 38 | 1 |
249201 | 249201 | 2020-06-17 | Gloucester | Virginia | 51073 | 38 | 1 |
252316 | 252316 | 2020-06-18 | Gloucester | Virginia | 51073 | 40 | 1 |
255435 | 255435 | 2020-06-19 | Gloucester | Virginia | 51073 | 41 | 1 |
258562 | 258562 | 2020-06-20 | Gloucester | Virginia | 51073 | 42 | 1 |
261689 | 261689 | 2020-06-21 | Gloucester | Virginia | 51073 | 42 | 1 |
264818 | 264818 | 2020-06-22 | Gloucester | Virginia | 51073 | 42 | 1 |
267947 | 267947 | 2020-06-23 | Gloucester | Virginia | 51073 | 42 | 1 |
271081 | 271081 | 2020-06-24 | Gloucester | Virginia | 51073 | 45 | 1 |
274221 | 274221 | 2020-06-25 | Gloucester | Virginia | 51073 | 46 | 1 |
277369 | 277369 | 2020-06-26 | Gloucester | Virginia | 51073 | 47 | 1 |
280517 | 280517 | 2020-06-27 | Gloucester | Virginia | 51073 | 44 | 1 |
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);