ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
792 rows where county = "Harrisonburg city" and state = "Virginia" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
388890 | 388890 | 2020-07-31 | Harrisonburg city | Virginia | 51660 | 1039 | 29 |
385673 | 385673 | 2020-07-30 | Harrisonburg city | Virginia | 51660 | 1037 | 29 |
382455 | 382455 | 2020-07-29 | Harrisonburg city | Virginia | 51660 | 1037 | 29 |
379238 | 379238 | 2020-07-28 | Harrisonburg city | Virginia | 51660 | 1035 | 29 |
376022 | 376022 | 2020-07-27 | Harrisonburg city | Virginia | 51660 | 1028 | 29 |
372808 | 372808 | 2020-07-26 | Harrisonburg city | Virginia | 51660 | 1024 | 29 |
369596 | 369596 | 2020-07-25 | Harrisonburg city | Virginia | 51660 | 1021 | 29 |
366387 | 366387 | 2020-07-24 | Harrisonburg city | Virginia | 51660 | 1018 | 29 |
363181 | 363181 | 2020-07-23 | Harrisonburg city | Virginia | 51660 | 1015 | 29 |
359975 | 359975 | 2020-07-22 | Harrisonburg city | Virginia | 51660 | 1013 | 29 |
356770 | 356770 | 2020-07-21 | Harrisonburg city | Virginia | 51660 | 1010 | 29 |
353567 | 353567 | 2020-07-20 | Harrisonburg city | Virginia | 51660 | 1009 | 29 |
350365 | 350365 | 2020-07-19 | Harrisonburg city | Virginia | 51660 | 1006 | 29 |
347164 | 347164 | 2020-07-18 | Harrisonburg city | Virginia | 51660 | 1004 | 29 |
343964 | 343964 | 2020-07-17 | Harrisonburg city | Virginia | 51660 | 1001 | 29 |
340765 | 340765 | 2020-07-16 | Harrisonburg city | Virginia | 51660 | 999 | 29 |
337569 | 337569 | 2020-07-15 | Harrisonburg city | Virginia | 51660 | 996 | 29 |
334374 | 334374 | 2020-07-14 | Harrisonburg city | Virginia | 51660 | 992 | 28 |
331181 | 331181 | 2020-07-13 | Harrisonburg city | Virginia | 51660 | 988 | 28 |
327995 | 327995 | 2020-07-12 | Harrisonburg city | Virginia | 51660 | 979 | 28 |
324810 | 324810 | 2020-07-11 | Harrisonburg city | Virginia | 51660 | 978 | 28 |
321629 | 321629 | 2020-07-10 | Harrisonburg city | Virginia | 51660 | 976 | 28 |
318450 | 318450 | 2020-07-09 | Harrisonburg city | Virginia | 51660 | 975 | 28 |
315277 | 315277 | 2020-07-08 | Harrisonburg city | Virginia | 51660 | 972 | 28 |
312102 | 312102 | 2020-07-07 | Harrisonburg city | Virginia | 51660 | 967 | 28 |
308933 | 308933 | 2020-07-06 | Harrisonburg city | Virginia | 51660 | 966 | 27 |
305765 | 305765 | 2020-07-05 | Harrisonburg city | Virginia | 51660 | 966 | 27 |
302601 | 302601 | 2020-07-04 | Harrisonburg city | Virginia | 51660 | 963 | 27 |
299437 | 299437 | 2020-07-03 | Harrisonburg city | Virginia | 51660 | 957 | 27 |
296275 | 296275 | 2020-07-02 | Harrisonburg city | Virginia | 51660 | 941 | 26 |
293120 | 293120 | 2020-07-01 | Harrisonburg city | Virginia | 51660 | 937 | 24 |
289967 | 289967 | 2020-06-30 | Harrisonburg city | Virginia | 51660 | 939 | 24 |
286817 | 286817 | 2020-06-29 | Harrisonburg city | Virginia | 51660 | 936 | 24 |
283671 | 283671 | 2020-06-28 | Harrisonburg city | Virginia | 51660 | 933 | 24 |
280525 | 280525 | 2020-06-27 | Harrisonburg city | Virginia | 51660 | 925 | 23 |
277377 | 277377 | 2020-06-26 | Harrisonburg city | Virginia | 51660 | 913 | 23 |
274229 | 274229 | 2020-06-25 | Harrisonburg city | Virginia | 51660 | 907 | 23 |
271089 | 271089 | 2020-06-24 | Harrisonburg city | Virginia | 51660 | 901 | 23 |
267955 | 267955 | 2020-06-23 | Harrisonburg city | Virginia | 51660 | 896 | 23 |
264826 | 264826 | 2020-06-22 | Harrisonburg city | Virginia | 51660 | 893 | 23 |
261697 | 261697 | 2020-06-21 | Harrisonburg city | Virginia | 51660 | 889 | 23 |
258570 | 258570 | 2020-06-20 | Harrisonburg city | Virginia | 51660 | 885 | 23 |
255443 | 255443 | 2020-06-19 | Harrisonburg city | Virginia | 51660 | 874 | 23 |
252324 | 252324 | 2020-06-18 | Harrisonburg city | Virginia | 51660 | 870 | 23 |
249209 | 249209 | 2020-06-17 | Harrisonburg city | Virginia | 51660 | 864 | 23 |
246097 | 246097 | 2020-06-16 | Harrisonburg city | Virginia | 51660 | 859 | 22 |
242984 | 242984 | 2020-06-15 | Harrisonburg city | Virginia | 51660 | 856 | 23 |
239873 | 239873 | 2020-06-14 | Harrisonburg city | Virginia | 51660 | 855 | 23 |
236765 | 236765 | 2020-06-13 | Harrisonburg city | Virginia | 51660 | 847 | 23 |
233658 | 233658 | 2020-06-12 | Harrisonburg city | Virginia | 51660 | 850 | 23 |
230553 | 230553 | 2020-06-11 | Harrisonburg city | Virginia | 51660 | 846 | 23 |
227449 | 227449 | 2020-06-10 | Harrisonburg city | Virginia | 51660 | 842 | 23 |
224349 | 224349 | 2020-06-09 | Harrisonburg city | Virginia | 51660 | 837 | 23 |
221253 | 221253 | 2020-06-08 | Harrisonburg city | Virginia | 51660 | 833 | 23 |
218161 | 218161 | 2020-06-07 | Harrisonburg city | Virginia | 51660 | 832 | 23 |
215071 | 215071 | 2020-06-06 | Harrisonburg city | Virginia | 51660 | 823 | 23 |
211984 | 211984 | 2020-06-05 | Harrisonburg city | Virginia | 51660 | 817 | 23 |
208899 | 208899 | 2020-06-04 | Harrisonburg city | Virginia | 51660 | 814 | 23 |
205817 | 205817 | 2020-06-03 | Harrisonburg city | Virginia | 51660 | 809 | 23 |
202738 | 202738 | 2020-06-02 | Harrisonburg city | Virginia | 51660 | 799 | 23 |
199662 | 199662 | 2020-06-01 | Harrisonburg city | Virginia | 51660 | 797 | 23 |
196589 | 196589 | 2020-05-31 | Harrisonburg city | Virginia | 51660 | 779 | 23 |
193519 | 193519 | 2020-05-30 | Harrisonburg city | Virginia | 51660 | 774 | 23 |
190453 | 190453 | 2020-05-29 | Harrisonburg city | Virginia | 51660 | 765 | 23 |
187389 | 187389 | 2020-05-28 | Harrisonburg city | Virginia | 51660 | 757 | 23 |
184332 | 184332 | 2020-05-27 | Harrisonburg city | Virginia | 51660 | 746 | 21 |
181281 | 181281 | 2020-05-26 | Harrisonburg city | Virginia | 51660 | 742 | 21 |
178237 | 178237 | 2020-05-25 | Harrisonburg city | Virginia | 51660 | 727 | 21 |
175192 | 175192 | 2020-05-24 | Harrisonburg city | Virginia | 51660 | 716 | 21 |
172149 | 172149 | 2020-05-23 | Harrisonburg city | Virginia | 51660 | 709 | 21 |
169108 | 169108 | 2020-05-22 | Harrisonburg city | Virginia | 51660 | 704 | 21 |
166072 | 166072 | 2020-05-21 | Harrisonburg city | Virginia | 51660 | 695 | 21 |
163043 | 163043 | 2020-05-20 | Harrisonburg city | Virginia | 51660 | 675 | 21 |
160015 | 160015 | 2020-05-19 | Harrisonburg city | Virginia | 51660 | 647 | 21 |
156991 | 156991 | 2020-05-18 | Harrisonburg city | Virginia | 51660 | 633 | 21 |
153974 | 153974 | 2020-05-17 | Harrisonburg city | Virginia | 51660 | 632 | 21 |
150963 | 150963 | 2020-05-16 | Harrisonburg city | Virginia | 51660 | 631 | 21 |
147954 | 147954 | 2020-05-15 | Harrisonburg city | Virginia | 51660 | 620 | 21 |
144951 | 144951 | 2020-05-14 | Harrisonburg city | Virginia | 51660 | 615 | 21 |
141954 | 141954 | 2020-05-13 | Harrisonburg city | Virginia | 51660 | 607 | 21 |
138958 | 138958 | 2020-05-12 | Harrisonburg city | Virginia | 51660 | 584 | 21 |
135967 | 135967 | 2020-05-11 | Harrisonburg city | Virginia | 51660 | 583 | 21 |
132977 | 132977 | 2020-05-10 | Harrisonburg city | Virginia | 51660 | 579 | 21 |
129987 | 129987 | 2020-05-09 | Harrisonburg city | Virginia | 51660 | 578 | 21 |
126997 | 126997 | 2020-05-08 | Harrisonburg city | Virginia | 51660 | 574 | 21 |
124012 | 124012 | 2020-05-07 | Harrisonburg city | Virginia | 51660 | 552 | 20 |
121031 | 121031 | 2020-05-06 | Harrisonburg city | Virginia | 51660 | 525 | 19 |
118067 | 118067 | 2020-05-05 | Harrisonburg city | Virginia | 51660 | 525 | 19 |
115108 | 115108 | 2020-05-04 | Harrisonburg city | Virginia | 51660 | 497 | 16 |
112225 | 112225 | 2020-05-03 | Harrisonburg city | Virginia | 51660 | 478 | 16 |
109351 | 109351 | 2020-05-02 | Harrisonburg city | Virginia | 51660 | 470 | 15 |
106482 | 106482 | 2020-05-01 | Harrisonburg city | Virginia | 51660 | 456 | 11 |
103618 | 103618 | 2020-04-30 | Harrisonburg city | Virginia | 51660 | 426 | 11 |
100763 | 100763 | 2020-04-29 | Harrisonburg city | Virginia | 51660 | 411 | 11 |
97913 | 97913 | 2020-04-28 | Harrisonburg city | Virginia | 51660 | 406 | 9 |
95070 | 95070 | 2020-04-27 | Harrisonburg city | Virginia | 51660 | 383 | 9 |
92241 | 92241 | 2020-04-26 | Harrisonburg city | Virginia | 51660 | 371 | 9 |
89424 | 89424 | 2020-04-25 | Harrisonburg city | Virginia | 51660 | 370 | 9 |
86609 | 86609 | 2020-04-24 | Harrisonburg city | Virginia | 51660 | 355 | 9 |
83802 | 83802 | 2020-04-23 | Harrisonburg city | Virginia | 51660 | 346 | 8 |
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);