home / gmn_data_store / participating_station

Menu
  • Dashboards

participating_station

Each row represents a station recording a meteor sighting.

Data license: CC BY 4.0 license · Data source: Global Meteor Network

947 rows where station_code = "MA0002" sorted by created_at descending

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: created_at (date), updated_at (date)

Link rowid meteor_unique_trajectory_identifier station_code created_at ▲ updated_at
8682376 8682376 20251203052249_u2ld9 MA0002 2025-12-04T14:17:03.120Z 2025-12-06T14:28:57.511Z
8682372 8682372 20251203052226_a7wM1 MA0002 2025-12-04T14:17:02.455Z 2025-12-06T14:28:57.121Z
8682206 8682206 20251203050211_wPgpU MA0002 2025-12-04T14:16:37.141Z 2025-12-06T14:28:49.982Z
8675805 8675805 20251202051526_q3QtR MA0002 2025-12-03T14:24:16.096Z 2025-12-06T14:35:00.602Z
8675588 8675588 20251202045900_kTFS4 MA0002 2025-12-03T14:23:53.546Z 2025-12-06T14:34:56.831Z
8675148 8675148 20251202040545_nzL22 MA0002 2025-12-03T14:23:07.839Z 2025-12-06T14:34:36.275Z
8674052 8674052 20251202012219_TQCwa MA0002 2025-12-03T14:20:51.590Z 2025-12-06T14:33:47.010Z
8673997 8673997 20251202005957_0opxw MA0002 2025-12-03T14:20:42.414Z 2025-12-06T14:33:44.418Z
8673970 8673970 20251202005309_2z8gE MA0002 2025-12-03T14:20:27.190Z 2025-12-06T14:33:43.520Z
8673829 8673829 20251201235243_w1Ufs MA0002 2025-12-03T14:20:09.296Z 2025-12-06T14:33:36.921Z
8673818 8673818 20251201234631_pq5VB MA0002 2025-12-03T14:20:07.144Z 2025-12-06T14:33:36.047Z
8568859 8568859 20251121053921_OL63g MA0002 2025-11-23T14:31:46.368Z 2025-11-29T14:54:47.550Z
8568214 8568214 20251121050646_h7qOJ MA0002 2025-11-23T14:30:59.010Z 2025-11-29T14:54:46.382Z
8568054 8568054 20251121050012_N3W43 MA0002 2025-11-23T14:30:37.306Z 2025-11-29T14:54:45.982Z
8560159 8560159 20251121044356_eJj8p MA0002 2025-11-22T14:42:22.872Z 2025-11-22T14:42:22.872Z
8559444 8559444 20251121041125_2GrYR MA0002 2025-11-22T14:41:55.988Z 2025-11-29T14:54:39.057Z
8559057 8559057 20251121035227_PRgJ3 MA0002 2025-11-22T14:41:46.234Z 2025-11-29T14:54:37.084Z
8558016 8558016 20251121031050_WYctt MA0002 2025-11-22T14:40:55.696Z 2025-11-29T14:54:35.055Z
8557029 8557029 20251121022908_BBQd1 MA0002 2025-11-22T14:39:49.807Z 2025-11-29T14:54:33.343Z
8556077 8556077 20251121013656_mdFcH MA0002 2025-11-22T14:39:01.617Z 2025-11-29T14:54:31.775Z
8551027 8551027 20251121001557_C3JEW MA0002 2025-11-22T14:21:56.148Z 2025-11-22T14:21:56.148Z
8550492 8550492 20251120234622_HqVRc MA0002 2025-11-22T14:20:59.996Z 2025-11-29T14:54:27.047Z
8550230 8550230 20251120232903_YgY0g MA0002 2025-11-22T14:20:25.831Z 2025-11-29T14:54:26.504Z
8536457 8536457 20251120042303_V6c09 MA0002 2025-11-21T14:18:19.194Z 2025-11-28T14:57:37.478Z
8536231 8536231 20251120035340_cigdb MA0002 2025-11-21T14:17:58.074Z 2025-11-28T14:57:28.547Z
8536207 8536207 20251120035155_7utaF MA0002 2025-11-21T14:17:48.614Z 2025-11-28T14:57:28.097Z
8535940 8535940 20251120031530_jRhdK MA0002 2025-11-21T14:17:18.432Z 2025-11-28T14:57:14.029Z
8535166 8535166 20251120012530_2sIC2 MA0002 2025-11-21T14:15:24.891Z 2025-11-28T14:56:19.170Z
8535031 8535031 20251120010155_VEACN MA0002 2025-11-21T14:15:10.334Z 2025-11-28T14:56:11.960Z
8535001 8535001 20251120005848_Ki06U MA0002 2025-11-21T14:15:07.527Z 2025-11-28T14:56:11.464Z
8374899 8374899 20251103052605_h1Jg8 MA0002 2025-11-05T14:33:25.835Z 2025-11-11T15:08:09.517Z
8374483 8374483 20251103035434_r4pan MA0002 2025-11-05T14:32:15.744Z 2025-11-11T15:07:37.032Z
8357274 8357274 20251102052213_rW6OB MA0002 2025-11-03T14:42:56.329Z 2025-11-03T14:42:56.329Z
8357239 8357239 20251102051500_LszP3 MA0002 2025-11-03T14:42:54.369Z 2025-11-10T15:09:18.422Z
8357187 8357187 20251102050216_i37Kj MA0002 2025-11-03T14:42:51.533Z 2025-11-10T15:09:16.206Z
8356697 8356697 20251102024642_4O8Gm MA0002 2025-11-03T14:41:33.603Z 2025-11-10T15:08:03.172Z
8356688 8356688 20251102024450_akCJe MA0002 2025-11-03T14:41:33.200Z 2025-11-10T15:08:02.655Z
8356452 8356452 20251102014628_IOLk0 MA0002 2025-11-03T14:40:23.279Z 2025-11-10T15:07:15.017Z
8334802 8334802 20251031022434_ryQqk MA0002 2025-11-02T14:26:00.049Z 2025-11-08T15:14:04.998Z
8333950 8333950 20251031010652_v5VCz MA0002 2025-11-02T14:23:52.770Z 2025-11-08T15:13:04.190Z
8332352 8332352 20251030214923_OcZFl MA0002 2025-11-02T14:20:01.068Z 2025-11-08T15:12:11.364Z
8332129 8332129 20251101051851_XiMV2 MA0002 2025-11-02T14:12:57.521Z 2025-11-09T15:03:44.413Z
8332117 8332117 20251101045845_ja3Ql MA0002 2025-11-02T14:12:44.251Z 2025-11-09T15:03:32.587Z
8331738 8331738 20251101030151_uPpXZ MA0002 2025-11-02T14:11:25.056Z 2025-11-09T15:03:13.832Z
8331402 8331402 20251101020241_9feR9 MA0002 2025-11-02T14:10:12.395Z 2025-11-09T15:02:09.419Z
8284253 8284253 20251028042937_alTp5 MA0002 2025-10-29T12:45:23.334Z 2025-11-05T15:22:43.770Z
8283825 8283825 20251028040311_gElGN MA0002 2025-10-29T12:45:09.862Z 2025-11-05T15:22:33.338Z
8283269 8283269 20251028032415_1NE4a MA0002 2025-10-29T12:43:56.278Z 2025-11-05T15:22:07.925Z
8283204 8283204 20251028031919_zRmjb MA0002 2025-10-29T12:43:52.971Z 2025-11-05T15:22:05.629Z
8282837 8282837 20251028025018_laj31 MA0002 2025-10-29T12:43:30.058Z 2025-11-05T15:21:50.858Z
8282737 8282737 20251028024427_rk3Hh MA0002 2025-10-29T12:43:26.623Z 2025-11-05T15:21:47.657Z
8281722 8281722 20251028013933_W62tp MA0002 2025-10-29T12:41:49.927Z 2025-10-29T12:41:49.927Z
8281522 8281522 20251028012455_LgINP MA0002 2025-10-29T12:41:40.277Z 2025-11-05T15:21:31.756Z
8281265 8281265 20251028010423_Vq0Pi MA0002 2025-10-29T12:40:46.730Z 2025-11-05T15:21:20.161Z
8072910 8072910 20251004052130_WZrDm MA0002 2025-10-09T12:18:59.334Z 2025-10-12T12:33:11.456Z
8051655 8051655 20251003052732_HW8aY MA0002 2025-10-04T12:44:44.816Z 2025-10-11T12:42:26.177Z
8051260 8051260 20251003034150_2GXKt MA0002 2025-10-04T12:43:35.866Z 2025-10-11T12:42:17.311Z
8051144 8051144 20251003031425_iIiFx MA0002 2025-10-04T12:43:15.230Z 2025-10-11T12:42:12.259Z
8051131 8051131 20251003031127_CFB63 MA0002 2025-10-04T12:43:12.853Z 2025-10-11T12:42:11.613Z
8050318 8050318 20251002234732_jJXi9 MA0002 2025-10-04T12:41:00.971Z 2025-10-11T12:40:10.505Z
8050300 8050300 20251002234224_OwTMo MA0002 2025-10-04T12:40:54.315Z 2025-10-11T12:40:06.409Z
8050107 8050107 20251002222423_WjnWB MA0002 2025-10-04T12:40:16.053Z 2025-10-11T12:39:41.180Z
8042718 8042718 20251002033220_R2VEX MA0002 2025-10-03T12:38:44.031Z 2025-10-10T12:41:52.850Z
8041424 8041424 20251002020347_pLQ4B MA0002 2025-10-03T12:36:25.026Z 2025-10-10T12:41:05.533Z
8041361 8041361 20251002020141_BvQOz MA0002 2025-10-03T12:36:22.643Z 2025-10-10T12:41:05.064Z
8037640 8037640 20251001044423_CMDVU MA0002 2025-10-03T12:26:56.583Z 2025-10-09T12:39:45.147Z
8037526 8037526 20251001021724_FamUa MA0002 2025-10-03T12:25:32.594Z 2025-10-09T12:39:17.555Z
8037518 8037518 20251001004347_2fexe MA0002 2025-10-03T12:24:34.081Z 2025-10-09T12:39:07.594Z
8037491 8037491 20250930200641_DIBbg MA0002 2025-10-03T12:22:32.539Z 2025-10-09T12:37:36.785Z
8020378 8020378 20250930033308_YydRm MA0002 2025-10-01T12:46:42.006Z 2025-10-08T12:43:50.288Z
8019928 8019928 20250930025415_YPGQT MA0002 2025-10-01T12:46:23.891Z 2025-10-08T12:43:37.194Z
8018424 8018424 20250930000749_aS5rh MA0002 2025-10-01T12:42:26.815Z 2025-10-08T12:42:55.230Z
8017185 8017185 20250929231341_VhrCB MA0002 2025-10-01T12:25:27.228Z 2025-10-01T12:25:27.228Z
8016694 8016694 20250929223025_QUMS0 MA0002 2025-10-01T12:24:22.049Z 2025-10-08T12:42:34.763Z
8008035 8008035 20250929022521_rlZM3 MA0002 2025-09-30T12:29:30.068Z 2025-10-07T13:01:09.490Z
7997640 7997640 20250928045128_nKT9B MA0002 2025-09-29T12:28:47.618Z 2025-10-05T13:07:57.054Z
7997579 7997579 20250928043239_c6Jnf MA0002 2025-09-29T12:28:42.038Z 2025-10-05T13:07:54.866Z
7997329 7997329 20250928034947_Z783Q MA0002 2025-09-29T12:27:58.139Z 2025-10-05T13:07:51.453Z
7996481 7996481 20250928023149_cdFad MA0002 2025-09-29T12:26:23.605Z 2025-10-05T13:07:38.200Z
7995660 7995660 20250928011720_lb4rU MA0002 2025-09-29T12:24:26.880Z 2025-10-05T13:07:19.884Z
7989111 7989111 20250926033344_rGtwC MA0002 2025-09-28T12:36:42.713Z 2025-10-04T13:07:21.607Z
7988495 7988495 20250926030114_YB9lR MA0002 2025-09-28T12:36:25.637Z 2025-10-04T13:07:18.657Z
7985844 7985844 20250927041349_5qRAF MA0002 2025-09-28T12:27:05.634Z 2025-10-05T13:11:21.573Z
7985147 7985147 20250927025450_B23HC MA0002 2025-09-28T12:25:50.711Z 2025-10-05T13:11:08.127Z
7984784 7984784 20250927022059_q6zhS MA0002 2025-09-28T12:25:05.949Z 2025-10-05T13:10:59.392Z
7983496 7983496 20250926222253_fDAj2 MA0002 2025-09-28T12:22:15.091Z 2025-10-05T13:10:40.631Z
7976880 7976880 20250926044816_OHWm3 MA0002 2025-09-28T12:06:33.266Z 2025-10-05T13:08:13.888Z
7976702 7976702 20250926043621_SHL3C MA0002 2025-09-28T12:06:08.137Z 2025-10-05T13:08:07.331Z
7774632 7774632 20250905035914_EAe94 MA0002 2025-09-06T13:20:04.467Z 2025-09-06T13:36:14.400Z
7772866 7772866 20250905023744_4Jp7S MA0002 2025-09-06T13:15:33.258Z 2025-09-06T13:36:13.951Z
7764602 7764602 20250904041856_9JFy6 MA0002 2025-09-05T12:23:56.092Z 2025-09-12T12:51:36.392Z
7764426 7764426 20250904034215_73f7k MA0002 2025-09-05T12:23:33.094Z 2025-09-12T12:51:32.994Z
7763277 7763277 20250904021743_LunBg MA0002 2025-09-05T12:20:58.422Z 2025-09-12T12:50:38.831Z
7763265 7763265 20250904021606_5RpX6 MA0002 2025-09-05T12:20:56.863Z 2025-09-12T12:50:38.165Z
7762591 7762591 20250904014052_p3GtB MA0002 2025-09-05T12:19:06.815Z 2025-09-12T12:50:03.817Z
7762200 7762200 20250904011946_y2FHf MA0002 2025-09-05T12:18:04.652Z 2025-09-12T12:49:49.514Z
7751800 7751800 20250903044440_oZikm MA0002 2025-09-04T12:17:37.233Z 2025-09-11T12:44:20.021Z
7751738 7751738 20250903041442_q2n6v MA0002 2025-09-04T12:17:16.165Z 2025-09-11T12:44:12.446Z
7751654 7751654 20250903033810_Nmsov MA0002 2025-09-04T12:17:05.368Z 2025-09-11T12:44:09.031Z
7751648 7751648 20250903033621_DVR2N MA0002 2025-09-04T12:17:04.729Z 2025-09-11T12:44:08.972Z

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE participating_station
(
    meteor_unique_trajectory_identifier text     NOT NULL,
    station_code                        text     NOT NULL,
    created_at                          datetime NOT NULL DEFAULT (
        strftime(
                '%Y-%m-%dT%H:%M:%fZ', 'now', 'utc'
            )
        ),
    updated_at                          datetime NOT NULL DEFAULT (
        strftime(
                '%Y-%m-%dT%H:%M:%fZ', 'now', 'utc'
            )
        ),
    FOREIGN KEY (meteor_unique_trajectory_identifier) REFERENCES meteor (unique_trajectory_identifier),
    FOREIGN KEY (station_code) REFERENCES station (code),
    UNIQUE (meteor_unique_trajectory_identifier, station_code) ON CONFLICT IGNORE
);
CREATE INDEX participating_station_station_code_covering_index ON participating_station (station_code, meteor_unique_trajectory_identifier);
CREATE INDEX participating_station_created_at_index ON participating_station (created_at);
CREATE INDEX participating_station_updated_at_index ON participating_station (updated_at);
Powered by Datasette · Queries took 1.2ms · Data license: CC BY 4.0 license · Data source: Global Meteor Network