ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
791 rows where county = "Chesterfield" and state = "Virginia" sorted by county
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
Link | rowid | date | county ▼ | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2271 | 2271 | 2020-03-14 | Chesterfield | Virginia | 51041 | 1 | 0 |
2698 | 2698 | 2020-03-15 | Chesterfield | Virginia | 51041 | 1 | 0 |
3170 | 3170 | 2020-03-16 | Chesterfield | Virginia | 51041 | 2 | 0 |
3707 | 3707 | 2020-03-17 | Chesterfield | Virginia | 51041 | 4 | 0 |
4340 | 4340 | 2020-03-18 | Chesterfield | Virginia | 51041 | 5 | 0 |
5096 | 5096 | 2020-03-19 | Chesterfield | Virginia | 51041 | 6 | 0 |
5993 | 5993 | 2020-03-20 | Chesterfield | Virginia | 51041 | 6 | 0 |
7020 | 7020 | 2020-03-21 | Chesterfield | Virginia | 51041 | 7 | 0 |
8152 | 8152 | 2020-03-22 | Chesterfield | Virginia | 51041 | 8 | 0 |
9373 | 9373 | 2020-03-23 | Chesterfield | Virginia | 51041 | 9 | 0 |
10720 | 10720 | 2020-03-24 | Chesterfield | Virginia | 51041 | 10 | 0 |
12232 | 12232 | 2020-03-25 | Chesterfield | Virginia | 51041 | 11 | 0 |
13869 | 13869 | 2020-03-26 | Chesterfield | Virginia | 51041 | 12 | 0 |
15636 | 15636 | 2020-03-27 | Chesterfield | Virginia | 51041 | 12 | 0 |
17510 | 17510 | 2020-03-28 | Chesterfield | Virginia | 51041 | 12 | 0 |
19470 | 19470 | 2020-03-29 | Chesterfield | Virginia | 51041 | 13 | 0 |
21533 | 21533 | 2020-03-30 | Chesterfield | Virginia | 51041 | 21 | 0 |
23676 | 23676 | 2020-03-31 | Chesterfield | Virginia | 51041 | 43 | 0 |
25892 | 25892 | 2020-04-01 | Chesterfield | Virginia | 51041 | 59 | 0 |
28181 | 28181 | 2020-04-02 | Chesterfield | Virginia | 51041 | 73 | 0 |
30526 | 30526 | 2020-04-03 | Chesterfield | Virginia | 51041 | 89 | 0 |
32925 | 32925 | 2020-04-04 | Chesterfield | Virginia | 51041 | 106 | 0 |
35363 | 35363 | 2020-04-05 | Chesterfield | Virginia | 51041 | 108 | 0 |
37845 | 37845 | 2020-04-06 | Chesterfield | Virginia | 51041 | 108 | 0 |
40376 | 40376 | 2020-04-07 | Chesterfield | Virginia | 51041 | 128 | 0 |
42945 | 42945 | 2020-04-08 | Chesterfield | Virginia | 51041 | 145 | 0 |
45539 | 45539 | 2020-04-09 | Chesterfield | Virginia | 51041 | 158 | 0 |
48163 | 48163 | 2020-04-10 | Chesterfield | Virginia | 51041 | 179 | 0 |
50821 | 50821 | 2020-04-11 | Chesterfield | Virginia | 51041 | 203 | 0 |
53496 | 53496 | 2020-04-12 | Chesterfield | Virginia | 51041 | 209 | 0 |
56185 | 56185 | 2020-04-13 | Chesterfield | Virginia | 51041 | 211 | 5 |
58891 | 58891 | 2020-04-14 | Chesterfield | Virginia | 51041 | 241 | 5 |
61610 | 61610 | 2020-04-15 | Chesterfield | Virginia | 51041 | 254 | 5 |
64342 | 64342 | 2020-04-16 | Chesterfield | Virginia | 51041 | 267 | 5 |
67090 | 67090 | 2020-04-17 | Chesterfield | Virginia | 51041 | 291 | 5 |
69852 | 69852 | 2020-04-18 | Chesterfield | Virginia | 51041 | 310 | 5 |
72622 | 72622 | 2020-04-19 | Chesterfield | Virginia | 51041 | 311 | 5 |
75398 | 75398 | 2020-04-20 | Chesterfield | Virginia | 51041 | 331 | 5 |
78180 | 78180 | 2020-04-21 | Chesterfield | Virginia | 51041 | 346 | 7 |
80972 | 80972 | 2020-04-22 | Chesterfield | Virginia | 51041 | 356 | 7 |
83773 | 83773 | 2020-04-23 | Chesterfield | Virginia | 51041 | 402 | 7 |
86580 | 86580 | 2020-04-24 | Chesterfield | Virginia | 51041 | 423 | 17 |
89395 | 89395 | 2020-04-25 | Chesterfield | Virginia | 51041 | 440 | 18 |
92212 | 92212 | 2020-04-26 | Chesterfield | Virginia | 51041 | 457 | 18 |
95041 | 95041 | 2020-04-27 | Chesterfield | Virginia | 51041 | 457 | 18 |
97883 | 97883 | 2020-04-28 | Chesterfield | Virginia | 51041 | 488 | 19 |
100733 | 100733 | 2020-04-29 | Chesterfield | Virginia | 51041 | 501 | 19 |
103588 | 103588 | 2020-04-30 | Chesterfield | Virginia | 51041 | 531 | 20 |
106452 | 106452 | 2020-05-01 | Chesterfield | Virginia | 51041 | 557 | 24 |
109321 | 109321 | 2020-05-02 | Chesterfield | Virginia | 51041 | 593 | 24 |
112195 | 112195 | 2020-05-03 | Chesterfield | Virginia | 51041 | 601 | 24 |
115078 | 115078 | 2020-05-04 | Chesterfield | Virginia | 51041 | 601 | 24 |
118037 | 118037 | 2020-05-05 | Chesterfield | Virginia | 51041 | 646 | 25 |
121001 | 121001 | 2020-05-06 | Chesterfield | Virginia | 51041 | 646 | 25 |
123982 | 123982 | 2020-05-07 | Chesterfield | Virginia | 51041 | 707 | 26 |
126967 | 126967 | 2020-05-08 | Chesterfield | Virginia | 51041 | 741 | 26 |
129956 | 129956 | 2020-05-09 | Chesterfield | Virginia | 51041 | 765 | 26 |
132946 | 132946 | 2020-05-10 | Chesterfield | Virginia | 51041 | 787 | 26 |
135936 | 135936 | 2020-05-11 | Chesterfield | Virginia | 51041 | 789 | 26 |
138927 | 138927 | 2020-05-12 | Chesterfield | Virginia | 51041 | 837 | 28 |
141923 | 141923 | 2020-05-13 | Chesterfield | Virginia | 51041 | 862 | 29 |
144920 | 144920 | 2020-05-14 | Chesterfield | Virginia | 51041 | 909 | 29 |
147923 | 147923 | 2020-05-15 | Chesterfield | Virginia | 51041 | 946 | 29 |
150932 | 150932 | 2020-05-16 | Chesterfield | Virginia | 51041 | 978 | 29 |
153943 | 153943 | 2020-05-17 | Chesterfield | Virginia | 51041 | 988 | 29 |
156960 | 156960 | 2020-05-18 | Chesterfield | Virginia | 51041 | 1002 | 29 |
159984 | 159984 | 2020-05-19 | Chesterfield | Virginia | 51041 | 1043 | 29 |
163012 | 163012 | 2020-05-20 | Chesterfield | Virginia | 51041 | 1100 | 29 |
166041 | 166041 | 2020-05-21 | Chesterfield | Virginia | 51041 | 1132 | 29 |
169077 | 169077 | 2020-05-22 | Chesterfield | Virginia | 51041 | 1152 | 29 |
172118 | 172118 | 2020-05-23 | Chesterfield | Virginia | 51041 | 1193 | 29 |
175161 | 175161 | 2020-05-24 | Chesterfield | Virginia | 51041 | 1193 | 29 |
178206 | 178206 | 2020-05-25 | Chesterfield | Virginia | 51041 | 1200 | 30 |
181250 | 181250 | 2020-05-26 | Chesterfield | Virginia | 51041 | 1213 | 32 |
184301 | 184301 | 2020-05-27 | Chesterfield | Virginia | 51041 | 1263 | 32 |
187358 | 187358 | 2020-05-28 | Chesterfield | Virginia | 51041 | 1331 | 36 |
190422 | 190422 | 2020-05-29 | Chesterfield | Virginia | 51041 | 1400 | 35 |
193488 | 193488 | 2020-05-30 | Chesterfield | Virginia | 51041 | 1461 | 35 |
196558 | 196558 | 2020-05-31 | Chesterfield | Virginia | 51041 | 1548 | 35 |
199631 | 199631 | 2020-06-01 | Chesterfield | Virginia | 51041 | 1568 | 35 |
202707 | 202707 | 2020-06-02 | Chesterfield | Virginia | 51041 | 1627 | 37 |
205786 | 205786 | 2020-06-03 | Chesterfield | Virginia | 51041 | 1661 | 37 |
208868 | 208868 | 2020-06-04 | Chesterfield | Virginia | 51041 | 1721 | 37 |
211953 | 211953 | 2020-06-05 | Chesterfield | Virginia | 51041 | 1761 | 37 |
215040 | 215040 | 2020-06-06 | Chesterfield | Virginia | 51041 | 1797 | 37 |
218130 | 218130 | 2020-06-07 | Chesterfield | Virginia | 51041 | 1831 | 37 |
221222 | 221222 | 2020-06-08 | Chesterfield | Virginia | 51041 | 1866 | 37 |
224318 | 224318 | 2020-06-09 | Chesterfield | Virginia | 51041 | 1942 | 37 |
227418 | 227418 | 2020-06-10 | Chesterfield | Virginia | 51041 | 1995 | 38 |
230522 | 230522 | 2020-06-11 | Chesterfield | Virginia | 51041 | 2041 | 38 |
233627 | 233627 | 2020-06-12 | Chesterfield | Virginia | 51041 | 2109 | 38 |
236734 | 236734 | 2020-06-13 | Chesterfield | Virginia | 51041 | 2150 | 39 |
239842 | 239842 | 2020-06-14 | Chesterfield | Virginia | 51041 | 2181 | 39 |
242953 | 242953 | 2020-06-15 | Chesterfield | Virginia | 51041 | 2194 | 39 |
246065 | 246065 | 2020-06-16 | Chesterfield | Virginia | 51041 | 2259 | 39 |
249177 | 249177 | 2020-06-17 | Chesterfield | Virginia | 51041 | 2316 | 40 |
252292 | 252292 | 2020-06-18 | Chesterfield | Virginia | 51041 | 2375 | 40 |
255411 | 255411 | 2020-06-19 | Chesterfield | Virginia | 51041 | 2456 | 46 |
258538 | 258538 | 2020-06-20 | Chesterfield | Virginia | 51041 | 2541 | 46 |
261665 | 261665 | 2020-06-21 | Chesterfield | Virginia | 51041 | 2557 | 46 |
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);