ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
780 rows where county = "Madison" and fips = 51113 sorted by fips
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date | county | state | fips ▼ | cases | deaths |
---|---|---|---|---|---|---|---|
12251 | 12251 | 2020-03-25 | Madison | Virginia | 51113 | 1 | 0 |
13893 | 13893 | 2020-03-26 | Madison | Virginia | 51113 | 2 | 0 |
15661 | 15661 | 2020-03-27 | Madison | Virginia | 51113 | 2 | 0 |
17537 | 17537 | 2020-03-28 | Madison | Virginia | 51113 | 3 | 0 |
19498 | 19498 | 2020-03-29 | Madison | Virginia | 51113 | 3 | 0 |
21563 | 21563 | 2020-03-30 | Madison | Virginia | 51113 | 3 | 0 |
23709 | 23709 | 2020-03-31 | Madison | Virginia | 51113 | 3 | 0 |
25925 | 25925 | 2020-04-01 | Madison | Virginia | 51113 | 3 | 0 |
28215 | 28215 | 2020-04-02 | Madison | Virginia | 51113 | 3 | 0 |
30562 | 30562 | 2020-04-03 | Madison | Virginia | 51113 | 2 | 0 |
32961 | 32961 | 2020-04-04 | Madison | Virginia | 51113 | 2 | 0 |
35399 | 35399 | 2020-04-05 | Madison | Virginia | 51113 | 3 | 0 |
37882 | 37882 | 2020-04-06 | Madison | Virginia | 51113 | 4 | 0 |
40416 | 40416 | 2020-04-07 | Madison | Virginia | 51113 | 4 | 0 |
42985 | 42985 | 2020-04-08 | Madison | Virginia | 51113 | 5 | 0 |
45580 | 45580 | 2020-04-09 | Madison | Virginia | 51113 | 5 | 0 |
48206 | 48206 | 2020-04-10 | Madison | Virginia | 51113 | 5 | 0 |
50864 | 50864 | 2020-04-11 | Madison | Virginia | 51113 | 6 | 0 |
53539 | 53539 | 2020-04-12 | Madison | Virginia | 51113 | 6 | 0 |
56229 | 56229 | 2020-04-13 | Madison | Virginia | 51113 | 6 | 0 |
58935 | 58935 | 2020-04-14 | Madison | Virginia | 51113 | 7 | 0 |
61654 | 61654 | 2020-04-15 | Madison | Virginia | 51113 | 8 | 0 |
64387 | 64387 | 2020-04-16 | Madison | Virginia | 51113 | 8 | 0 |
67135 | 67135 | 2020-04-17 | Madison | Virginia | 51113 | 8 | 0 |
69897 | 69897 | 2020-04-18 | Madison | Virginia | 51113 | 8 | 0 |
72667 | 72667 | 2020-04-19 | Madison | Virginia | 51113 | 8 | 0 |
75443 | 75443 | 2020-04-20 | Madison | Virginia | 51113 | 8 | 0 |
78225 | 78225 | 2020-04-21 | Madison | Virginia | 51113 | 12 | 0 |
81018 | 81018 | 2020-04-22 | Madison | Virginia | 51113 | 12 | 0 |
83819 | 83819 | 2020-04-23 | Madison | Virginia | 51113 | 14 | 0 |
86626 | 86626 | 2020-04-24 | Madison | Virginia | 51113 | 14 | 0 |
89441 | 89441 | 2020-04-25 | Madison | Virginia | 51113 | 14 | 0 |
92258 | 92258 | 2020-04-26 | Madison | Virginia | 51113 | 14 | 0 |
95087 | 95087 | 2020-04-27 | Madison | Virginia | 51113 | 14 | 0 |
97930 | 97930 | 2020-04-28 | Madison | Virginia | 51113 | 14 | 0 |
100780 | 100780 | 2020-04-29 | Madison | Virginia | 51113 | 14 | 0 |
103635 | 103635 | 2020-04-30 | Madison | Virginia | 51113 | 14 | 0 |
106499 | 106499 | 2020-05-01 | Madison | Virginia | 51113 | 14 | 0 |
109368 | 109368 | 2020-05-02 | Madison | Virginia | 51113 | 15 | 0 |
112242 | 112242 | 2020-05-03 | Madison | Virginia | 51113 | 15 | 0 |
115125 | 115125 | 2020-05-04 | Madison | Virginia | 51113 | 16 | 1 |
118084 | 118084 | 2020-05-05 | Madison | Virginia | 51113 | 17 | 1 |
121048 | 121048 | 2020-05-06 | Madison | Virginia | 51113 | 17 | 1 |
124029 | 124029 | 2020-05-07 | Madison | Virginia | 51113 | 18 | 1 |
127014 | 127014 | 2020-05-08 | Madison | Virginia | 51113 | 20 | 1 |
130004 | 130004 | 2020-05-09 | Madison | Virginia | 51113 | 20 | 1 |
132994 | 132994 | 2020-05-10 | Madison | Virginia | 51113 | 21 | 1 |
135984 | 135984 | 2020-05-11 | Madison | Virginia | 51113 | 21 | 1 |
138975 | 138975 | 2020-05-12 | Madison | Virginia | 51113 | 21 | 1 |
141971 | 141971 | 2020-05-13 | Madison | Virginia | 51113 | 22 | 1 |
144968 | 144968 | 2020-05-14 | Madison | Virginia | 51113 | 23 | 1 |
147971 | 147971 | 2020-05-15 | Madison | Virginia | 51113 | 23 | 1 |
150980 | 150980 | 2020-05-16 | Madison | Virginia | 51113 | 24 | 1 |
153991 | 153991 | 2020-05-17 | Madison | Virginia | 51113 | 24 | 1 |
157008 | 157008 | 2020-05-18 | Madison | Virginia | 51113 | 24 | 1 |
160032 | 160032 | 2020-05-19 | Madison | Virginia | 51113 | 27 | 1 |
163060 | 163060 | 2020-05-20 | Madison | Virginia | 51113 | 27 | 1 |
166089 | 166089 | 2020-05-21 | Madison | Virginia | 51113 | 27 | 1 |
169125 | 169125 | 2020-05-22 | Madison | Virginia | 51113 | 27 | 1 |
172166 | 172166 | 2020-05-23 | Madison | Virginia | 51113 | 27 | 1 |
175209 | 175209 | 2020-05-24 | Madison | Virginia | 51113 | 32 | 1 |
178254 | 178254 | 2020-05-25 | Madison | Virginia | 51113 | 32 | 1 |
181298 | 181298 | 2020-05-26 | Madison | Virginia | 51113 | 37 | 1 |
184349 | 184349 | 2020-05-27 | Madison | Virginia | 51113 | 38 | 1 |
187406 | 187406 | 2020-05-28 | Madison | Virginia | 51113 | 38 | 1 |
190470 | 190470 | 2020-05-29 | Madison | Virginia | 51113 | 39 | 1 |
193536 | 193536 | 2020-05-30 | Madison | Virginia | 51113 | 40 | 1 |
196606 | 196606 | 2020-05-31 | Madison | Virginia | 51113 | 41 | 1 |
199679 | 199679 | 2020-06-01 | Madison | Virginia | 51113 | 41 | 1 |
202755 | 202755 | 2020-06-02 | Madison | Virginia | 51113 | 41 | 1 |
205834 | 205834 | 2020-06-03 | Madison | Virginia | 51113 | 41 | 1 |
208916 | 208916 | 2020-06-04 | Madison | Virginia | 51113 | 41 | 1 |
212001 | 212001 | 2020-06-05 | Madison | Virginia | 51113 | 41 | 1 |
215088 | 215088 | 2020-06-06 | Madison | Virginia | 51113 | 41 | 1 |
218178 | 218178 | 2020-06-07 | Madison | Virginia | 51113 | 41 | 1 |
221270 | 221270 | 2020-06-08 | Madison | Virginia | 51113 | 41 | 1 |
224366 | 224366 | 2020-06-09 | Madison | Virginia | 51113 | 41 | 1 |
227466 | 227466 | 2020-06-10 | Madison | Virginia | 51113 | 41 | 1 |
230570 | 230570 | 2020-06-11 | Madison | Virginia | 51113 | 41 | 1 |
233675 | 233675 | 2020-06-12 | Madison | Virginia | 51113 | 42 | 1 |
236782 | 236782 | 2020-06-13 | Madison | Virginia | 51113 | 42 | 1 |
239890 | 239890 | 2020-06-14 | Madison | Virginia | 51113 | 42 | 1 |
243001 | 243001 | 2020-06-15 | Madison | Virginia | 51113 | 42 | 1 |
246114 | 246114 | 2020-06-16 | Madison | Virginia | 51113 | 42 | 1 |
249226 | 249226 | 2020-06-17 | Madison | Virginia | 51113 | 42 | 1 |
252341 | 252341 | 2020-06-18 | Madison | Virginia | 51113 | 42 | 1 |
255460 | 255460 | 2020-06-19 | Madison | Virginia | 51113 | 42 | 1 |
258587 | 258587 | 2020-06-20 | Madison | Virginia | 51113 | 42 | 1 |
261714 | 261714 | 2020-06-21 | Madison | Virginia | 51113 | 43 | 1 |
264843 | 264843 | 2020-06-22 | Madison | Virginia | 51113 | 43 | 1 |
267972 | 267972 | 2020-06-23 | Madison | Virginia | 51113 | 43 | 1 |
271106 | 271106 | 2020-06-24 | Madison | Virginia | 51113 | 43 | 1 |
274246 | 274246 | 2020-06-25 | Madison | Virginia | 51113 | 43 | 1 |
277394 | 277394 | 2020-06-26 | Madison | Virginia | 51113 | 43 | 1 |
280542 | 280542 | 2020-06-27 | Madison | Virginia | 51113 | 43 | 1 |
283688 | 283688 | 2020-06-28 | Madison | Virginia | 51113 | 43 | 1 |
286834 | 286834 | 2020-06-29 | Madison | Virginia | 51113 | 43 | 1 |
289984 | 289984 | 2020-06-30 | Madison | Virginia | 51113 | 43 | 1 |
293137 | 293137 | 2020-07-01 | Madison | Virginia | 51113 | 43 | 1 |
296292 | 296292 | 2020-07-02 | Madison | Virginia | 51113 | 43 | 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);