ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
99 rows where county = "Gloucester", deaths = 1 and fips = 51073 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
379230 | 379230 | 2020-07-28 | Gloucester | Virginia | 51073 | 138 | 1 |
376014 | 376014 | 2020-07-27 | Gloucester | Virginia | 51073 | 132 | 1 |
372800 | 372800 | 2020-07-26 | Gloucester | Virginia | 51073 | 127 | 1 |
369588 | 369588 | 2020-07-25 | Gloucester | Virginia | 51073 | 123 | 1 |
366379 | 366379 | 2020-07-24 | Gloucester | Virginia | 51073 | 118 | 1 |
363173 | 363173 | 2020-07-23 | Gloucester | Virginia | 51073 | 115 | 1 |
359967 | 359967 | 2020-07-22 | Gloucester | Virginia | 51073 | 112 | 1 |
356762 | 356762 | 2020-07-21 | Gloucester | Virginia | 51073 | 109 | 1 |
353559 | 353559 | 2020-07-20 | Gloucester | Virginia | 51073 | 99 | 1 |
350357 | 350357 | 2020-07-19 | Gloucester | Virginia | 51073 | 93 | 1 |
347156 | 347156 | 2020-07-18 | Gloucester | Virginia | 51073 | 88 | 1 |
343956 | 343956 | 2020-07-17 | Gloucester | Virginia | 51073 | 86 | 1 |
340757 | 340757 | 2020-07-16 | Gloucester | Virginia | 51073 | 80 | 1 |
337561 | 337561 | 2020-07-15 | Gloucester | Virginia | 51073 | 79 | 1 |
334366 | 334366 | 2020-07-14 | Gloucester | Virginia | 51073 | 76 | 1 |
331173 | 331173 | 2020-07-13 | Gloucester | Virginia | 51073 | 69 | 1 |
327987 | 327987 | 2020-07-12 | Gloucester | Virginia | 51073 | 67 | 1 |
324802 | 324802 | 2020-07-11 | Gloucester | Virginia | 51073 | 67 | 1 |
321621 | 321621 | 2020-07-10 | Gloucester | Virginia | 51073 | 65 | 1 |
318442 | 318442 | 2020-07-09 | Gloucester | Virginia | 51073 | 64 | 1 |
315269 | 315269 | 2020-07-08 | Gloucester | Virginia | 51073 | 52 | 1 |
312094 | 312094 | 2020-07-07 | Gloucester | Virginia | 51073 | 53 | 1 |
308925 | 308925 | 2020-07-06 | Gloucester | Virginia | 51073 | 50 | 1 |
305757 | 305757 | 2020-07-05 | Gloucester | Virginia | 51073 | 50 | 1 |
302593 | 302593 | 2020-07-04 | Gloucester | Virginia | 51073 | 49 | 1 |
299429 | 299429 | 2020-07-03 | Gloucester | Virginia | 51073 | 49 | 1 |
296267 | 296267 | 2020-07-02 | Gloucester | Virginia | 51073 | 49 | 1 |
293112 | 293112 | 2020-07-01 | Gloucester | Virginia | 51073 | 49 | 1 |
289959 | 289959 | 2020-06-30 | Gloucester | Virginia | 51073 | 49 | 1 |
286809 | 286809 | 2020-06-29 | Gloucester | Virginia | 51073 | 48 | 1 |
283663 | 283663 | 2020-06-28 | Gloucester | Virginia | 51073 | 45 | 1 |
280517 | 280517 | 2020-06-27 | Gloucester | Virginia | 51073 | 44 | 1 |
277369 | 277369 | 2020-06-26 | Gloucester | Virginia | 51073 | 47 | 1 |
274221 | 274221 | 2020-06-25 | Gloucester | Virginia | 51073 | 46 | 1 |
271081 | 271081 | 2020-06-24 | Gloucester | Virginia | 51073 | 45 | 1 |
267947 | 267947 | 2020-06-23 | Gloucester | Virginia | 51073 | 42 | 1 |
264818 | 264818 | 2020-06-22 | Gloucester | Virginia | 51073 | 42 | 1 |
261689 | 261689 | 2020-06-21 | Gloucester | Virginia | 51073 | 42 | 1 |
258562 | 258562 | 2020-06-20 | Gloucester | Virginia | 51073 | 42 | 1 |
255435 | 255435 | 2020-06-19 | Gloucester | Virginia | 51073 | 41 | 1 |
252316 | 252316 | 2020-06-18 | Gloucester | Virginia | 51073 | 40 | 1 |
249201 | 249201 | 2020-06-17 | Gloucester | Virginia | 51073 | 38 | 1 |
246089 | 246089 | 2020-06-16 | Gloucester | Virginia | 51073 | 38 | 1 |
242976 | 242976 | 2020-06-15 | Gloucester | Virginia | 51073 | 38 | 1 |
239865 | 239865 | 2020-06-14 | Gloucester | Virginia | 51073 | 37 | 1 |
236757 | 236757 | 2020-06-13 | Gloucester | Virginia | 51073 | 36 | 1 |
233650 | 233650 | 2020-06-12 | Gloucester | Virginia | 51073 | 35 | 1 |
230545 | 230545 | 2020-06-11 | Gloucester | Virginia | 51073 | 34 | 1 |
227441 | 227441 | 2020-06-10 | Gloucester | Virginia | 51073 | 33 | 1 |
224341 | 224341 | 2020-06-09 | Gloucester | Virginia | 51073 | 33 | 1 |
221245 | 221245 | 2020-06-08 | Gloucester | Virginia | 51073 | 33 | 1 |
218153 | 218153 | 2020-06-07 | Gloucester | Virginia | 51073 | 32 | 1 |
215063 | 215063 | 2020-06-06 | Gloucester | Virginia | 51073 | 32 | 1 |
211976 | 211976 | 2020-06-05 | Gloucester | Virginia | 51073 | 32 | 1 |
208891 | 208891 | 2020-06-04 | Gloucester | Virginia | 51073 | 31 | 1 |
205809 | 205809 | 2020-06-03 | Gloucester | Virginia | 51073 | 31 | 1 |
202730 | 202730 | 2020-06-02 | Gloucester | Virginia | 51073 | 31 | 1 |
199654 | 199654 | 2020-06-01 | Gloucester | Virginia | 51073 | 31 | 1 |
196581 | 196581 | 2020-05-31 | Gloucester | Virginia | 51073 | 31 | 1 |
193511 | 193511 | 2020-05-30 | Gloucester | Virginia | 51073 | 31 | 1 |
190445 | 190445 | 2020-05-29 | Gloucester | Virginia | 51073 | 30 | 1 |
187381 | 187381 | 2020-05-28 | Gloucester | Virginia | 51073 | 30 | 1 |
184324 | 184324 | 2020-05-27 | Gloucester | Virginia | 51073 | 30 | 1 |
181273 | 181273 | 2020-05-26 | Gloucester | Virginia | 51073 | 30 | 1 |
178229 | 178229 | 2020-05-25 | Gloucester | Virginia | 51073 | 30 | 1 |
175184 | 175184 | 2020-05-24 | Gloucester | Virginia | 51073 | 30 | 1 |
172141 | 172141 | 2020-05-23 | Gloucester | Virginia | 51073 | 30 | 1 |
169100 | 169100 | 2020-05-22 | Gloucester | Virginia | 51073 | 30 | 1 |
166064 | 166064 | 2020-05-21 | Gloucester | Virginia | 51073 | 30 | 1 |
163035 | 163035 | 2020-05-20 | Gloucester | Virginia | 51073 | 29 | 1 |
160007 | 160007 | 2020-05-19 | Gloucester | Virginia | 51073 | 28 | 1 |
156983 | 156983 | 2020-05-18 | Gloucester | Virginia | 51073 | 28 | 1 |
153966 | 153966 | 2020-05-17 | Gloucester | Virginia | 51073 | 28 | 1 |
150955 | 150955 | 2020-05-16 | Gloucester | Virginia | 51073 | 28 | 1 |
147946 | 147946 | 2020-05-15 | Gloucester | Virginia | 51073 | 28 | 1 |
144943 | 144943 | 2020-05-14 | Gloucester | Virginia | 51073 | 28 | 1 |
141946 | 141946 | 2020-05-13 | Gloucester | Virginia | 51073 | 28 | 1 |
138950 | 138950 | 2020-05-12 | Gloucester | Virginia | 51073 | 27 | 1 |
135959 | 135959 | 2020-05-11 | Gloucester | Virginia | 51073 | 27 | 1 |
132969 | 132969 | 2020-05-10 | Gloucester | Virginia | 51073 | 27 | 1 |
129979 | 129979 | 2020-05-09 | Gloucester | Virginia | 51073 | 27 | 1 |
126989 | 126989 | 2020-05-08 | Gloucester | Virginia | 51073 | 27 | 1 |
124004 | 124004 | 2020-05-07 | Gloucester | Virginia | 51073 | 27 | 1 |
121023 | 121023 | 2020-05-06 | Gloucester | Virginia | 51073 | 26 | 1 |
118059 | 118059 | 2020-05-05 | Gloucester | Virginia | 51073 | 26 | 1 |
115100 | 115100 | 2020-05-04 | Gloucester | Virginia | 51073 | 27 | 1 |
112217 | 112217 | 2020-05-03 | Gloucester | Virginia | 51073 | 25 | 1 |
109343 | 109343 | 2020-05-02 | Gloucester | Virginia | 51073 | 24 | 1 |
106474 | 106474 | 2020-05-01 | Gloucester | Virginia | 51073 | 24 | 1 |
103610 | 103610 | 2020-04-30 | Gloucester | Virginia | 51073 | 23 | 1 |
100755 | 100755 | 2020-04-29 | Gloucester | Virginia | 51073 | 23 | 1 |
97905 | 97905 | 2020-04-28 | Gloucester | Virginia | 51073 | 22 | 1 |
95063 | 95063 | 2020-04-27 | Gloucester | Virginia | 51073 | 22 | 1 |
92234 | 92234 | 2020-04-26 | Gloucester | Virginia | 51073 | 22 | 1 |
89417 | 89417 | 2020-04-25 | Gloucester | Virginia | 51073 | 22 | 1 |
86602 | 86602 | 2020-04-24 | Gloucester | Virginia | 51073 | 21 | 1 |
83795 | 83795 | 2020-04-23 | Gloucester | Virginia | 51073 | 21 | 1 |
80994 | 80994 | 2020-04-22 | Gloucester | Virginia | 51073 | 21 | 1 |
78202 | 78202 | 2020-04-21 | Gloucester | Virginia | 51073 | 21 | 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);