ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
1,577 rows where county = "Mecklenburg" sorted by date
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date, deaths, date (date)
Link | rowid | date ▼ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1533 | 1533 | 2020-03-12 | Mecklenburg | North Carolina | 37119 | 2 | 0 |
1827 | 1827 | 2020-03-13 | Mecklenburg | North Carolina | 37119 | 2 | 0 |
2181 | 2181 | 2020-03-14 | Mecklenburg | North Carolina | 37119 | 2 | 0 |
2593 | 2593 | 2020-03-15 | Mecklenburg | North Carolina | 37119 | 4 | 0 |
3055 | 3055 | 2020-03-16 | Mecklenburg | North Carolina | 37119 | 4 | 0 |
3575 | 3575 | 2020-03-17 | Mecklenburg | North Carolina | 37119 | 7 | 0 |
4182 | 4182 | 2020-03-18 | Mecklenburg | North Carolina | 37119 | 11 | 0 |
4913 | 4913 | 2020-03-19 | Mecklenburg | North Carolina | 37119 | 13 | 0 |
5767 | 5767 | 2020-03-20 | Mecklenburg | North Carolina | 37119 | 28 | 0 |
6764 | 6764 | 2020-03-21 | Mecklenburg | North Carolina | 37119 | 41 | 0 |
7031 | 7031 | 2020-03-21 | Mecklenburg | Virginia | 51117 | 1 | 0 |
7866 | 7866 | 2020-03-22 | Mecklenburg | North Carolina | 37119 | 66 | 0 |
8167 | 8167 | 2020-03-22 | Mecklenburg | Virginia | 51117 | 1 | 0 |
9067 | 9067 | 2020-03-23 | Mecklenburg | North Carolina | 37119 | 80 | 0 |
9389 | 9389 | 2020-03-23 | Mecklenburg | Virginia | 51117 | 1 | 0 |
10375 | 10375 | 2020-03-24 | Mecklenburg | North Carolina | 37119 | 104 | 0 |
10737 | 10737 | 2020-03-24 | Mecklenburg | Virginia | 51117 | 2 | 0 |
11819 | 11819 | 2020-03-25 | Mecklenburg | North Carolina | 37119 | 170 | 0 |
12254 | 12254 | 2020-03-25 | Mecklenburg | Virginia | 51117 | 3 | 0 |
13423 | 13423 | 2020-03-26 | Mecklenburg | North Carolina | 37119 | 181 | 0 |
13896 | 13896 | 2020-03-26 | Mecklenburg | Virginia | 51117 | 4 | 0 |
15158 | 15158 | 2020-03-27 | Mecklenburg | North Carolina | 37119 | 218 | 0 |
15664 | 15664 | 2020-03-27 | Mecklenburg | Virginia | 51117 | 4 | 0 |
16990 | 16990 | 2020-03-28 | Mecklenburg | North Carolina | 37119 | 299 | 0 |
17540 | 17540 | 2020-03-28 | Mecklenburg | Virginia | 51117 | 4 | 0 |
18921 | 18921 | 2020-03-29 | Mecklenburg | North Carolina | 37119 | 336 | 1 |
19502 | 19502 | 2020-03-29 | Mecklenburg | Virginia | 51117 | 4 | 0 |
20961 | 20961 | 2020-03-30 | Mecklenburg | North Carolina | 37119 | 382 | 1 |
21567 | 21567 | 2020-03-30 | Mecklenburg | Virginia | 51117 | 4 | 0 |
23088 | 23088 | 2020-03-31 | Mecklenburg | North Carolina | 37119 | 420 | 1 |
23713 | 23713 | 2020-03-31 | Mecklenburg | Virginia | 51117 | 4 | 0 |
25282 | 25282 | 2020-04-01 | Mecklenburg | North Carolina | 37119 | 444 | 2 |
25929 | 25929 | 2020-04-01 | Mecklenburg | Virginia | 51117 | 4 | 0 |
27546 | 27546 | 2020-04-02 | Mecklenburg | North Carolina | 37119 | 495 | 2 |
28219 | 28219 | 2020-04-02 | Mecklenburg | Virginia | 51117 | 5 | 0 |
29873 | 29873 | 2020-04-03 | Mecklenburg | North Carolina | 37119 | 564 | 2 |
30566 | 30566 | 2020-04-03 | Mecklenburg | Virginia | 51117 | 7 | 0 |
32260 | 32260 | 2020-04-04 | Mecklenburg | North Carolina | 37119 | 635 | 4 |
32965 | 32965 | 2020-04-04 | Mecklenburg | Virginia | 51117 | 8 | 0 |
34691 | 34691 | 2020-04-05 | Mecklenburg | North Carolina | 37119 | 664 | 6 |
35403 | 35403 | 2020-04-05 | Mecklenburg | Virginia | 51117 | 12 | 0 |
37160 | 37160 | 2020-04-06 | Mecklenburg | North Carolina | 37119 | 733 | 7 |
37886 | 37886 | 2020-04-06 | Mecklenburg | Virginia | 51117 | 12 | 0 |
39675 | 39675 | 2020-04-07 | Mecklenburg | North Carolina | 37119 | 810 | 8 |
40420 | 40420 | 2020-04-07 | Mecklenburg | Virginia | 51117 | 12 | 0 |
42232 | 42232 | 2020-04-08 | Mecklenburg | North Carolina | 37119 | 830 | 10 |
42989 | 42989 | 2020-04-08 | Mecklenburg | Virginia | 51117 | 16 | 0 |
44816 | 44816 | 2020-04-09 | Mecklenburg | North Carolina | 37119 | 861 | 10 |
45584 | 45584 | 2020-04-09 | Mecklenburg | Virginia | 51117 | 25 | 0 |
47429 | 47429 | 2020-04-10 | Mecklenburg | North Carolina | 37119 | 906 | 10 |
48210 | 48210 | 2020-04-10 | Mecklenburg | Virginia | 51117 | 48 | 0 |
50084 | 50084 | 2020-04-11 | Mecklenburg | North Carolina | 37119 | 935 | 12 |
50868 | 50868 | 2020-04-11 | Mecklenburg | Virginia | 51117 | 53 | 0 |
52757 | 52757 | 2020-04-12 | Mecklenburg | North Carolina | 37119 | 954 | 12 |
53543 | 53543 | 2020-04-12 | Mecklenburg | Virginia | 51117 | 55 | 0 |
55441 | 55441 | 2020-04-13 | Mecklenburg | North Carolina | 37119 | 970 | 12 |
56233 | 56233 | 2020-04-13 | Mecklenburg | Virginia | 51117 | 57 | 0 |
58141 | 58141 | 2020-04-14 | Mecklenburg | North Carolina | 37119 | 993 | 15 |
58939 | 58939 | 2020-04-14 | Mecklenburg | Virginia | 51117 | 57 | 0 |
60855 | 60855 | 2020-04-15 | Mecklenburg | North Carolina | 37119 | 1015 | 19 |
61658 | 61658 | 2020-04-15 | Mecklenburg | Virginia | 51117 | 57 | 0 |
63581 | 63581 | 2020-04-16 | Mecklenburg | North Carolina | 37119 | 1084 | 19 |
64391 | 64391 | 2020-04-16 | Mecklenburg | Virginia | 51117 | 61 | 0 |
66324 | 66324 | 2020-04-17 | Mecklenburg | North Carolina | 37119 | 1136 | 21 |
67139 | 67139 | 2020-04-17 | Mecklenburg | Virginia | 51117 | 62 | 0 |
69081 | 69081 | 2020-04-18 | Mecklenburg | North Carolina | 37119 | 1153 | 24 |
69901 | 69901 | 2020-04-18 | Mecklenburg | Virginia | 51117 | 64 | 0 |
71847 | 71847 | 2020-04-19 | Mecklenburg | North Carolina | 37119 | 1178 | 29 |
72671 | 72671 | 2020-04-19 | Mecklenburg | Virginia | 51117 | 65 | 0 |
74622 | 74622 | 2020-04-20 | Mecklenburg | North Carolina | 37119 | 1210 | 29 |
75447 | 75447 | 2020-04-20 | Mecklenburg | Virginia | 51117 | 65 | 0 |
77403 | 77403 | 2020-04-21 | Mecklenburg | North Carolina | 37119 | 1245 | 32 |
78229 | 78229 | 2020-04-21 | Mecklenburg | Virginia | 51117 | 68 | 1 |
80192 | 80192 | 2020-04-22 | Mecklenburg | North Carolina | 37119 | 1284 | 33 |
81022 | 81022 | 2020-04-22 | Mecklenburg | Virginia | 51117 | 69 | 1 |
82991 | 82991 | 2020-04-23 | Mecklenburg | North Carolina | 37119 | 1362 | 33 |
83823 | 83823 | 2020-04-23 | Mecklenburg | Virginia | 51117 | 71 | 1 |
85795 | 85795 | 2020-04-24 | Mecklenburg | North Carolina | 37119 | 1407 | 35 |
86630 | 86630 | 2020-04-24 | Mecklenburg | Virginia | 51117 | 74 | 7 |
88608 | 88608 | 2020-04-25 | Mecklenburg | North Carolina | 37119 | 1450 | 41 |
89445 | 89445 | 2020-04-25 | Mecklenburg | Virginia | 51117 | 85 | 9 |
91423 | 91423 | 2020-04-26 | Mecklenburg | North Carolina | 37119 | 1482 | 41 |
92262 | 92262 | 2020-04-26 | Mecklenburg | Virginia | 51117 | 94 | 9 |
94249 | 94249 | 2020-04-27 | Mecklenburg | North Carolina | 37119 | 1492 | 43 |
95091 | 95091 | 2020-04-27 | Mecklenburg | Virginia | 51117 | 98 | 9 |
97086 | 97086 | 2020-04-28 | Mecklenburg | North Carolina | 37119 | 1519 | 43 |
97935 | 97935 | 2020-04-28 | Mecklenburg | Virginia | 51117 | 100 | 9 |
99934 | 99934 | 2020-04-29 | Mecklenburg | North Carolina | 37119 | 1567 | 44 |
100785 | 100785 | 2020-04-29 | Mecklenburg | Virginia | 51117 | 100 | 10 |
102787 | 102787 | 2020-04-30 | Mecklenburg | North Carolina | 37119 | 1627 | 49 |
103640 | 103640 | 2020-04-30 | Mecklenburg | Virginia | 51117 | 100 | 10 |
105649 | 105649 | 2020-05-01 | Mecklenburg | North Carolina | 37119 | 1651 | 49 |
106504 | 106504 | 2020-05-01 | Mecklenburg | Virginia | 51117 | 103 | 10 |
108516 | 108516 | 2020-05-02 | Mecklenburg | North Carolina | 37119 | 1699 | 50 |
109373 | 109373 | 2020-05-02 | Mecklenburg | Virginia | 51117 | 104 | 10 |
111389 | 111389 | 2020-05-03 | Mecklenburg | North Carolina | 37119 | 1724 | 51 |
112247 | 112247 | 2020-05-03 | Mecklenburg | Virginia | 51117 | 106 | 10 |
114270 | 114270 | 2020-05-04 | Mecklenburg | North Carolina | 37119 | 1734 | 54 |
115130 | 115130 | 2020-05-04 | Mecklenburg | Virginia | 51117 | 106 | 10 |
117150 | 117150 | 2020-05-05 | Mecklenburg | North Carolina | 37119 | 1758 | 55 |
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);