ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
791 rows where fips = 51041 and state = "Virginia" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
388858 | 388858 | 2020-07-31 | Chesterfield | Virginia | 51041 | 3937 | 72 |
385641 | 385641 | 2020-07-30 | Chesterfield | Virginia | 51041 | 3877 | 71 |
382423 | 382423 | 2020-07-29 | Chesterfield | Virginia | 51041 | 3829 | 69 |
379206 | 379206 | 2020-07-28 | Chesterfield | Virginia | 51041 | 3796 | 66 |
375990 | 375990 | 2020-07-27 | Chesterfield | Virginia | 51041 | 3766 | 66 |
372776 | 372776 | 2020-07-26 | Chesterfield | Virginia | 51041 | 3730 | 66 |
369564 | 369564 | 2020-07-25 | Chesterfield | Virginia | 51041 | 3702 | 66 |
366355 | 366355 | 2020-07-24 | Chesterfield | Virginia | 51041 | 3673 | 66 |
363149 | 363149 | 2020-07-23 | Chesterfield | Virginia | 51041 | 3609 | 65 |
359943 | 359943 | 2020-07-22 | Chesterfield | Virginia | 51041 | 3564 | 65 |
356738 | 356738 | 2020-07-21 | Chesterfield | Virginia | 51041 | 3538 | 65 |
353535 | 353535 | 2020-07-20 | Chesterfield | Virginia | 51041 | 3472 | 65 |
350333 | 350333 | 2020-07-19 | Chesterfield | Virginia | 51041 | 3447 | 65 |
347132 | 347132 | 2020-07-18 | Chesterfield | Virginia | 51041 | 3427 | 65 |
343932 | 343932 | 2020-07-17 | Chesterfield | Virginia | 51041 | 3402 | 64 |
340733 | 340733 | 2020-07-16 | Chesterfield | Virginia | 51041 | 3359 | 64 |
337537 | 337537 | 2020-07-15 | Chesterfield | Virginia | 51041 | 3324 | 63 |
334342 | 334342 | 2020-07-14 | Chesterfield | Virginia | 51041 | 3278 | 63 |
331149 | 331149 | 2020-07-13 | Chesterfield | Virginia | 51041 | 3216 | 62 |
327963 | 327963 | 2020-07-12 | Chesterfield | Virginia | 51041 | 3189 | 62 |
324778 | 324778 | 2020-07-11 | Chesterfield | Virginia | 51041 | 3169 | 62 |
321597 | 321597 | 2020-07-10 | Chesterfield | Virginia | 51041 | 3135 | 62 |
318418 | 318418 | 2020-07-09 | Chesterfield | Virginia | 51041 | 3108 | 61 |
315245 | 315245 | 2020-07-08 | Chesterfield | Virginia | 51041 | 3078 | 59 |
312070 | 312070 | 2020-07-07 | Chesterfield | Virginia | 51041 | 3059 | 56 |
308901 | 308901 | 2020-07-06 | Chesterfield | Virginia | 51041 | 3026 | 53 |
305733 | 305733 | 2020-07-05 | Chesterfield | Virginia | 51041 | 3015 | 53 |
302569 | 302569 | 2020-07-04 | Chesterfield | Virginia | 51041 | 2972 | 53 |
299405 | 299405 | 2020-07-03 | Chesterfield | Virginia | 51041 | 2974 | 53 |
296243 | 296243 | 2020-07-02 | Chesterfield | Virginia | 51041 | 2939 | 53 |
293088 | 293088 | 2020-07-01 | Chesterfield | Virginia | 51041 | 2914 | 53 |
289935 | 289935 | 2020-06-30 | Chesterfield | Virginia | 51041 | 2897 | 50 |
286785 | 286785 | 2020-06-29 | Chesterfield | Virginia | 51041 | 2869 | 49 |
283639 | 283639 | 2020-06-28 | Chesterfield | Virginia | 51041 | 2856 | 49 |
280493 | 280493 | 2020-06-27 | Chesterfield | Virginia | 51041 | 2842 | 49 |
277345 | 277345 | 2020-06-26 | Chesterfield | Virginia | 51041 | 2784 | 49 |
274197 | 274197 | 2020-06-25 | Chesterfield | Virginia | 51041 | 2735 | 49 |
271057 | 271057 | 2020-06-24 | Chesterfield | Virginia | 51041 | 2710 | 49 |
267923 | 267923 | 2020-06-23 | Chesterfield | Virginia | 51041 | 2651 | 49 |
264794 | 264794 | 2020-06-22 | Chesterfield | Virginia | 51041 | 2577 | 46 |
261665 | 261665 | 2020-06-21 | Chesterfield | Virginia | 51041 | 2557 | 46 |
258538 | 258538 | 2020-06-20 | Chesterfield | Virginia | 51041 | 2541 | 46 |
255411 | 255411 | 2020-06-19 | Chesterfield | Virginia | 51041 | 2456 | 46 |
252292 | 252292 | 2020-06-18 | Chesterfield | Virginia | 51041 | 2375 | 40 |
249177 | 249177 | 2020-06-17 | Chesterfield | Virginia | 51041 | 2316 | 40 |
246065 | 246065 | 2020-06-16 | Chesterfield | Virginia | 51041 | 2259 | 39 |
242953 | 242953 | 2020-06-15 | Chesterfield | Virginia | 51041 | 2194 | 39 |
239842 | 239842 | 2020-06-14 | Chesterfield | Virginia | 51041 | 2181 | 39 |
236734 | 236734 | 2020-06-13 | Chesterfield | Virginia | 51041 | 2150 | 39 |
233627 | 233627 | 2020-06-12 | Chesterfield | Virginia | 51041 | 2109 | 38 |
230522 | 230522 | 2020-06-11 | Chesterfield | Virginia | 51041 | 2041 | 38 |
227418 | 227418 | 2020-06-10 | Chesterfield | Virginia | 51041 | 1995 | 38 |
224318 | 224318 | 2020-06-09 | Chesterfield | Virginia | 51041 | 1942 | 37 |
221222 | 221222 | 2020-06-08 | Chesterfield | Virginia | 51041 | 1866 | 37 |
218130 | 218130 | 2020-06-07 | Chesterfield | Virginia | 51041 | 1831 | 37 |
215040 | 215040 | 2020-06-06 | Chesterfield | Virginia | 51041 | 1797 | 37 |
211953 | 211953 | 2020-06-05 | Chesterfield | Virginia | 51041 | 1761 | 37 |
208868 | 208868 | 2020-06-04 | Chesterfield | Virginia | 51041 | 1721 | 37 |
205786 | 205786 | 2020-06-03 | Chesterfield | Virginia | 51041 | 1661 | 37 |
202707 | 202707 | 2020-06-02 | Chesterfield | Virginia | 51041 | 1627 | 37 |
199631 | 199631 | 2020-06-01 | Chesterfield | Virginia | 51041 | 1568 | 35 |
196558 | 196558 | 2020-05-31 | Chesterfield | Virginia | 51041 | 1548 | 35 |
193488 | 193488 | 2020-05-30 | Chesterfield | Virginia | 51041 | 1461 | 35 |
190422 | 190422 | 2020-05-29 | Chesterfield | Virginia | 51041 | 1400 | 35 |
187358 | 187358 | 2020-05-28 | Chesterfield | Virginia | 51041 | 1331 | 36 |
184301 | 184301 | 2020-05-27 | Chesterfield | Virginia | 51041 | 1263 | 32 |
181250 | 181250 | 2020-05-26 | Chesterfield | Virginia | 51041 | 1213 | 32 |
178206 | 178206 | 2020-05-25 | Chesterfield | Virginia | 51041 | 1200 | 30 |
175161 | 175161 | 2020-05-24 | Chesterfield | Virginia | 51041 | 1193 | 29 |
172118 | 172118 | 2020-05-23 | Chesterfield | Virginia | 51041 | 1193 | 29 |
169077 | 169077 | 2020-05-22 | Chesterfield | Virginia | 51041 | 1152 | 29 |
166041 | 166041 | 2020-05-21 | Chesterfield | Virginia | 51041 | 1132 | 29 |
163012 | 163012 | 2020-05-20 | Chesterfield | Virginia | 51041 | 1100 | 29 |
159984 | 159984 | 2020-05-19 | Chesterfield | Virginia | 51041 | 1043 | 29 |
156960 | 156960 | 2020-05-18 | Chesterfield | Virginia | 51041 | 1002 | 29 |
153943 | 153943 | 2020-05-17 | Chesterfield | Virginia | 51041 | 988 | 29 |
150932 | 150932 | 2020-05-16 | Chesterfield | Virginia | 51041 | 978 | 29 |
147923 | 147923 | 2020-05-15 | Chesterfield | Virginia | 51041 | 946 | 29 |
144920 | 144920 | 2020-05-14 | Chesterfield | Virginia | 51041 | 909 | 29 |
141923 | 141923 | 2020-05-13 | Chesterfield | Virginia | 51041 | 862 | 29 |
138927 | 138927 | 2020-05-12 | Chesterfield | Virginia | 51041 | 837 | 28 |
135936 | 135936 | 2020-05-11 | Chesterfield | Virginia | 51041 | 789 | 26 |
132946 | 132946 | 2020-05-10 | Chesterfield | Virginia | 51041 | 787 | 26 |
129956 | 129956 | 2020-05-09 | Chesterfield | Virginia | 51041 | 765 | 26 |
126967 | 126967 | 2020-05-08 | Chesterfield | Virginia | 51041 | 741 | 26 |
123982 | 123982 | 2020-05-07 | Chesterfield | Virginia | 51041 | 707 | 26 |
121001 | 121001 | 2020-05-06 | Chesterfield | Virginia | 51041 | 646 | 25 |
118037 | 118037 | 2020-05-05 | Chesterfield | Virginia | 51041 | 646 | 25 |
115078 | 115078 | 2020-05-04 | Chesterfield | Virginia | 51041 | 601 | 24 |
112195 | 112195 | 2020-05-03 | Chesterfield | Virginia | 51041 | 601 | 24 |
109321 | 109321 | 2020-05-02 | Chesterfield | Virginia | 51041 | 593 | 24 |
106452 | 106452 | 2020-05-01 | Chesterfield | Virginia | 51041 | 557 | 24 |
103588 | 103588 | 2020-04-30 | Chesterfield | Virginia | 51041 | 531 | 20 |
100733 | 100733 | 2020-04-29 | Chesterfield | Virginia | 51041 | 501 | 19 |
97883 | 97883 | 2020-04-28 | Chesterfield | Virginia | 51041 | 488 | 19 |
95041 | 95041 | 2020-04-27 | Chesterfield | Virginia | 51041 | 457 | 18 |
92212 | 92212 | 2020-04-26 | Chesterfield | Virginia | 51041 | 457 | 18 |
89395 | 89395 | 2020-04-25 | Chesterfield | Virginia | 51041 | 440 | 18 |
86580 | 86580 | 2020-04-24 | Chesterfield | Virginia | 51041 | 423 | 17 |
83773 | 83773 | 2020-04-23 | Chesterfield | Virginia | 51041 | 402 | 7 |
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);