ny_times_us_states
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
1,020 rows where state = "Guam" sorted by state
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
state 1
- Guam · 1,020 ✖
Link | rowid | date | state ▼ | fips | cases | deaths |
---|---|---|---|---|---|---|
701 | 701 | 2020-03-15 | Guam | 66 | 3 | 0 |
754 | 754 | 2020-03-16 | Guam | 66 | 3 | 0 |
807 | 807 | 2020-03-17 | Guam | 66 | 3 | 0 |
861 | 861 | 2020-03-18 | Guam | 66 | 8 | 0 |
915 | 915 | 2020-03-19 | Guam | 66 | 12 | 0 |
969 | 969 | 2020-03-20 | Guam | 66 | 14 | 0 |
1023 | 1023 | 2020-03-21 | Guam | 66 | 15 | 0 |
1077 | 1077 | 2020-03-22 | Guam | 66 | 27 | 1 |
1131 | 1131 | 2020-03-23 | Guam | 66 | 29 | 1 |
1185 | 1185 | 2020-03-24 | Guam | 66 | 32 | 1 |
1239 | 1239 | 2020-03-25 | Guam | 66 | 32 | 1 |
1293 | 1293 | 2020-03-26 | Guam | 66 | 49 | 1 |
1347 | 1347 | 2020-03-27 | Guam | 66 | 53 | 1 |
1401 | 1401 | 2020-03-28 | Guam | 66 | 57 | 1 |
1456 | 1456 | 2020-03-29 | Guam | 66 | 58 | 1 |
1511 | 1511 | 2020-03-30 | Guam | 66 | 60 | 1 |
1566 | 1566 | 2020-03-31 | Guam | 66 | 139 | 2 |
1621 | 1621 | 2020-04-01 | Guam | 66 | 147 | 3 |
1676 | 1676 | 2020-04-02 | Guam | 66 | 152 | 3 |
1731 | 1731 | 2020-04-03 | Guam | 66 | 154 | 4 |
1786 | 1786 | 2020-04-04 | Guam | 66 | 223 | 4 |
1841 | 1841 | 2020-04-05 | Guam | 66 | 265 | 4 |
1896 | 1896 | 2020-04-06 | Guam | 66 | 266 | 4 |
1951 | 1951 | 2020-04-07 | Guam | 66 | 274 | 4 |
2006 | 2006 | 2020-04-08 | Guam | 66 | 409 | 4 |
2061 | 2061 | 2020-04-09 | Guam | 66 | 542 | 4 |
2116 | 2116 | 2020-04-10 | Guam | 66 | 577 | 4 |
2171 | 2171 | 2020-04-11 | Guam | 66 | 681 | 5 |
2226 | 2226 | 2020-04-12 | Guam | 66 | 716 | 5 |
2281 | 2281 | 2020-04-13 | Guam | 66 | 719 | 6 |
2336 | 2336 | 2020-04-14 | Guam | 66 | 721 | 6 |
2391 | 2391 | 2020-04-15 | Guam | 66 | 750 | 6 |
2446 | 2446 | 2020-04-16 | Guam | 66 | 790 | 6 |
2501 | 2501 | 2020-04-17 | Guam | 66 | 796 | 6 |
2556 | 2556 | 2020-04-18 | Guam | 66 | 805 | 6 |
2611 | 2611 | 2020-04-19 | Guam | 66 | 808 | 6 |
2666 | 2666 | 2020-04-20 | Guam | 66 | 811 | 6 |
2721 | 2721 | 2020-04-21 | Guam | 66 | 852 | 6 |
2776 | 2776 | 2020-04-22 | Guam | 66 | 911 | 6 |
2831 | 2831 | 2020-04-23 | Guam | 66 | 979 | 6 |
2886 | 2886 | 2020-04-24 | Guam | 66 | 997 | 6 |
2941 | 2941 | 2020-04-25 | Guam | 66 | 997 | 6 |
2996 | 2996 | 2020-04-26 | Guam | 66 | 997 | 6 |
3051 | 3051 | 2020-04-27 | Guam | 66 | 1113 | 6 |
3106 | 3106 | 2020-04-28 | Guam | 66 | 1114 | 6 |
3161 | 3161 | 2020-04-29 | Guam | 66 | 1114 | 6 |
3216 | 3216 | 2020-04-30 | Guam | 66 | 1115 | 6 |
3271 | 3271 | 2020-05-01 | Guam | 66 | 1115 | 6 |
3326 | 3326 | 2020-05-02 | Guam | 66 | 1117 | 6 |
3381 | 3381 | 2020-05-03 | Guam | 66 | 1118 | 6 |
3436 | 3436 | 2020-05-04 | Guam | 66 | 1118 | 6 |
3491 | 3491 | 2020-05-05 | Guam | 66 | 1118 | 6 |
3546 | 3546 | 2020-05-06 | Guam | 66 | 1118 | 6 |
3601 | 3601 | 2020-05-07 | Guam | 66 | 1118 | 6 |
3656 | 3656 | 2020-05-08 | Guam | 66 | 1120 | 6 |
3711 | 3711 | 2020-05-09 | Guam | 66 | 1120 | 6 |
3766 | 3766 | 2020-05-10 | Guam | 66 | 1120 | 6 |
3821 | 3821 | 2020-05-11 | Guam | 66 | 1120 | 6 |
3876 | 3876 | 2020-05-12 | Guam | 66 | 1121 | 6 |
3931 | 3931 | 2020-05-13 | Guam | 66 | 1121 | 6 |
3986 | 3986 | 2020-05-14 | Guam | 66 | 1121 | 6 |
4041 | 4041 | 2020-05-15 | Guam | 66 | 1123 | 6 |
4096 | 4096 | 2020-05-16 | Guam | 66 | 1123 | 6 |
4151 | 4151 | 2020-05-17 | Guam | 66 | 1123 | 6 |
4206 | 4206 | 2020-05-18 | Guam | 66 | 1123 | 6 |
4261 | 4261 | 2020-05-19 | Guam | 66 | 1123 | 6 |
4316 | 4316 | 2020-05-20 | Guam | 66 | 1134 | 6 |
4371 | 4371 | 2020-05-21 | Guam | 66 | 1134 | 6 |
4426 | 4426 | 2020-05-22 | Guam | 66 | 1134 | 6 |
4481 | 4481 | 2020-05-23 | Guam | 66 | 1134 | 6 |
4536 | 4536 | 2020-05-24 | Guam | 66 | 1135 | 6 |
4591 | 4591 | 2020-05-25 | Guam | 66 | 1135 | 6 |
4646 | 4646 | 2020-05-26 | Guam | 66 | 1139 | 6 |
4701 | 4701 | 2020-05-27 | Guam | 66 | 1140 | 6 |
4756 | 4756 | 2020-05-28 | Guam | 66 | 1141 | 6 |
4811 | 4811 | 2020-05-29 | Guam | 66 | 1141 | 6 |
4866 | 4866 | 2020-05-30 | Guam | 66 | 1141 | 6 |
4921 | 4921 | 2020-05-31 | Guam | 66 | 1144 | 6 |
4976 | 4976 | 2020-06-01 | Guam | 66 | 1144 | 6 |
5031 | 5031 | 2020-06-02 | Guam | 66 | 1146 | 6 |
5086 | 5086 | 2020-06-03 | Guam | 66 | 1146 | 6 |
5141 | 5141 | 2020-06-04 | Guam | 66 | 1148 | 6 |
5196 | 5196 | 2020-06-05 | Guam | 66 | 1148 | 6 |
5251 | 5251 | 2020-06-06 | Guam | 66 | 1148 | 6 |
5306 | 5306 | 2020-06-07 | Guam | 66 | 1148 | 6 |
5361 | 5361 | 2020-06-08 | Guam | 66 | 1149 | 6 |
5416 | 5416 | 2020-06-09 | Guam | 66 | 1149 | 6 |
5471 | 5471 | 2020-06-10 | Guam | 66 | 1149 | 6 |
5526 | 5526 | 2020-06-11 | Guam | 66 | 1152 | 6 |
5581 | 5581 | 2020-06-12 | Guam | 66 | 1153 | 6 |
5636 | 5636 | 2020-06-13 | Guam | 66 | 1154 | 6 |
5691 | 5691 | 2020-06-14 | Guam | 66 | 1154 | 6 |
5746 | 5746 | 2020-06-15 | Guam | 66 | 1155 | 6 |
5801 | 5801 | 2020-06-16 | Guam | 66 | 1155 | 6 |
5856 | 5856 | 2020-06-17 | Guam | 66 | 1157 | 6 |
5911 | 5911 | 2020-06-18 | Guam | 66 | 1162 | 6 |
5966 | 5966 | 2020-06-19 | Guam | 66 | 1169 | 6 |
6021 | 6021 | 2020-06-20 | Guam | 66 | 1191 | 6 |
6076 | 6076 | 2020-06-21 | Guam | 66 | 1191 | 6 |
6131 | 6131 | 2020-06-22 | Guam | 66 | 1191 | 6 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [ny_times_us_states] ( [date] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER );