ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
788 rows where fips = 51075 sorted by state descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid | date | county | state ▲ | fips | cases | deaths |
---|---|---|---|---|---|---|---|
3709 | 3709 | 2020-03-17 | Goochland | Virginia | 51075 | 1 | 0 |
4342 | 4342 | 2020-03-18 | Goochland | Virginia | 51075 | 1 | 0 |
5098 | 5098 | 2020-03-19 | Goochland | Virginia | 51075 | 1 | 0 |
5996 | 5996 | 2020-03-20 | Goochland | Virginia | 51075 | 1 | 0 |
7024 | 7024 | 2020-03-21 | Goochland | Virginia | 51075 | 1 | 0 |
8158 | 8158 | 2020-03-22 | Goochland | Virginia | 51075 | 2 | 0 |
9380 | 9380 | 2020-03-23 | Goochland | Virginia | 51075 | 2 | 0 |
10727 | 10727 | 2020-03-24 | Goochland | Virginia | 51075 | 3 | 0 |
12241 | 12241 | 2020-03-25 | Goochland | Virginia | 51075 | 3 | 0 |
13879 | 13879 | 2020-03-26 | Goochland | Virginia | 51075 | 3 | 0 |
15647 | 15647 | 2020-03-27 | Goochland | Virginia | 51075 | 3 | 0 |
17521 | 17521 | 2020-03-28 | Goochland | Virginia | 51075 | 5 | 0 |
19481 | 19481 | 2020-03-29 | Goochland | Virginia | 51075 | 6 | 0 |
21544 | 21544 | 2020-03-30 | Goochland | Virginia | 51075 | 6 | 0 |
23689 | 23689 | 2020-03-31 | Goochland | Virginia | 51075 | 7 | 0 |
25905 | 25905 | 2020-04-01 | Goochland | Virginia | 51075 | 7 | 0 |
28195 | 28195 | 2020-04-02 | Goochland | Virginia | 51075 | 9 | 0 |
30541 | 30541 | 2020-04-03 | Goochland | Virginia | 51075 | 8 | 0 |
32940 | 32940 | 2020-04-04 | Goochland | Virginia | 51075 | 10 | 0 |
35378 | 35378 | 2020-04-05 | Goochland | Virginia | 51075 | 15 | 0 |
37861 | 37861 | 2020-04-06 | Goochland | Virginia | 51075 | 17 | 0 |
40394 | 40394 | 2020-04-07 | Goochland | Virginia | 51075 | 22 | 0 |
42963 | 42963 | 2020-04-08 | Goochland | Virginia | 51075 | 24 | 0 |
45558 | 45558 | 2020-04-09 | Goochland | Virginia | 51075 | 24 | 0 |
48184 | 48184 | 2020-04-10 | Goochland | Virginia | 51075 | 26 | 0 |
50842 | 50842 | 2020-04-11 | Goochland | Virginia | 51075 | 26 | 0 |
53517 | 53517 | 2020-04-12 | Goochland | Virginia | 51075 | 32 | 0 |
56207 | 56207 | 2020-04-13 | Goochland | Virginia | 51075 | 38 | 0 |
58913 | 58913 | 2020-04-14 | Goochland | Virginia | 51075 | 39 | 1 |
61632 | 61632 | 2020-04-15 | Goochland | Virginia | 51075 | 40 | 1 |
64365 | 64365 | 2020-04-16 | Goochland | Virginia | 51075 | 41 | 1 |
67113 | 67113 | 2020-04-17 | Goochland | Virginia | 51075 | 52 | 1 |
69875 | 69875 | 2020-04-18 | Goochland | Virginia | 51075 | 55 | 1 |
72645 | 72645 | 2020-04-19 | Goochland | Virginia | 51075 | 55 | 1 |
75421 | 75421 | 2020-04-20 | Goochland | Virginia | 51075 | 58 | 1 |
78203 | 78203 | 2020-04-21 | Goochland | Virginia | 51075 | 62 | 3 |
80995 | 80995 | 2020-04-22 | Goochland | Virginia | 51075 | 63 | 3 |
83796 | 83796 | 2020-04-23 | Goochland | Virginia | 51075 | 63 | 3 |
86603 | 86603 | 2020-04-24 | Goochland | Virginia | 51075 | 69 | 3 |
89418 | 89418 | 2020-04-25 | Goochland | Virginia | 51075 | 69 | 3 |
92235 | 92235 | 2020-04-26 | Goochland | Virginia | 51075 | 70 | 3 |
95064 | 95064 | 2020-04-27 | Goochland | Virginia | 51075 | 72 | 3 |
97906 | 97906 | 2020-04-28 | Goochland | Virginia | 51075 | 74 | 3 |
100756 | 100756 | 2020-04-29 | Goochland | Virginia | 51075 | 74 | 4 |
103611 | 103611 | 2020-04-30 | Goochland | Virginia | 51075 | 76 | 4 |
106475 | 106475 | 2020-05-01 | Goochland | Virginia | 51075 | 78 | 4 |
109344 | 109344 | 2020-05-02 | Goochland | Virginia | 51075 | 78 | 4 |
112218 | 112218 | 2020-05-03 | Goochland | Virginia | 51075 | 79 | 5 |
115101 | 115101 | 2020-05-04 | Goochland | Virginia | 51075 | 80 | 5 |
118060 | 118060 | 2020-05-05 | Goochland | Virginia | 51075 | 80 | 5 |
121024 | 121024 | 2020-05-06 | Goochland | Virginia | 51075 | 80 | 5 |
124005 | 124005 | 2020-05-07 | Goochland | Virginia | 51075 | 81 | 5 |
126990 | 126990 | 2020-05-08 | Goochland | Virginia | 51075 | 81 | 5 |
129980 | 129980 | 2020-05-09 | Goochland | Virginia | 51075 | 81 | 5 |
132970 | 132970 | 2020-05-10 | Goochland | Virginia | 51075 | 81 | 5 |
135960 | 135960 | 2020-05-11 | Goochland | Virginia | 51075 | 81 | 5 |
138951 | 138951 | 2020-05-12 | Goochland | Virginia | 51075 | 82 | 5 |
141947 | 141947 | 2020-05-13 | Goochland | Virginia | 51075 | 82 | 5 |
144944 | 144944 | 2020-05-14 | Goochland | Virginia | 51075 | 86 | 5 |
147947 | 147947 | 2020-05-15 | Goochland | Virginia | 51075 | 86 | 5 |
150956 | 150956 | 2020-05-16 | Goochland | Virginia | 51075 | 87 | 5 |
153967 | 153967 | 2020-05-17 | Goochland | Virginia | 51075 | 87 | 5 |
156984 | 156984 | 2020-05-18 | Goochland | Virginia | 51075 | 88 | 5 |
160008 | 160008 | 2020-05-19 | Goochland | Virginia | 51075 | 88 | 5 |
163036 | 163036 | 2020-05-20 | Goochland | Virginia | 51075 | 88 | 5 |
166065 | 166065 | 2020-05-21 | Goochland | Virginia | 51075 | 89 | 5 |
169101 | 169101 | 2020-05-22 | Goochland | Virginia | 51075 | 89 | 5 |
172142 | 172142 | 2020-05-23 | Goochland | Virginia | 51075 | 90 | 5 |
175185 | 175185 | 2020-05-24 | Goochland | Virginia | 51075 | 90 | 5 |
178230 | 178230 | 2020-05-25 | Goochland | Virginia | 51075 | 93 | 6 |
181274 | 181274 | 2020-05-26 | Goochland | Virginia | 51075 | 93 | 6 |
184325 | 184325 | 2020-05-27 | Goochland | Virginia | 51075 | 94 | 6 |
187382 | 187382 | 2020-05-28 | Goochland | Virginia | 51075 | 93 | 6 |
190446 | 190446 | 2020-05-29 | Goochland | Virginia | 51075 | 95 | 6 |
193512 | 193512 | 2020-05-30 | Goochland | Virginia | 51075 | 96 | 6 |
196582 | 196582 | 2020-05-31 | Goochland | Virginia | 51075 | 99 | 6 |
199655 | 199655 | 2020-06-01 | Goochland | Virginia | 51075 | 99 | 6 |
202731 | 202731 | 2020-06-02 | Goochland | Virginia | 51075 | 101 | 6 |
205810 | 205810 | 2020-06-03 | Goochland | Virginia | 51075 | 103 | 6 |
208892 | 208892 | 2020-06-04 | Goochland | Virginia | 51075 | 103 | 6 |
211977 | 211977 | 2020-06-05 | Goochland | Virginia | 51075 | 105 | 6 |
215064 | 215064 | 2020-06-06 | Goochland | Virginia | 51075 | 105 | 6 |
218154 | 218154 | 2020-06-07 | Goochland | Virginia | 51075 | 107 | 6 |
221246 | 221246 | 2020-06-08 | Goochland | Virginia | 51075 | 107 | 6 |
224342 | 224342 | 2020-06-09 | Goochland | Virginia | 51075 | 108 | 6 |
227442 | 227442 | 2020-06-10 | Goochland | Virginia | 51075 | 106 | 6 |
230546 | 230546 | 2020-06-11 | Goochland | Virginia | 51075 | 109 | 6 |
233651 | 233651 | 2020-06-12 | Goochland | Virginia | 51075 | 112 | 6 |
236758 | 236758 | 2020-06-13 | Goochland | Virginia | 51075 | 114 | 6 |
239866 | 239866 | 2020-06-14 | Goochland | Virginia | 51075 | 114 | 6 |
242977 | 242977 | 2020-06-15 | Goochland | Virginia | 51075 | 116 | 6 |
246090 | 246090 | 2020-06-16 | Goochland | Virginia | 51075 | 116 | 6 |
249202 | 249202 | 2020-06-17 | Goochland | Virginia | 51075 | 116 | 6 |
252317 | 252317 | 2020-06-18 | Goochland | Virginia | 51075 | 116 | 6 |
255436 | 255436 | 2020-06-19 | Goochland | Virginia | 51075 | 115 | 6 |
258563 | 258563 | 2020-06-20 | Goochland | Virginia | 51075 | 115 | 6 |
261690 | 261690 | 2020-06-21 | Goochland | Virginia | 51075 | 115 | 6 |
264819 | 264819 | 2020-06-22 | Goochland | Virginia | 51075 | 116 | 6 |
267948 | 267948 | 2020-06-23 | Goochland | Virginia | 51075 | 118 | 6 |
271082 | 271082 | 2020-06-24 | Goochland | Virginia | 51075 | 118 | 6 |
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);