ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
788 rows where county = "Williamsburg city" and state = "Virginia" sorted by state
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths
date (date) >30 ✖
- 2020-03-17 1
- 2020-03-18 1
- 2020-03-19 1
- 2020-03-20 1
- 2020-03-21 1
- 2020-03-22 1
- 2020-03-23 1
- 2020-03-24 1
- 2020-03-25 1
- 2020-03-26 1
- 2020-03-27 1
- 2020-03-28 1
- 2020-03-29 1
- 2020-03-30 1
- 2020-03-31 1
- 2020-04-01 1
- 2020-04-02 1
- 2020-04-03 1
- 2020-04-04 1
- 2020-04-05 1
- 2020-04-06 1
- 2020-04-07 1
- 2020-04-08 1
- 2020-04-09 1
- 2020-04-10 1
- 2020-04-11 1
- 2020-04-12 1
- 2020-04-13 1
- 2020-04-14 1
- 2020-04-15 1
- …
state 1
- Virginia · 788 ✖
fips 1
- 51830 788
county 1
- Williamsburg city · 788 ✖
Link | rowid | date | county | state ▼ | fips | cases | deaths |
---|---|---|---|---|---|---|---|
3720 | 3720 | 2020-03-17 | Williamsburg city | Virginia | 51830 | 1 | 0 |
4354 | 4354 | 2020-03-18 | Williamsburg city | Virginia | 51830 | 1 | 0 |
5110 | 5110 | 2020-03-19 | Williamsburg city | Virginia | 51830 | 1 | 0 |
6011 | 6011 | 2020-03-20 | Williamsburg city | Virginia | 51830 | 4 | 0 |
7042 | 7042 | 2020-03-21 | Williamsburg city | Virginia | 51830 | 4 | 0 |
8179 | 8179 | 2020-03-22 | Williamsburg city | Virginia | 51830 | 5 | 1 |
9402 | 9402 | 2020-03-23 | Williamsburg city | Virginia | 51830 | 5 | 1 |
10751 | 10751 | 2020-03-24 | Williamsburg city | Virginia | 51830 | 5 | 1 |
12273 | 12273 | 2020-03-25 | Williamsburg city | Virginia | 51830 | 5 | 1 |
13923 | 13923 | 2020-03-26 | Williamsburg city | Virginia | 51830 | 5 | 1 |
15691 | 15691 | 2020-03-27 | Williamsburg city | Virginia | 51830 | 5 | 1 |
17571 | 17571 | 2020-03-28 | Williamsburg city | Virginia | 51830 | 6 | 1 |
19534 | 19534 | 2020-03-29 | Williamsburg city | Virginia | 51830 | 7 | 1 |
21601 | 21601 | 2020-03-30 | Williamsburg city | Virginia | 51830 | 7 | 1 |
23750 | 23750 | 2020-03-31 | Williamsburg city | Virginia | 51830 | 8 | 1 |
25968 | 25968 | 2020-04-01 | Williamsburg city | Virginia | 51830 | 9 | 1 |
28258 | 28258 | 2020-04-02 | Williamsburg city | Virginia | 51830 | 9 | 1 |
30609 | 30609 | 2020-04-03 | Williamsburg city | Virginia | 51830 | 9 | 1 |
33009 | 33009 | 2020-04-04 | Williamsburg city | Virginia | 51830 | 10 | 1 |
35447 | 35447 | 2020-04-05 | Williamsburg city | Virginia | 51830 | 12 | 1 |
37931 | 37931 | 2020-04-06 | Williamsburg city | Virginia | 51830 | 13 | 1 |
40466 | 40466 | 2020-04-07 | Williamsburg city | Virginia | 51830 | 14 | 1 |
43035 | 43035 | 2020-04-08 | Williamsburg city | Virginia | 51830 | 16 | 1 |
45631 | 45631 | 2020-04-09 | Williamsburg city | Virginia | 51830 | 16 | 1 |
48258 | 48258 | 2020-04-10 | Williamsburg city | Virginia | 51830 | 17 | 1 |
50916 | 50916 | 2020-04-11 | Williamsburg city | Virginia | 51830 | 17 | 1 |
53591 | 53591 | 2020-04-12 | Williamsburg city | Virginia | 51830 | 17 | 1 |
56281 | 56281 | 2020-04-13 | Williamsburg city | Virginia | 51830 | 20 | 1 |
58987 | 58987 | 2020-04-14 | Williamsburg city | Virginia | 51830 | 20 | 1 |
61706 | 61706 | 2020-04-15 | Williamsburg city | Virginia | 51830 | 19 | 1 |
64439 | 64439 | 2020-04-16 | Williamsburg city | Virginia | 51830 | 19 | 1 |
67187 | 67187 | 2020-04-17 | Williamsburg city | Virginia | 51830 | 19 | 1 |
69949 | 69949 | 2020-04-18 | Williamsburg city | Virginia | 51830 | 19 | 1 |
72719 | 72719 | 2020-04-19 | Williamsburg city | Virginia | 51830 | 19 | 1 |
75495 | 75495 | 2020-04-20 | Williamsburg city | Virginia | 51830 | 19 | 1 |
78278 | 78278 | 2020-04-21 | Williamsburg city | Virginia | 51830 | 15 | 1 |
81071 | 81071 | 2020-04-22 | Williamsburg city | Virginia | 51830 | 14 | 1 |
83872 | 83872 | 2020-04-23 | Williamsburg city | Virginia | 51830 | 15 | 1 |
86679 | 86679 | 2020-04-24 | Williamsburg city | Virginia | 51830 | 15 | 1 |
89494 | 89494 | 2020-04-25 | Williamsburg city | Virginia | 51830 | 15 | 1 |
92311 | 92311 | 2020-04-26 | Williamsburg city | Virginia | 51830 | 15 | 1 |
95140 | 95140 | 2020-04-27 | Williamsburg city | Virginia | 51830 | 15 | 1 |
97985 | 97985 | 2020-04-28 | Williamsburg city | Virginia | 51830 | 18 | 1 |
100835 | 100835 | 2020-04-29 | Williamsburg city | Virginia | 51830 | 18 | 1 |
103690 | 103690 | 2020-04-30 | Williamsburg city | Virginia | 51830 | 18 | 1 |
106554 | 106554 | 2020-05-01 | Williamsburg city | Virginia | 51830 | 20 | 1 |
109423 | 109423 | 2020-05-02 | Williamsburg city | Virginia | 51830 | 21 | 2 |
112297 | 112297 | 2020-05-03 | Williamsburg city | Virginia | 51830 | 22 | 2 |
115180 | 115180 | 2020-05-04 | Williamsburg city | Virginia | 51830 | 23 | 2 |
118139 | 118139 | 2020-05-05 | Williamsburg city | Virginia | 51830 | 27 | 2 |
121103 | 121103 | 2020-05-06 | Williamsburg city | Virginia | 51830 | 27 | 2 |
124083 | 124083 | 2020-05-07 | Williamsburg city | Virginia | 51830 | 29 | 2 |
127068 | 127068 | 2020-05-08 | Williamsburg city | Virginia | 51830 | 31 | 2 |
130058 | 130058 | 2020-05-09 | Williamsburg city | Virginia | 51830 | 31 | 2 |
133048 | 133048 | 2020-05-10 | Williamsburg city | Virginia | 51830 | 39 | 2 |
136038 | 136038 | 2020-05-11 | Williamsburg city | Virginia | 51830 | 42 | 3 |
139029 | 139029 | 2020-05-12 | Williamsburg city | Virginia | 51830 | 42 | 3 |
142025 | 142025 | 2020-05-13 | Williamsburg city | Virginia | 51830 | 42 | 3 |
145022 | 145022 | 2020-05-14 | Williamsburg city | Virginia | 51830 | 42 | 3 |
148025 | 148025 | 2020-05-15 | Williamsburg city | Virginia | 51830 | 42 | 3 |
151034 | 151034 | 2020-05-16 | Williamsburg city | Virginia | 51830 | 43 | 3 |
154045 | 154045 | 2020-05-17 | Williamsburg city | Virginia | 51830 | 43 | 3 |
157062 | 157062 | 2020-05-18 | Williamsburg city | Virginia | 51830 | 43 | 3 |
160086 | 160086 | 2020-05-19 | Williamsburg city | Virginia | 51830 | 43 | 3 |
163114 | 163114 | 2020-05-20 | Williamsburg city | Virginia | 51830 | 43 | 3 |
166143 | 166143 | 2020-05-21 | Williamsburg city | Virginia | 51830 | 43 | 3 |
169179 | 169179 | 2020-05-22 | Williamsburg city | Virginia | 51830 | 43 | 3 |
172220 | 172220 | 2020-05-23 | Williamsburg city | Virginia | 51830 | 43 | 3 |
175263 | 175263 | 2020-05-24 | Williamsburg city | Virginia | 51830 | 43 | 3 |
178308 | 178308 | 2020-05-25 | Williamsburg city | Virginia | 51830 | 43 | 3 |
181352 | 181352 | 2020-05-26 | Williamsburg city | Virginia | 51830 | 43 | 3 |
184403 | 184403 | 2020-05-27 | Williamsburg city | Virginia | 51830 | 43 | 3 |
187460 | 187460 | 2020-05-28 | Williamsburg city | Virginia | 51830 | 44 | 4 |
190524 | 190524 | 2020-05-29 | Williamsburg city | Virginia | 51830 | 44 | 4 |
193590 | 193590 | 2020-05-30 | Williamsburg city | Virginia | 51830 | 44 | 4 |
196660 | 196660 | 2020-05-31 | Williamsburg city | Virginia | 51830 | 44 | 4 |
199733 | 199733 | 2020-06-01 | Williamsburg city | Virginia | 51830 | 44 | 4 |
202809 | 202809 | 2020-06-02 | Williamsburg city | Virginia | 51830 | 44 | 4 |
205888 | 205888 | 2020-06-03 | Williamsburg city | Virginia | 51830 | 45 | 4 |
208970 | 208970 | 2020-06-04 | Williamsburg city | Virginia | 51830 | 45 | 5 |
212055 | 212055 | 2020-06-05 | Williamsburg city | Virginia | 51830 | 45 | 5 |
215142 | 215142 | 2020-06-06 | Williamsburg city | Virginia | 51830 | 45 | 5 |
218232 | 218232 | 2020-06-07 | Williamsburg city | Virginia | 51830 | 46 | 5 |
221324 | 221324 | 2020-06-08 | Williamsburg city | Virginia | 51830 | 46 | 5 |
224420 | 224420 | 2020-06-09 | Williamsburg city | Virginia | 51830 | 48 | 5 |
227520 | 227520 | 2020-06-10 | Williamsburg city | Virginia | 51830 | 48 | 5 |
230624 | 230624 | 2020-06-11 | Williamsburg city | Virginia | 51830 | 49 | 5 |
233729 | 233729 | 2020-06-12 | Williamsburg city | Virginia | 51830 | 49 | 5 |
236836 | 236836 | 2020-06-13 | Williamsburg city | Virginia | 51830 | 49 | 5 |
239944 | 239944 | 2020-06-14 | Williamsburg city | Virginia | 51830 | 50 | 5 |
243055 | 243055 | 2020-06-15 | Williamsburg city | Virginia | 51830 | 50 | 5 |
246168 | 246168 | 2020-06-16 | Williamsburg city | Virginia | 51830 | 53 | 5 |
249280 | 249280 | 2020-06-17 | Williamsburg city | Virginia | 51830 | 54 | 5 |
252395 | 252395 | 2020-06-18 | Williamsburg city | Virginia | 51830 | 54 | 5 |
255514 | 255514 | 2020-06-19 | Williamsburg city | Virginia | 51830 | 54 | 5 |
258641 | 258641 | 2020-06-20 | Williamsburg city | Virginia | 51830 | 54 | 5 |
261768 | 261768 | 2020-06-21 | Williamsburg city | Virginia | 51830 | 54 | 5 |
264897 | 264897 | 2020-06-22 | Williamsburg city | Virginia | 51830 | 54 | 5 |
268026 | 268026 | 2020-06-23 | Williamsburg city | Virginia | 51830 | 54 | 5 |
271160 | 271160 | 2020-06-24 | Williamsburg city | Virginia | 51830 | 54 | 5 |
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);