ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
2,337 rows where county = "Bedford" sorted by deaths
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date, deaths, date (date)
state 3
- Virginia 783
- Tennessee 780
- Pennsylvania 774
county 1
- Bedford · 2,337 ✖
Link | rowid | date | county | state | fips | cases | deaths ▼ |
---|---|---|---|---|---|---|---|
8148 | 8148 | 2020-03-22 | Bedford | Virginia | 51019 | 1 | 0 |
9369 | 9369 | 2020-03-23 | Bedford | Virginia | 51019 | 1 | 0 |
10715 | 10715 | 2020-03-24 | Bedford | Virginia | 51019 | 1 | 0 |
12059 | 12059 | 2020-03-25 | Bedford | Tennessee | 47003 | 1 | 0 |
12227 | 12227 | 2020-03-25 | Bedford | Virginia | 51019 | 2 | 0 |
13681 | 13681 | 2020-03-26 | Bedford | Tennessee | 47003 | 1 | 0 |
13864 | 13864 | 2020-03-26 | Bedford | Virginia | 51019 | 2 | 0 |
15433 | 15433 | 2020-03-27 | Bedford | Tennessee | 47003 | 1 | 0 |
15630 | 15630 | 2020-03-27 | Bedford | Virginia | 51019 | 2 | 0 |
17292 | 17292 | 2020-03-28 | Bedford | Tennessee | 47003 | 1 | 0 |
17504 | 17504 | 2020-03-28 | Bedford | Virginia | 51019 | 2 | 0 |
19237 | 19237 | 2020-03-29 | Bedford | Tennessee | 47003 | 1 | 0 |
19464 | 19464 | 2020-03-29 | Bedford | Virginia | 51019 | 2 | 0 |
21290 | 21290 | 2020-03-30 | Bedford | Tennessee | 47003 | 1 | 0 |
21527 | 21527 | 2020-03-30 | Bedford | Virginia | 51019 | 2 | 0 |
23292 | 23292 | 2020-03-31 | Bedford | Pennsylvania | 42009 | 2 | 0 |
23428 | 23428 | 2020-03-31 | Bedford | Tennessee | 47003 | 2 | 0 |
23666 | 23666 | 2020-03-31 | Bedford | Virginia | 51019 | 2 | 0 |
25490 | 25490 | 2020-04-01 | Bedford | Pennsylvania | 42009 | 3 | 0 |
25626 | 25626 | 2020-04-01 | Bedford | Tennessee | 47003 | 4 | 0 |
25882 | 25882 | 2020-04-01 | Bedford | Virginia | 51019 | 3 | 0 |
27762 | 27762 | 2020-04-02 | Bedford | Pennsylvania | 42009 | 3 | 0 |
27904 | 27904 | 2020-04-02 | Bedford | Tennessee | 47003 | 6 | 0 |
28171 | 28171 | 2020-04-02 | Bedford | Virginia | 51019 | 3 | 0 |
30095 | 30095 | 2020-04-03 | Bedford | Pennsylvania | 42009 | 3 | 0 |
30239 | 30239 | 2020-04-03 | Bedford | Tennessee | 47003 | 6 | 0 |
30514 | 30514 | 2020-04-03 | Bedford | Virginia | 51019 | 3 | 0 |
32485 | 32485 | 2020-04-04 | Bedford | Pennsylvania | 42009 | 4 | 0 |
32630 | 32630 | 2020-04-04 | Bedford | Tennessee | 47003 | 8 | 0 |
32912 | 32912 | 2020-04-04 | Bedford | Virginia | 51019 | 4 | 0 |
34920 | 34920 | 2020-04-05 | Bedford | Pennsylvania | 42009 | 4 | 0 |
35066 | 35066 | 2020-04-05 | Bedford | Tennessee | 47003 | 8 | 0 |
35350 | 35350 | 2020-04-05 | Bedford | Virginia | 51019 | 4 | 0 |
37395 | 37395 | 2020-04-06 | Bedford | Pennsylvania | 42009 | 4 | 0 |
37542 | 37542 | 2020-04-06 | Bedford | Tennessee | 47003 | 8 | 0 |
37832 | 37832 | 2020-04-06 | Bedford | Virginia | 51019 | 5 | 0 |
39916 | 39916 | 2020-04-07 | Bedford | Pennsylvania | 42009 | 4 | 0 |
40065 | 40065 | 2020-04-07 | Bedford | Tennessee | 47003 | 10 | 0 |
40362 | 40362 | 2020-04-07 | Bedford | Virginia | 51019 | 8 | 0 |
42476 | 42476 | 2020-04-08 | Bedford | Pennsylvania | 42009 | 4 | 0 |
42626 | 42626 | 2020-04-08 | Bedford | Tennessee | 47003 | 12 | 0 |
42931 | 42931 | 2020-04-08 | Bedford | Virginia | 51019 | 12 | 0 |
45062 | 45062 | 2020-04-09 | Bedford | Pennsylvania | 42009 | 4 | 0 |
45213 | 45213 | 2020-04-09 | Bedford | Tennessee | 47003 | 14 | 0 |
45525 | 45525 | 2020-04-09 | Bedford | Virginia | 51019 | 12 | 0 |
47679 | 47679 | 2020-04-10 | Bedford | Pennsylvania | 42009 | 3 | 0 |
48149 | 48149 | 2020-04-10 | Bedford | Virginia | 51019 | 15 | 0 |
50807 | 50807 | 2020-04-11 | Bedford | Virginia | 51019 | 15 | 0 |
53482 | 53482 | 2020-04-12 | Bedford | Virginia | 51019 | 15 | 0 |
56171 | 56171 | 2020-04-13 | Bedford | Virginia | 51019 | 16 | 0 |
58877 | 58877 | 2020-04-14 | Bedford | Virginia | 51019 | 16 | 0 |
61596 | 61596 | 2020-04-15 | Bedford | Virginia | 51019 | 16 | 0 |
64328 | 64328 | 2020-04-16 | Bedford | Virginia | 51019 | 16 | 0 |
67076 | 67076 | 2020-04-17 | Bedford | Virginia | 51019 | 17 | 0 |
69838 | 69838 | 2020-04-18 | Bedford | Virginia | 51019 | 17 | 0 |
72608 | 72608 | 2020-04-19 | Bedford | Virginia | 51019 | 18 | 0 |
75384 | 75384 | 2020-04-20 | Bedford | Virginia | 51019 | 18 | 0 |
78166 | 78166 | 2020-04-21 | Bedford | Virginia | 51019 | 19 | 0 |
80958 | 80958 | 2020-04-22 | Bedford | Virginia | 51019 | 20 | 0 |
83759 | 83759 | 2020-04-23 | Bedford | Virginia | 51019 | 21 | 0 |
86566 | 86566 | 2020-04-24 | Bedford | Virginia | 51019 | 23 | 0 |
89381 | 89381 | 2020-04-25 | Bedford | Virginia | 51019 | 24 | 0 |
92198 | 92198 | 2020-04-26 | Bedford | Virginia | 51019 | 24 | 0 |
95027 | 95027 | 2020-04-27 | Bedford | Virginia | 51019 | 25 | 0 |
97869 | 97869 | 2020-04-28 | Bedford | Virginia | 51019 | 25 | 0 |
100719 | 100719 | 2020-04-29 | Bedford | Virginia | 51019 | 27 | 0 |
103574 | 103574 | 2020-04-30 | Bedford | Virginia | 51019 | 30 | 0 |
106438 | 106438 | 2020-05-01 | Bedford | Virginia | 51019 | 33 | 0 |
109307 | 109307 | 2020-05-02 | Bedford | Virginia | 51019 | 34 | 0 |
112181 | 112181 | 2020-05-03 | Bedford | Virginia | 51019 | 34 | 0 |
115064 | 115064 | 2020-05-04 | Bedford | Virginia | 51019 | 35 | 0 |
118023 | 118023 | 2020-05-05 | Bedford | Virginia | 51019 | 36 | 0 |
120987 | 120987 | 2020-05-06 | Bedford | Virginia | 51019 | 36 | 0 |
47831 | 47831 | 2020-04-10 | Bedford | Tennessee | 47003 | 15 | 1 |
50336 | 50336 | 2020-04-11 | Bedford | Pennsylvania | 42009 | 5 | 1 |
50489 | 50489 | 2020-04-11 | Bedford | Tennessee | 47003 | 17 | 1 |
53009 | 53009 | 2020-04-12 | Bedford | Pennsylvania | 42009 | 5 | 1 |
53164 | 53164 | 2020-04-12 | Bedford | Tennessee | 47003 | 17 | 1 |
55694 | 55694 | 2020-04-13 | Bedford | Pennsylvania | 42009 | 5 | 1 |
55850 | 55850 | 2020-04-13 | Bedford | Tennessee | 47003 | 23 | 1 |
58397 | 58397 | 2020-04-14 | Bedford | Pennsylvania | 42009 | 5 | 1 |
61112 | 61112 | 2020-04-15 | Bedford | Pennsylvania | 42009 | 9 | 1 |
63838 | 63838 | 2020-04-16 | Bedford | Pennsylvania | 42009 | 11 | 1 |
66584 | 66584 | 2020-04-17 | Bedford | Pennsylvania | 42009 | 13 | 1 |
69342 | 69342 | 2020-04-18 | Bedford | Pennsylvania | 42009 | 14 | 1 |
72109 | 72109 | 2020-04-19 | Bedford | Pennsylvania | 42009 | 15 | 1 |
74884 | 74884 | 2020-04-20 | Bedford | Pennsylvania | 42009 | 15 | 1 |
77666 | 77666 | 2020-04-21 | Bedford | Pennsylvania | 42009 | 16 | 1 |
80456 | 80456 | 2020-04-22 | Bedford | Pennsylvania | 42009 | 16 | 1 |
83255 | 83255 | 2020-04-23 | Bedford | Pennsylvania | 42009 | 20 | 1 |
86059 | 86059 | 2020-04-24 | Bedford | Pennsylvania | 42009 | 21 | 1 |
88873 | 88873 | 2020-04-25 | Bedford | Pennsylvania | 42009 | 21 | 1 |
91689 | 91689 | 2020-04-26 | Bedford | Pennsylvania | 42009 | 21 | 1 |
94516 | 94516 | 2020-04-27 | Bedford | Pennsylvania | 42009 | 21 | 1 |
97355 | 97355 | 2020-04-28 | Bedford | Pennsylvania | 42009 | 22 | 1 |
100204 | 100204 | 2020-04-29 | Bedford | Pennsylvania | 42009 | 24 | 1 |
103057 | 103057 | 2020-04-30 | Bedford | Pennsylvania | 42009 | 24 | 1 |
105920 | 105920 | 2020-05-01 | Bedford | Pennsylvania | 42009 | 24 | 1 |
108787 | 108787 | 2020-05-02 | Bedford | Pennsylvania | 42009 | 24 | 1 |
111661 | 111661 | 2020-05-03 | Bedford | Pennsylvania | 42009 | 24 | 1 |
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);