ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
2,326 rows where county = "Richmond" sorted by date
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
state 3
- Georgia 788
- Virginia 771
- North Carolina 767
county 1
- Richmond · 2,326 ✖
Link | rowid | date ▼ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
3348 | 3348 | 2020-03-17 | Richmond | Georgia | 13245 | 1 | 0 |
3910 | 3910 | 2020-03-18 | Richmond | Georgia | 13245 | 2 | 0 |
4585 | 4585 | 2020-03-19 | Richmond | Georgia | 13245 | 3 | 0 |
5378 | 5378 | 2020-03-20 | Richmond | Georgia | 13245 | 9 | 0 |
6312 | 6312 | 2020-03-21 | Richmond | Georgia | 13245 | 10 | 0 |
7358 | 7358 | 2020-03-22 | Richmond | Georgia | 13245 | 10 | 0 |
8511 | 8511 | 2020-03-23 | Richmond | Georgia | 13245 | 11 | 0 |
9770 | 9770 | 2020-03-24 | Richmond | Georgia | 13245 | 11 | 0 |
11150 | 11150 | 2020-03-25 | Richmond | Georgia | 13245 | 11 | 0 |
12702 | 12702 | 2020-03-26 | Richmond | Georgia | 13245 | 11 | 0 |
14376 | 14376 | 2020-03-27 | Richmond | Georgia | 13245 | 11 | 0 |
16165 | 16165 | 2020-03-28 | Richmond | Georgia | 13245 | 12 | 0 |
18062 | 18062 | 2020-03-29 | Richmond | Georgia | 13245 | 12 | 0 |
20055 | 20055 | 2020-03-30 | Richmond | Georgia | 13245 | 17 | 0 |
22138 | 22138 | 2020-03-31 | Richmond | Georgia | 13245 | 40 | 0 |
24303 | 24303 | 2020-04-01 | Richmond | Georgia | 13245 | 41 | 0 |
26534 | 26534 | 2020-04-02 | Richmond | Georgia | 13245 | 42 | 1 |
28840 | 28840 | 2020-04-03 | Richmond | Georgia | 13245 | 49 | 1 |
30587 | 30587 | 2020-04-03 | Richmond | Virginia | 51159 | 1 | 0 |
31200 | 31200 | 2020-04-04 | Richmond | Georgia | 13245 | 51 | 1 |
32986 | 32986 | 2020-04-04 | Richmond | Virginia | 51159 | 1 | 0 |
33607 | 33607 | 2020-04-05 | Richmond | Georgia | 13245 | 51 | 1 |
35424 | 35424 | 2020-04-05 | Richmond | Virginia | 51159 | 1 | 0 |
36057 | 36057 | 2020-04-06 | Richmond | Georgia | 13245 | 56 | 1 |
37907 | 37907 | 2020-04-06 | Richmond | Virginia | 51159 | 1 | 0 |
38550 | 38550 | 2020-04-07 | Richmond | Georgia | 13245 | 75 | 3 |
39692 | 39692 | 2020-04-07 | Richmond | North Carolina | 37153 | 1 | 0 |
40442 | 40442 | 2020-04-07 | Richmond | Virginia | 51159 | 2 | 0 |
41094 | 41094 | 2020-04-08 | Richmond | Georgia | 13245 | 79 | 3 |
42249 | 42249 | 2020-04-08 | Richmond | North Carolina | 37153 | 1 | 0 |
43011 | 43011 | 2020-04-08 | Richmond | Virginia | 51159 | 2 | 0 |
43668 | 43668 | 2020-04-09 | Richmond | Georgia | 13245 | 89 | 4 |
44833 | 44833 | 2020-04-09 | Richmond | North Carolina | 37153 | 2 | 0 |
45607 | 45607 | 2020-04-09 | Richmond | Virginia | 51159 | 3 | 0 |
46270 | 46270 | 2020-04-10 | Richmond | Georgia | 13245 | 134 | 4 |
47446 | 47446 | 2020-04-10 | Richmond | North Carolina | 37153 | 4 | 0 |
48233 | 48233 | 2020-04-10 | Richmond | Virginia | 51159 | 5 | 0 |
48901 | 48901 | 2020-04-11 | Richmond | Georgia | 13245 | 138 | 3 |
50101 | 50101 | 2020-04-11 | Richmond | North Carolina | 37153 | 7 | 1 |
50891 | 50891 | 2020-04-11 | Richmond | Virginia | 51159 | 5 | 0 |
51563 | 51563 | 2020-04-12 | Richmond | Georgia | 13245 | 144 | 4 |
52774 | 52774 | 2020-04-12 | Richmond | North Carolina | 37153 | 10 | 1 |
53566 | 53566 | 2020-04-12 | Richmond | Virginia | 51159 | 5 | 0 |
54243 | 54243 | 2020-04-13 | Richmond | Georgia | 13245 | 156 | 6 |
55458 | 55458 | 2020-04-13 | Richmond | North Carolina | 37153 | 10 | 1 |
56256 | 56256 | 2020-04-13 | Richmond | Virginia | 51159 | 5 | 0 |
56935 | 56935 | 2020-04-14 | Richmond | Georgia | 13245 | 162 | 7 |
58158 | 58158 | 2020-04-14 | Richmond | North Carolina | 37153 | 12 | 1 |
58962 | 58962 | 2020-04-14 | Richmond | Virginia | 51159 | 7 | 0 |
59642 | 59642 | 2020-04-15 | Richmond | Georgia | 13245 | 169 | 8 |
60872 | 60872 | 2020-04-15 | Richmond | North Carolina | 37153 | 12 | 1 |
61681 | 61681 | 2020-04-15 | Richmond | Virginia | 51159 | 7 | 0 |
62362 | 62362 | 2020-04-16 | Richmond | Georgia | 13245 | 231 | 9 |
63598 | 63598 | 2020-04-16 | Richmond | North Carolina | 37153 | 15 | 1 |
64414 | 64414 | 2020-04-16 | Richmond | Virginia | 51159 | 7 | 0 |
65095 | 65095 | 2020-04-17 | Richmond | Georgia | 13245 | 246 | 10 |
66341 | 66341 | 2020-04-17 | Richmond | North Carolina | 37153 | 17 | 2 |
67162 | 67162 | 2020-04-17 | Richmond | Virginia | 51159 | 8 | 0 |
67843 | 67843 | 2020-04-18 | Richmond | Georgia | 13245 | 262 | 10 |
69098 | 69098 | 2020-04-18 | Richmond | North Carolina | 37153 | 18 | 2 |
69924 | 69924 | 2020-04-18 | Richmond | Virginia | 51159 | 8 | 0 |
70605 | 70605 | 2020-04-19 | Richmond | Georgia | 13245 | 264 | 10 |
71864 | 71864 | 2020-04-19 | Richmond | North Carolina | 37153 | 19 | 2 |
72694 | 72694 | 2020-04-19 | Richmond | Virginia | 51159 | 9 | 0 |
73374 | 73374 | 2020-04-20 | Richmond | Georgia | 13245 | 283 | 11 |
74639 | 74639 | 2020-04-20 | Richmond | North Carolina | 37153 | 20 | 2 |
75470 | 75470 | 2020-04-20 | Richmond | Virginia | 51159 | 9 | 0 |
76150 | 76150 | 2020-04-21 | Richmond | Georgia | 13245 | 294 | 12 |
77420 | 77420 | 2020-04-21 | Richmond | North Carolina | 37153 | 20 | 2 |
78254 | 78254 | 2020-04-21 | Richmond | Virginia | 51159 | 53 | 0 |
78934 | 78934 | 2020-04-22 | Richmond | Georgia | 13245 | 313 | 13 |
80209 | 80209 | 2020-04-22 | Richmond | North Carolina | 37153 | 22 | 2 |
81047 | 81047 | 2020-04-22 | Richmond | Virginia | 51159 | 53 | 0 |
81727 | 81727 | 2020-04-23 | Richmond | Georgia | 13245 | 335 | 14 |
83008 | 83008 | 2020-04-23 | Richmond | North Carolina | 37153 | 28 | 2 |
83848 | 83848 | 2020-04-23 | Richmond | Virginia | 51159 | 66 | 0 |
84527 | 84527 | 2020-04-24 | Richmond | Georgia | 13245 | 353 | 14 |
85812 | 85812 | 2020-04-24 | Richmond | North Carolina | 37153 | 30 | 2 |
86655 | 86655 | 2020-04-24 | Richmond | Virginia | 51159 | 66 | 0 |
87336 | 87336 | 2020-04-25 | Richmond | Georgia | 13245 | 355 | 14 |
88625 | 88625 | 2020-04-25 | Richmond | North Carolina | 37153 | 36 | 2 |
89470 | 89470 | 2020-04-25 | Richmond | Virginia | 51159 | 79 | 0 |
90152 | 90152 | 2020-04-26 | Richmond | Georgia | 13245 | 360 | 14 |
91440 | 91440 | 2020-04-26 | Richmond | North Carolina | 37153 | 36 | 2 |
92287 | 92287 | 2020-04-26 | Richmond | Virginia | 51159 | 89 | 0 |
92971 | 92971 | 2020-04-27 | Richmond | Georgia | 13245 | 377 | 14 |
94266 | 94266 | 2020-04-27 | Richmond | North Carolina | 37153 | 36 | 2 |
95116 | 95116 | 2020-04-27 | Richmond | Virginia | 51159 | 132 | 0 |
95803 | 95803 | 2020-04-28 | Richmond | Georgia | 13245 | 382 | 14 |
97103 | 97103 | 2020-04-28 | Richmond | North Carolina | 37153 | 40 | 2 |
97960 | 97960 | 2020-04-28 | Richmond | Virginia | 51159 | 141 | 0 |
98648 | 98648 | 2020-04-29 | Richmond | Georgia | 13245 | 390 | 14 |
99951 | 99951 | 2020-04-29 | Richmond | North Carolina | 37153 | 42 | 2 |
100810 | 100810 | 2020-04-29 | Richmond | Virginia | 51159 | 143 | 0 |
101498 | 101498 | 2020-04-30 | Richmond | Georgia | 13245 | 406 | 15 |
102804 | 102804 | 2020-04-30 | Richmond | North Carolina | 37153 | 47 | 2 |
103665 | 103665 | 2020-04-30 | Richmond | Virginia | 51159 | 144 | 0 |
104353 | 104353 | 2020-05-01 | Richmond | Georgia | 13245 | 412 | 15 |
105666 | 105666 | 2020-05-01 | Richmond | North Carolina | 37153 | 48 | 2 |
106529 | 106529 | 2020-05-01 | Richmond | Virginia | 51159 | 142 | 0 |
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);