ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
788 rows where county = "Henrico" and state = "Virginia" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
388891 | 388891 | 2020-07-31 | Henrico | Virginia | 51087 | 3541 | 180 |
385674 | 385674 | 2020-07-30 | Henrico | Virginia | 51087 | 3509 | 178 |
382456 | 382456 | 2020-07-29 | Henrico | Virginia | 51087 | 3466 | 177 |
379239 | 379239 | 2020-07-28 | Henrico | Virginia | 51087 | 3436 | 178 |
376023 | 376023 | 2020-07-27 | Henrico | Virginia | 51087 | 3371 | 178 |
372809 | 372809 | 2020-07-26 | Henrico | Virginia | 51087 | 3290 | 178 |
369597 | 369597 | 2020-07-25 | Henrico | Virginia | 51087 | 3261 | 177 |
366388 | 366388 | 2020-07-24 | Henrico | Virginia | 51087 | 3190 | 177 |
363182 | 363182 | 2020-07-23 | Henrico | Virginia | 51087 | 3139 | 177 |
359976 | 359976 | 2020-07-22 | Henrico | Virginia | 51087 | 3112 | 177 |
356771 | 356771 | 2020-07-21 | Henrico | Virginia | 51087 | 3097 | 177 |
353568 | 353568 | 2020-07-20 | Henrico | Virginia | 51087 | 3058 | 175 |
350366 | 350366 | 2020-07-19 | Henrico | Virginia | 51087 | 3037 | 175 |
347165 | 347165 | 2020-07-18 | Henrico | Virginia | 51087 | 3005 | 175 |
343965 | 343965 | 2020-07-17 | Henrico | Virginia | 51087 | 2987 | 175 |
340766 | 340766 | 2020-07-16 | Henrico | Virginia | 51087 | 2964 | 175 |
337570 | 337570 | 2020-07-15 | Henrico | Virginia | 51087 | 2947 | 175 |
334375 | 334375 | 2020-07-14 | Henrico | Virginia | 51087 | 2925 | 173 |
331182 | 331182 | 2020-07-13 | Henrico | Virginia | 51087 | 2891 | 173 |
327996 | 327996 | 2020-07-12 | Henrico | Virginia | 51087 | 2860 | 173 |
324811 | 324811 | 2020-07-11 | Henrico | Virginia | 51087 | 2822 | 173 |
321630 | 321630 | 2020-07-10 | Henrico | Virginia | 51087 | 2784 | 172 |
318451 | 318451 | 2020-07-09 | Henrico | Virginia | 51087 | 2725 | 169 |
315278 | 315278 | 2020-07-08 | Henrico | Virginia | 51087 | 2721 | 165 |
312103 | 312103 | 2020-07-07 | Henrico | Virginia | 51087 | 2708 | 163 |
308934 | 308934 | 2020-07-06 | Henrico | Virginia | 51087 | 2685 | 159 |
305766 | 305766 | 2020-07-05 | Henrico | Virginia | 51087 | 2681 | 158 |
302602 | 302602 | 2020-07-04 | Henrico | Virginia | 51087 | 2663 | 158 |
299438 | 299438 | 2020-07-03 | Henrico | Virginia | 51087 | 2629 | 157 |
296276 | 296276 | 2020-07-02 | Henrico | Virginia | 51087 | 2615 | 152 |
293121 | 293121 | 2020-07-01 | Henrico | Virginia | 51087 | 2603 | 146 |
289968 | 289968 | 2020-06-30 | Henrico | Virginia | 51087 | 2591 | 141 |
286818 | 286818 | 2020-06-29 | Henrico | Virginia | 51087 | 2584 | 141 |
283672 | 283672 | 2020-06-28 | Henrico | Virginia | 51087 | 2579 | 141 |
280526 | 280526 | 2020-06-27 | Henrico | Virginia | 51087 | 2560 | 141 |
277378 | 277378 | 2020-06-26 | Henrico | Virginia | 51087 | 2543 | 141 |
274230 | 274230 | 2020-06-25 | Henrico | Virginia | 51087 | 2500 | 140 |
271090 | 271090 | 2020-06-24 | Henrico | Virginia | 51087 | 2463 | 138 |
267956 | 267956 | 2020-06-23 | Henrico | Virginia | 51087 | 2448 | 138 |
264827 | 264827 | 2020-06-22 | Henrico | Virginia | 51087 | 2426 | 138 |
261698 | 261698 | 2020-06-21 | Henrico | Virginia | 51087 | 2413 | 138 |
258571 | 258571 | 2020-06-20 | Henrico | Virginia | 51087 | 2383 | 138 |
255444 | 255444 | 2020-06-19 | Henrico | Virginia | 51087 | 2368 | 138 |
252325 | 252325 | 2020-06-18 | Henrico | Virginia | 51087 | 2342 | 139 |
249210 | 249210 | 2020-06-17 | Henrico | Virginia | 51087 | 2332 | 140 |
246098 | 246098 | 2020-06-16 | Henrico | Virginia | 51087 | 2311 | 137 |
242985 | 242985 | 2020-06-15 | Henrico | Virginia | 51087 | 2289 | 136 |
239874 | 239874 | 2020-06-14 | Henrico | Virginia | 51087 | 2264 | 136 |
236766 | 236766 | 2020-06-13 | Henrico | Virginia | 51087 | 2234 | 136 |
233659 | 233659 | 2020-06-12 | Henrico | Virginia | 51087 | 2193 | 136 |
230554 | 230554 | 2020-06-11 | Henrico | Virginia | 51087 | 2170 | 135 |
227450 | 227450 | 2020-06-10 | Henrico | Virginia | 51087 | 2162 | 135 |
224350 | 224350 | 2020-06-09 | Henrico | Virginia | 51087 | 2146 | 134 |
221254 | 221254 | 2020-06-08 | Henrico | Virginia | 51087 | 2128 | 134 |
218162 | 218162 | 2020-06-07 | Henrico | Virginia | 51087 | 2096 | 134 |
215072 | 215072 | 2020-06-06 | Henrico | Virginia | 51087 | 2033 | 134 |
211985 | 211985 | 2020-06-05 | Henrico | Virginia | 51087 | 1983 | 134 |
208900 | 208900 | 2020-06-04 | Henrico | Virginia | 51087 | 1946 | 134 |
205818 | 205818 | 2020-06-03 | Henrico | Virginia | 51087 | 1933 | 134 |
202739 | 202739 | 2020-06-02 | Henrico | Virginia | 51087 | 1919 | 135 |
199663 | 199663 | 2020-06-01 | Henrico | Virginia | 51087 | 1858 | 134 |
196590 | 196590 | 2020-05-31 | Henrico | Virginia | 51087 | 1820 | 133 |
193520 | 193520 | 2020-05-30 | Henrico | Virginia | 51087 | 1754 | 133 |
190454 | 190454 | 2020-05-29 | Henrico | Virginia | 51087 | 1678 | 133 |
187390 | 187390 | 2020-05-28 | Henrico | Virginia | 51087 | 1624 | 131 |
184333 | 184333 | 2020-05-27 | Henrico | Virginia | 51087 | 1579 | 119 |
181282 | 181282 | 2020-05-26 | Henrico | Virginia | 51087 | 1546 | 118 |
178238 | 178238 | 2020-05-25 | Henrico | Virginia | 51087 | 1492 | 118 |
175193 | 175193 | 2020-05-24 | Henrico | Virginia | 51087 | 1446 | 118 |
172150 | 172150 | 2020-05-23 | Henrico | Virginia | 51087 | 1411 | 118 |
169109 | 169109 | 2020-05-22 | Henrico | Virginia | 51087 | 1375 | 117 |
166073 | 166073 | 2020-05-21 | Henrico | Virginia | 51087 | 1339 | 114 |
163044 | 163044 | 2020-05-20 | Henrico | Virginia | 51087 | 1321 | 114 |
160016 | 160016 | 2020-05-19 | Henrico | Virginia | 51087 | 1299 | 114 |
156992 | 156992 | 2020-05-18 | Henrico | Virginia | 51087 | 1272 | 113 |
153975 | 153975 | 2020-05-17 | Henrico | Virginia | 51087 | 1252 | 113 |
150964 | 150964 | 2020-05-16 | Henrico | Virginia | 51087 | 1226 | 113 |
147955 | 147955 | 2020-05-15 | Henrico | Virginia | 51087 | 1198 | 113 |
144952 | 144952 | 2020-05-14 | Henrico | Virginia | 51087 | 1174 | 112 |
141955 | 141955 | 2020-05-13 | Henrico | Virginia | 51087 | 1146 | 112 |
138959 | 138959 | 2020-05-12 | Henrico | Virginia | 51087 | 1106 | 112 |
135968 | 135968 | 2020-05-11 | Henrico | Virginia | 51087 | 1083 | 110 |
132978 | 132978 | 2020-05-10 | Henrico | Virginia | 51087 | 1067 | 109 |
129988 | 129988 | 2020-05-09 | Henrico | Virginia | 51087 | 1054 | 109 |
126998 | 126998 | 2020-05-08 | Henrico | Virginia | 51087 | 1032 | 110 |
124013 | 124013 | 2020-05-07 | Henrico | Virginia | 51087 | 1025 | 109 |
121032 | 121032 | 2020-05-06 | Henrico | Virginia | 51087 | 985 | 106 |
118068 | 118068 | 2020-05-05 | Henrico | Virginia | 51087 | 985 | 106 |
115109 | 115109 | 2020-05-04 | Henrico | Virginia | 51087 | 964 | 105 |
112226 | 112226 | 2020-05-03 | Henrico | Virginia | 51087 | 954 | 105 |
109352 | 109352 | 2020-05-02 | Henrico | Virginia | 51087 | 926 | 104 |
106483 | 106483 | 2020-05-01 | Henrico | Virginia | 51087 | 898 | 102 |
103619 | 103619 | 2020-04-30 | Henrico | Virginia | 51087 | 876 | 100 |
100764 | 100764 | 2020-04-29 | Henrico | Virginia | 51087 | 846 | 98 |
97914 | 97914 | 2020-04-28 | Henrico | Virginia | 51087 | 835 | 95 |
95071 | 95071 | 2020-04-27 | Henrico | Virginia | 51087 | 817 | 89 |
92242 | 92242 | 2020-04-26 | Henrico | Virginia | 51087 | 792 | 89 |
89425 | 89425 | 2020-04-25 | Henrico | Virginia | 51087 | 764 | 89 |
86610 | 86610 | 2020-04-24 | Henrico | Virginia | 51087 | 729 | 86 |
83803 | 83803 | 2020-04-23 | Henrico | Virginia | 51087 | 718 | 83 |
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);