ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
789 rows where county = "Stafford" and fips = 51179 sorted by date
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid | date ▼ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
3179 | 3179 | 2020-03-16 | Stafford | Virginia | 51179 | 1 | 0 |
3718 | 3718 | 2020-03-17 | Stafford | Virginia | 51179 | 1 | 0 |
4352 | 4352 | 2020-03-18 | Stafford | Virginia | 51179 | 2 | 0 |
5108 | 5108 | 2020-03-19 | Stafford | Virginia | 51179 | 2 | 0 |
6009 | 6009 | 2020-03-20 | Stafford | Virginia | 51179 | 2 | 0 |
7039 | 7039 | 2020-03-21 | Stafford | Virginia | 51179 | 2 | 0 |
8176 | 8176 | 2020-03-22 | Stafford | Virginia | 51179 | 5 | 0 |
9399 | 9399 | 2020-03-23 | Stafford | Virginia | 51179 | 6 | 0 |
10747 | 10747 | 2020-03-24 | Stafford | Virginia | 51179 | 6 | 0 |
12269 | 12269 | 2020-03-25 | Stafford | Virginia | 51179 | 6 | 0 |
13917 | 13917 | 2020-03-26 | Stafford | Virginia | 51179 | 11 | 0 |
15686 | 15686 | 2020-03-27 | Stafford | Virginia | 51179 | 11 | 0 |
17566 | 17566 | 2020-03-28 | Stafford | Virginia | 51179 | 11 | 0 |
19528 | 19528 | 2020-03-29 | Stafford | Virginia | 51179 | 13 | 0 |
21595 | 21595 | 2020-03-30 | Stafford | Virginia | 51179 | 20 | 0 |
23742 | 23742 | 2020-03-31 | Stafford | Virginia | 51179 | 24 | 0 |
25958 | 25958 | 2020-04-01 | Stafford | Virginia | 51179 | 28 | 0 |
28249 | 28249 | 2020-04-02 | Stafford | Virginia | 51179 | 28 | 0 |
30598 | 30598 | 2020-04-03 | Stafford | Virginia | 51179 | 29 | 0 |
32997 | 32997 | 2020-04-04 | Stafford | Virginia | 51179 | 38 | 0 |
35435 | 35435 | 2020-04-05 | Stafford | Virginia | 51179 | 41 | 0 |
37919 | 37919 | 2020-04-06 | Stafford | Virginia | 51179 | 43 | 0 |
40454 | 40454 | 2020-04-07 | Stafford | Virginia | 51179 | 49 | 0 |
43023 | 43023 | 2020-04-08 | Stafford | Virginia | 51179 | 48 | 0 |
45619 | 45619 | 2020-04-09 | Stafford | Virginia | 51179 | 54 | 0 |
48246 | 48246 | 2020-04-10 | Stafford | Virginia | 51179 | 60 | 0 |
50904 | 50904 | 2020-04-11 | Stafford | Virginia | 51179 | 67 | 0 |
53579 | 53579 | 2020-04-12 | Stafford | Virginia | 51179 | 72 | 1 |
56269 | 56269 | 2020-04-13 | Stafford | Virginia | 51179 | 87 | 1 |
58975 | 58975 | 2020-04-14 | Stafford | Virginia | 51179 | 95 | 1 |
61694 | 61694 | 2020-04-15 | Stafford | Virginia | 51179 | 108 | 1 |
64427 | 64427 | 2020-04-16 | Stafford | Virginia | 51179 | 120 | 1 |
67175 | 67175 | 2020-04-17 | Stafford | Virginia | 51179 | 128 | 1 |
69937 | 69937 | 2020-04-18 | Stafford | Virginia | 51179 | 143 | 1 |
72707 | 72707 | 2020-04-19 | Stafford | Virginia | 51179 | 152 | 1 |
75483 | 75483 | 2020-04-20 | Stafford | Virginia | 51179 | 161 | 1 |
78267 | 78267 | 2020-04-21 | Stafford | Virginia | 51179 | 164 | 2 |
81060 | 81060 | 2020-04-22 | Stafford | Virginia | 51179 | 170 | 2 |
83861 | 83861 | 2020-04-23 | Stafford | Virginia | 51179 | 180 | 2 |
86668 | 86668 | 2020-04-24 | Stafford | Virginia | 51179 | 193 | 2 |
89483 | 89483 | 2020-04-25 | Stafford | Virginia | 51179 | 198 | 2 |
92300 | 92300 | 2020-04-26 | Stafford | Virginia | 51179 | 213 | 2 |
95129 | 95129 | 2020-04-27 | Stafford | Virginia | 51179 | 218 | 2 |
97973 | 97973 | 2020-04-28 | Stafford | Virginia | 51179 | 221 | 2 |
100823 | 100823 | 2020-04-29 | Stafford | Virginia | 51179 | 225 | 2 |
103678 | 103678 | 2020-04-30 | Stafford | Virginia | 51179 | 240 | 2 |
106542 | 106542 | 2020-05-01 | Stafford | Virginia | 51179 | 251 | 2 |
109411 | 109411 | 2020-05-02 | Stafford | Virginia | 51179 | 262 | 2 |
112285 | 112285 | 2020-05-03 | Stafford | Virginia | 51179 | 271 | 2 |
115168 | 115168 | 2020-05-04 | Stafford | Virginia | 51179 | 288 | 2 |
118127 | 118127 | 2020-05-05 | Stafford | Virginia | 51179 | 308 | 2 |
121091 | 121091 | 2020-05-06 | Stafford | Virginia | 51179 | 308 | 2 |
124072 | 124072 | 2020-05-07 | Stafford | Virginia | 51179 | 334 | 2 |
127057 | 127057 | 2020-05-08 | Stafford | Virginia | 51179 | 344 | 2 |
130047 | 130047 | 2020-05-09 | Stafford | Virginia | 51179 | 354 | 2 |
133037 | 133037 | 2020-05-10 | Stafford | Virginia | 51179 | 374 | 2 |
136027 | 136027 | 2020-05-11 | Stafford | Virginia | 51179 | 384 | 2 |
139018 | 139018 | 2020-05-12 | Stafford | Virginia | 51179 | 396 | 4 |
142014 | 142014 | 2020-05-13 | Stafford | Virginia | 51179 | 413 | 4 |
145011 | 145011 | 2020-05-14 | Stafford | Virginia | 51179 | 426 | 4 |
148014 | 148014 | 2020-05-15 | Stafford | Virginia | 51179 | 442 | 4 |
151023 | 151023 | 2020-05-16 | Stafford | Virginia | 51179 | 458 | 4 |
154034 | 154034 | 2020-05-17 | Stafford | Virginia | 51179 | 467 | 4 |
157051 | 157051 | 2020-05-18 | Stafford | Virginia | 51179 | 484 | 4 |
160075 | 160075 | 2020-05-19 | Stafford | Virginia | 51179 | 501 | 4 |
163103 | 163103 | 2020-05-20 | Stafford | Virginia | 51179 | 514 | 4 |
166132 | 166132 | 2020-05-21 | Stafford | Virginia | 51179 | 540 | 4 |
169168 | 169168 | 2020-05-22 | Stafford | Virginia | 51179 | 552 | 4 |
172209 | 172209 | 2020-05-23 | Stafford | Virginia | 51179 | 569 | 4 |
175252 | 175252 | 2020-05-24 | Stafford | Virginia | 51179 | 581 | 4 |
178297 | 178297 | 2020-05-25 | Stafford | Virginia | 51179 | 599 | 4 |
181341 | 181341 | 2020-05-26 | Stafford | Virginia | 51179 | 642 | 4 |
184392 | 184392 | 2020-05-27 | Stafford | Virginia | 51179 | 657 | 4 |
187449 | 187449 | 2020-05-28 | Stafford | Virginia | 51179 | 672 | 4 |
190513 | 190513 | 2020-05-29 | Stafford | Virginia | 51179 | 681 | 4 |
193579 | 193579 | 2020-05-30 | Stafford | Virginia | 51179 | 702 | 4 |
196649 | 196649 | 2020-05-31 | Stafford | Virginia | 51179 | 713 | 4 |
199722 | 199722 | 2020-06-01 | Stafford | Virginia | 51179 | 722 | 5 |
202798 | 202798 | 2020-06-02 | Stafford | Virginia | 51179 | 733 | 5 |
205877 | 205877 | 2020-06-03 | Stafford | Virginia | 51179 | 738 | 5 |
208959 | 208959 | 2020-06-04 | Stafford | Virginia | 51179 | 742 | 5 |
212044 | 212044 | 2020-06-05 | Stafford | Virginia | 51179 | 750 | 5 |
215131 | 215131 | 2020-06-06 | Stafford | Virginia | 51179 | 765 | 5 |
218221 | 218221 | 2020-06-07 | Stafford | Virginia | 51179 | 803 | 5 |
221313 | 221313 | 2020-06-08 | Stafford | Virginia | 51179 | 815 | 5 |
224409 | 224409 | 2020-06-09 | Stafford | Virginia | 51179 | 824 | 5 |
227509 | 227509 | 2020-06-10 | Stafford | Virginia | 51179 | 831 | 5 |
230613 | 230613 | 2020-06-11 | Stafford | Virginia | 51179 | 841 | 5 |
233718 | 233718 | 2020-06-12 | Stafford | Virginia | 51179 | 862 | 5 |
236825 | 236825 | 2020-06-13 | Stafford | Virginia | 51179 | 877 | 5 |
239933 | 239933 | 2020-06-14 | Stafford | Virginia | 51179 | 887 | 5 |
243044 | 243044 | 2020-06-15 | Stafford | Virginia | 51179 | 893 | 5 |
246157 | 246157 | 2020-06-16 | Stafford | Virginia | 51179 | 900 | 5 |
249269 | 249269 | 2020-06-17 | Stafford | Virginia | 51179 | 906 | 5 |
252384 | 252384 | 2020-06-18 | Stafford | Virginia | 51179 | 917 | 5 |
255503 | 255503 | 2020-06-19 | Stafford | Virginia | 51179 | 921 | 5 |
258630 | 258630 | 2020-06-20 | Stafford | Virginia | 51179 | 920 | 5 |
261757 | 261757 | 2020-06-21 | Stafford | Virginia | 51179 | 924 | 5 |
264886 | 264886 | 2020-06-22 | Stafford | Virginia | 51179 | 930 | 5 |
268015 | 268015 | 2020-06-23 | Stafford | Virginia | 51179 | 936 | 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);