ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
793 rows where fips = 51095 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 |
---|---|---|---|---|---|---|---|
1593 | 1593 | 2020-03-12 | James City | Virginia | 51095 | 3 | 0 |
1903 | 1903 | 2020-03-13 | James City | Virginia | 51095 | 8 | 0 |
2275 | 2275 | 2020-03-14 | James City | Virginia | 51095 | 9 | 1 |
2702 | 2702 | 2020-03-15 | James City | Virginia | 51095 | 9 | 1 |
3174 | 3174 | 2020-03-16 | James City | Virginia | 51095 | 10 | 1 |
3713 | 3713 | 2020-03-17 | James City | Virginia | 51095 | 12 | 2 |
4346 | 4346 | 2020-03-18 | James City | Virginia | 51095 | 13 | 2 |
5102 | 5102 | 2020-03-19 | James City | Virginia | 51095 | 14 | 2 |
6000 | 6000 | 2020-03-20 | James City | Virginia | 51095 | 19 | 2 |
7029 | 7029 | 2020-03-21 | James City | Virginia | 51095 | 20 | 2 |
8163 | 8163 | 2020-03-22 | James City | Virginia | 51095 | 32 | 3 |
9385 | 9385 | 2020-03-23 | James City | Virginia | 51095 | 34 | 3 |
10733 | 10733 | 2020-03-24 | James City | Virginia | 51095 | 37 | 3 |
12247 | 12247 | 2020-03-25 | James City | Virginia | 51095 | 41 | 3 |
13887 | 13887 | 2020-03-26 | James City | Virginia | 51095 | 49 | 3 |
15655 | 15655 | 2020-03-27 | James City | Virginia | 51095 | 55 | 3 |
17530 | 17530 | 2020-03-28 | James City | Virginia | 51095 | 65 | 3 |
19491 | 19491 | 2020-03-29 | James City | Virginia | 51095 | 70 | 3 |
21555 | 21555 | 2020-03-30 | James City | Virginia | 51095 | 73 | 3 |
23700 | 23700 | 2020-03-31 | James City | Virginia | 51095 | 89 | 3 |
25916 | 25916 | 2020-04-01 | James City | Virginia | 51095 | 95 | 3 |
28206 | 28206 | 2020-04-02 | James City | Virginia | 51095 | 97 | 3 |
30552 | 30552 | 2020-04-03 | James City | Virginia | 51095 | 104 | 3 |
32951 | 32951 | 2020-04-04 | James City | Virginia | 51095 | 111 | 3 |
35389 | 35389 | 2020-04-05 | James City | Virginia | 51095 | 117 | 3 |
37872 | 37872 | 2020-04-06 | James City | Virginia | 51095 | 118 | 3 |
40405 | 40405 | 2020-04-07 | James City | Virginia | 51095 | 119 | 3 |
42974 | 42974 | 2020-04-08 | James City | Virginia | 51095 | 122 | 3 |
45569 | 45569 | 2020-04-09 | James City | Virginia | 51095 | 123 | 3 |
48195 | 48195 | 2020-04-10 | James City | Virginia | 51095 | 125 | 3 |
50853 | 50853 | 2020-04-11 | James City | Virginia | 51095 | 126 | 3 |
53528 | 53528 | 2020-04-12 | James City | Virginia | 51095 | 126 | 3 |
56218 | 56218 | 2020-04-13 | James City | Virginia | 51095 | 126 | 3 |
58924 | 58924 | 2020-04-14 | James City | Virginia | 51095 | 128 | 3 |
61643 | 61643 | 2020-04-15 | James City | Virginia | 51095 | 132 | 3 |
64376 | 64376 | 2020-04-16 | James City | Virginia | 51095 | 135 | 3 |
67124 | 67124 | 2020-04-17 | James City | Virginia | 51095 | 138 | 3 |
69886 | 69886 | 2020-04-18 | James City | Virginia | 51095 | 139 | 3 |
72656 | 72656 | 2020-04-19 | James City | Virginia | 51095 | 141 | 3 |
75432 | 75432 | 2020-04-20 | James City | Virginia | 51095 | 141 | 3 |
78214 | 78214 | 2020-04-21 | James City | Virginia | 51095 | 146 | 12 |
81007 | 81007 | 2020-04-22 | James City | Virginia | 51095 | 147 | 12 |
83808 | 83808 | 2020-04-23 | James City | Virginia | 51095 | 149 | 12 |
86615 | 86615 | 2020-04-24 | James City | Virginia | 51095 | 150 | 12 |
89430 | 89430 | 2020-04-25 | James City | Virginia | 51095 | 151 | 12 |
92247 | 92247 | 2020-04-26 | James City | Virginia | 51095 | 153 | 12 |
95076 | 95076 | 2020-04-27 | James City | Virginia | 51095 | 154 | 12 |
97919 | 97919 | 2020-04-28 | James City | Virginia | 51095 | 155 | 12 |
100769 | 100769 | 2020-04-29 | James City | Virginia | 51095 | 155 | 12 |
103624 | 103624 | 2020-04-30 | James City | Virginia | 51095 | 158 | 12 |
106488 | 106488 | 2020-05-01 | James City | Virginia | 51095 | 160 | 12 |
109357 | 109357 | 2020-05-02 | James City | Virginia | 51095 | 161 | 13 |
112231 | 112231 | 2020-05-03 | James City | Virginia | 51095 | 163 | 13 |
115114 | 115114 | 2020-05-04 | James City | Virginia | 51095 | 167 | 13 |
118073 | 118073 | 2020-05-05 | James City | Virginia | 51095 | 166 | 14 |
121037 | 121037 | 2020-05-06 | James City | Virginia | 51095 | 166 | 14 |
124018 | 124018 | 2020-05-07 | James City | Virginia | 51095 | 167 | 15 |
127003 | 127003 | 2020-05-08 | James City | Virginia | 51095 | 170 | 15 |
129993 | 129993 | 2020-05-09 | James City | Virginia | 51095 | 169 | 15 |
132983 | 132983 | 2020-05-10 | James City | Virginia | 51095 | 173 | 15 |
135973 | 135973 | 2020-05-11 | James City | Virginia | 51095 | 173 | 15 |
138964 | 138964 | 2020-05-12 | James City | Virginia | 51095 | 174 | 15 |
141960 | 141960 | 2020-05-13 | James City | Virginia | 51095 | 174 | 15 |
144957 | 144957 | 2020-05-14 | James City | Virginia | 51095 | 174 | 15 |
147960 | 147960 | 2020-05-15 | James City | Virginia | 51095 | 179 | 15 |
150969 | 150969 | 2020-05-16 | James City | Virginia | 51095 | 179 | 15 |
153980 | 153980 | 2020-05-17 | James City | Virginia | 51095 | 186 | 15 |
156997 | 156997 | 2020-05-18 | James City | Virginia | 51095 | 187 | 15 |
160021 | 160021 | 2020-05-19 | James City | Virginia | 51095 | 189 | 15 |
163049 | 163049 | 2020-05-20 | James City | Virginia | 51095 | 189 | 15 |
166078 | 166078 | 2020-05-21 | James City | Virginia | 51095 | 189 | 15 |
169114 | 169114 | 2020-05-22 | James City | Virginia | 51095 | 191 | 16 |
172155 | 172155 | 2020-05-23 | James City | Virginia | 51095 | 192 | 16 |
175198 | 175198 | 2020-05-24 | James City | Virginia | 51095 | 196 | 16 |
178243 | 178243 | 2020-05-25 | James City | Virginia | 51095 | 197 | 16 |
181287 | 181287 | 2020-05-26 | James City | Virginia | 51095 | 200 | 16 |
184338 | 184338 | 2020-05-27 | James City | Virginia | 51095 | 200 | 16 |
187395 | 187395 | 2020-05-28 | James City | Virginia | 51095 | 202 | 15 |
190459 | 190459 | 2020-05-29 | James City | Virginia | 51095 | 202 | 15 |
193525 | 193525 | 2020-05-30 | James City | Virginia | 51095 | 202 | 15 |
196595 | 196595 | 2020-05-31 | James City | Virginia | 51095 | 205 | 15 |
199668 | 199668 | 2020-06-01 | James City | Virginia | 51095 | 206 | 15 |
202744 | 202744 | 2020-06-02 | James City | Virginia | 51095 | 210 | 15 |
205823 | 205823 | 2020-06-03 | James City | Virginia | 51095 | 211 | 15 |
208905 | 208905 | 2020-06-04 | James City | Virginia | 51095 | 211 | 15 |
211990 | 211990 | 2020-06-05 | James City | Virginia | 51095 | 211 | 15 |
215077 | 215077 | 2020-06-06 | James City | Virginia | 51095 | 211 | 15 |
218167 | 218167 | 2020-06-07 | James City | Virginia | 51095 | 216 | 15 |
221259 | 221259 | 2020-06-08 | James City | Virginia | 51095 | 217 | 15 |
224355 | 224355 | 2020-06-09 | James City | Virginia | 51095 | 224 | 15 |
227455 | 227455 | 2020-06-10 | James City | Virginia | 51095 | 224 | 15 |
230559 | 230559 | 2020-06-11 | James City | Virginia | 51095 | 225 | 15 |
233664 | 233664 | 2020-06-12 | James City | Virginia | 51095 | 230 | 15 |
236771 | 236771 | 2020-06-13 | James City | Virginia | 51095 | 231 | 15 |
239879 | 239879 | 2020-06-14 | James City | Virginia | 51095 | 233 | 15 |
242990 | 242990 | 2020-06-15 | James City | Virginia | 51095 | 233 | 15 |
246103 | 246103 | 2020-06-16 | James City | Virginia | 51095 | 236 | 15 |
249215 | 249215 | 2020-06-17 | James City | Virginia | 51095 | 236 | 15 |
252330 | 252330 | 2020-06-18 | James City | Virginia | 51095 | 237 | 15 |
255449 | 255449 | 2020-06-19 | James City | Virginia | 51095 | 238 | 15 |
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);