ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
1,572 rows where county = "Chesterfield" sorted by county
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date, 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 |
10542 | 10542 | 2020-03-24 | Chesterfield | South Carolina | 45025 | 1 | 0 |
10720 | 10720 | 2020-03-24 | Chesterfield | Virginia | 51041 | 10 | 0 |
12013 | 12013 | 2020-03-25 | Chesterfield | South Carolina | 45025 | 3 | 0 |
12232 | 12232 | 2020-03-25 | Chesterfield | Virginia | 51041 | 11 | 0 |
13635 | 13635 | 2020-03-26 | Chesterfield | South Carolina | 45025 | 3 | 0 |
13869 | 13869 | 2020-03-26 | Chesterfield | Virginia | 51041 | 12 | 0 |
15382 | 15382 | 2020-03-27 | Chesterfield | South Carolina | 45025 | 4 | 0 |
15636 | 15636 | 2020-03-27 | Chesterfield | Virginia | 51041 | 12 | 0 |
17236 | 17236 | 2020-03-28 | Chesterfield | South Carolina | 45025 | 4 | 0 |
17510 | 17510 | 2020-03-28 | Chesterfield | Virginia | 51041 | 12 | 0 |
19176 | 19176 | 2020-03-29 | Chesterfield | South Carolina | 45025 | 4 | 0 |
19470 | 19470 | 2020-03-29 | Chesterfield | Virginia | 51041 | 13 | 0 |
21228 | 21228 | 2020-03-30 | Chesterfield | South Carolina | 45025 | 6 | 0 |
21533 | 21533 | 2020-03-30 | Chesterfield | Virginia | 51041 | 21 | 0 |
23366 | 23366 | 2020-03-31 | Chesterfield | South Carolina | 45025 | 6 | 0 |
23676 | 23676 | 2020-03-31 | Chesterfield | Virginia | 51041 | 43 | 0 |
25564 | 25564 | 2020-04-01 | Chesterfield | South Carolina | 45025 | 9 | 0 |
25892 | 25892 | 2020-04-01 | Chesterfield | Virginia | 51041 | 59 | 0 |
27838 | 27838 | 2020-04-02 | Chesterfield | South Carolina | 45025 | 10 | 0 |
28181 | 28181 | 2020-04-02 | Chesterfield | Virginia | 51041 | 73 | 0 |
30173 | 30173 | 2020-04-03 | Chesterfield | South Carolina | 45025 | 10 | 0 |
30526 | 30526 | 2020-04-03 | Chesterfield | Virginia | 51041 | 89 | 0 |
32564 | 32564 | 2020-04-04 | Chesterfield | South Carolina | 45025 | 13 | 0 |
32925 | 32925 | 2020-04-04 | Chesterfield | Virginia | 51041 | 106 | 0 |
35000 | 35000 | 2020-04-05 | Chesterfield | South Carolina | 45025 | 13 | 0 |
35363 | 35363 | 2020-04-05 | Chesterfield | Virginia | 51041 | 108 | 0 |
37475 | 37475 | 2020-04-06 | Chesterfield | South Carolina | 45025 | 15 | 0 |
37845 | 37845 | 2020-04-06 | Chesterfield | Virginia | 51041 | 108 | 0 |
39998 | 39998 | 2020-04-07 | Chesterfield | South Carolina | 45025 | 16 | 0 |
40376 | 40376 | 2020-04-07 | Chesterfield | Virginia | 51041 | 128 | 0 |
42558 | 42558 | 2020-04-08 | Chesterfield | South Carolina | 45025 | 20 | 0 |
42945 | 42945 | 2020-04-08 | Chesterfield | Virginia | 51041 | 145 | 0 |
45144 | 45144 | 2020-04-09 | Chesterfield | South Carolina | 45025 | 21 | 0 |
45539 | 45539 | 2020-04-09 | Chesterfield | Virginia | 51041 | 158 | 0 |
47761 | 47761 | 2020-04-10 | Chesterfield | South Carolina | 45025 | 22 | 0 |
48163 | 48163 | 2020-04-10 | Chesterfield | Virginia | 51041 | 179 | 0 |
50418 | 50418 | 2020-04-11 | Chesterfield | South Carolina | 45025 | 22 | 0 |
50821 | 50821 | 2020-04-11 | Chesterfield | Virginia | 51041 | 203 | 0 |
53091 | 53091 | 2020-04-12 | Chesterfield | South Carolina | 45025 | 22 | 0 |
53496 | 53496 | 2020-04-12 | Chesterfield | Virginia | 51041 | 209 | 0 |
55776 | 55776 | 2020-04-13 | Chesterfield | South Carolina | 45025 | 23 | 0 |
56185 | 56185 | 2020-04-13 | Chesterfield | Virginia | 51041 | 211 | 5 |
58479 | 58479 | 2020-04-14 | Chesterfield | South Carolina | 45025 | 27 | 0 |
58891 | 58891 | 2020-04-14 | Chesterfield | Virginia | 51041 | 241 | 5 |
61194 | 61194 | 2020-04-15 | Chesterfield | South Carolina | 45025 | 28 | 0 |
61610 | 61610 | 2020-04-15 | Chesterfield | Virginia | 51041 | 254 | 5 |
63920 | 63920 | 2020-04-16 | Chesterfield | South Carolina | 45025 | 29 | 0 |
64342 | 64342 | 2020-04-16 | Chesterfield | Virginia | 51041 | 267 | 5 |
66666 | 66666 | 2020-04-17 | Chesterfield | South Carolina | 45025 | 31 | 0 |
67090 | 67090 | 2020-04-17 | Chesterfield | Virginia | 51041 | 291 | 5 |
69424 | 69424 | 2020-04-18 | Chesterfield | South Carolina | 45025 | 35 | 0 |
69852 | 69852 | 2020-04-18 | Chesterfield | Virginia | 51041 | 310 | 5 |
72191 | 72191 | 2020-04-19 | Chesterfield | South Carolina | 45025 | 36 | 0 |
72622 | 72622 | 2020-04-19 | Chesterfield | Virginia | 51041 | 311 | 5 |
74966 | 74966 | 2020-04-20 | Chesterfield | South Carolina | 45025 | 36 | 0 |
75398 | 75398 | 2020-04-20 | Chesterfield | Virginia | 51041 | 331 | 5 |
77748 | 77748 | 2020-04-21 | Chesterfield | South Carolina | 45025 | 37 | 0 |
78180 | 78180 | 2020-04-21 | Chesterfield | Virginia | 51041 | 346 | 7 |
80538 | 80538 | 2020-04-22 | Chesterfield | South Carolina | 45025 | 37 | 0 |
80972 | 80972 | 2020-04-22 | Chesterfield | Virginia | 51041 | 356 | 7 |
83337 | 83337 | 2020-04-23 | Chesterfield | South Carolina | 45025 | 39 | 0 |
83773 | 83773 | 2020-04-23 | Chesterfield | Virginia | 51041 | 402 | 7 |
86141 | 86141 | 2020-04-24 | Chesterfield | South Carolina | 45025 | 40 | 0 |
86580 | 86580 | 2020-04-24 | Chesterfield | Virginia | 51041 | 423 | 17 |
88955 | 88955 | 2020-04-25 | Chesterfield | South Carolina | 45025 | 44 | 0 |
89395 | 89395 | 2020-04-25 | Chesterfield | Virginia | 51041 | 440 | 18 |
91771 | 91771 | 2020-04-26 | Chesterfield | South Carolina | 45025 | 44 | 0 |
92212 | 92212 | 2020-04-26 | Chesterfield | Virginia | 51041 | 457 | 18 |
94598 | 94598 | 2020-04-27 | Chesterfield | South Carolina | 45025 | 46 | 0 |
95041 | 95041 | 2020-04-27 | Chesterfield | Virginia | 51041 | 457 | 18 |
97437 | 97437 | 2020-04-28 | Chesterfield | South Carolina | 45025 | 47 | 0 |
97883 | 97883 | 2020-04-28 | Chesterfield | Virginia | 51041 | 488 | 19 |
100286 | 100286 | 2020-04-29 | Chesterfield | South Carolina | 45025 | 48 | 0 |
100733 | 100733 | 2020-04-29 | Chesterfield | Virginia | 51041 | 501 | 19 |
103139 | 103139 | 2020-04-30 | Chesterfield | South Carolina | 45025 | 51 | 1 |
103588 | 103588 | 2020-04-30 | Chesterfield | Virginia | 51041 | 531 | 20 |
106002 | 106002 | 2020-05-01 | Chesterfield | South Carolina | 45025 | 58 | 1 |
106452 | 106452 | 2020-05-01 | Chesterfield | Virginia | 51041 | 557 | 24 |
108869 | 108869 | 2020-05-02 | Chesterfield | South Carolina | 45025 | 59 | 1 |
109321 | 109321 | 2020-05-02 | Chesterfield | Virginia | 51041 | 593 | 24 |
111743 | 111743 | 2020-05-03 | Chesterfield | South Carolina | 45025 | 59 | 1 |
112195 | 112195 | 2020-05-03 | Chesterfield | Virginia | 51041 | 601 | 24 |
114625 | 114625 | 2020-05-04 | Chesterfield | South Carolina | 45025 | 60 | 1 |
115078 | 115078 | 2020-05-04 | Chesterfield | Virginia | 51041 | 601 | 24 |
117581 | 117581 | 2020-05-05 | Chesterfield | South Carolina | 45025 | 61 | 1 |
118037 | 118037 | 2020-05-05 | Chesterfield | Virginia | 51041 | 646 | 25 |
120543 | 120543 | 2020-05-06 | Chesterfield | South Carolina | 45025 | 65 | 1 |
121001 | 121001 | 2020-05-06 | Chesterfield | Virginia | 51041 | 646 | 25 |
123521 | 123521 | 2020-05-07 | Chesterfield | South Carolina | 45025 | 69 | 1 |
123982 | 123982 | 2020-05-07 | Chesterfield | Virginia | 51041 | 707 | 26 |
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);