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

2,640 rows where station_code = "MX000D" 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
8670084 8670084 20251202130452_WxKWi MX000D 2025-12-03T14:06:51.464Z 2025-12-06T14:24:35.584Z
8669721 8669721 20251202120523_X9l0l MX000D 2025-12-03T14:05:17.177Z 2025-12-06T14:24:17.444Z
8668982 8668982 20251202094605_aFP4A MX000D 2025-12-03T14:01:56.144Z 2025-12-06T14:23:24.113Z
8626239 8626239 20251126082707_TCcCE MX000D 2025-11-28T14:38:19.997Z 2025-12-04T15:12:03.953Z
8620139 8620139 20251126115400_Th4Kb MX000D 2025-11-28T14:11:52.670Z 2025-12-05T15:01:31.971Z
8592484 8592484 20251124075913_Tn2nT MX000D 2025-11-25T14:26:48.887Z 2025-12-02T15:13:04.545Z
8583177 8583177 20251124095258_CYvqI MX000D 2025-11-25T14:00:35.435Z 2025-12-02T15:05:26.496Z
8581153 8581153 20251122095623_rkb8Q MX000D 2025-11-24T14:29:36.084Z 2025-11-30T15:07:21.948Z
8570323 8570323 20251121090037_7pPRr MX000D 2025-11-23T14:33:23.027Z 2025-11-29T14:55:00.993Z
8567989 8567989 20251121045242_iQ3mL MX000D 2025-11-23T14:30:26.227Z 2025-11-29T14:54:45.670Z
8561286 8561286 20251121115809_LoW0E MX000D 2025-11-23T14:02:15.877Z 2025-11-30T15:02:52.952Z
8499884 8499884 20251117105926_xlT10 MX000D 2025-11-18T14:37:34.031Z 2025-11-25T15:11:33.867Z
8499875 8499875 20251117105711_b02Yn MX000D 2025-11-18T14:37:32.557Z 2025-11-25T15:11:33.493Z
8499243 8499243 20251117070748_xr80t MX000D 2025-11-18T14:34:28.408Z 2025-11-25T15:11:09.405Z
8499085 8499085 20251117055440_M3OX9 MX000D 2025-11-18T14:33:01.380Z 2025-11-25T15:10:55.167Z
8486159 8486159 20251115111954_Zndyi MX000D 2025-11-17T14:34:12.224Z 2025-11-23T15:20:24.676Z
8485922 8485922 20251115111035_oqsDj MX000D 2025-11-17T14:34:07.211Z 2025-11-23T15:20:14.729Z
8484901 8484901 20251115101402_DTTDZ MX000D 2025-11-17T14:33:02.204Z 2025-11-23T15:19:50.747Z
8482771 8482771 20251115065945_7B72b MX000D 2025-11-17T14:30:43.871Z 2025-11-23T15:18:28.200Z
8462295 8462295 20251114112534_XGtog MX000D 2025-11-15T14:26:00.181Z 2025-11-22T15:24:15.754Z
8461546 8461546 20251114093253_SLhOd MX000D 2025-11-15T14:24:35.863Z 2025-11-22T15:23:31.093Z
8460459 8460459 20251114070548_qSx3M MX000D 2025-11-15T14:22:08.565Z 2025-11-22T15:22:38.666Z
8416860 8416860 20251110102637_PCPrx MX000D 2025-11-11T14:26:58.889Z 2025-11-18T15:21:50.905Z
8416516 8416516 20251110092315_aKy4v MX000D 2025-11-11T14:26:09.466Z 2025-11-18T15:21:46.046Z
8406721 8406721 20251109075705_dGHZx MX000D 2025-11-10T14:17:37.934Z 2025-11-17T14:59:15.715Z
8392495 8392495 20251107055634_FvsAy MX000D 2025-11-08T14:18:23.682Z 2025-11-15T15:00:45.319Z
8382216 8382216 20251105095120_KpFlc MX000D 2025-11-06T14:17:24.158Z 2025-11-13T15:15:53.808Z
8382203 8382203 20251105094459_pTLoj MX000D 2025-11-06T14:17:18.018Z 2025-11-13T15:15:53.610Z
8381837 8381837 20251105080229_vHSzM MX000D 2025-11-06T14:16:18.640Z 2025-11-13T15:15:38.293Z
8381788 8381788 20251105073710_k88U3 MX000D 2025-11-06T14:16:13.591Z 2025-11-13T15:15:36.799Z
8375614 8375614 20251103081821_AAGWj MX000D 2025-11-05T14:35:10.244Z 2025-11-11T15:08:17.270Z
8373230 8373230 20251104122645_5Wf32 MX000D 2025-11-05T14:20:34.240Z 2025-11-12T15:12:37.343Z
8373142 8373142 20251104115248_Aqxeq MX000D 2025-11-05T14:20:16.968Z 2025-11-12T15:12:23.930Z
8366015 8366015 20251102100255_5XhpI MX000D 2025-11-04T14:34:15.905Z 2025-11-10T15:10:28.071Z
8354861 8354861 20251101110155_njB6H MX000D 2025-11-03T14:36:25.809Z 2025-11-09T15:06:37.453Z
8354497 8354497 20251101102704_MTV8K MX000D 2025-11-03T14:35:36.019Z 2025-11-09T15:06:16.723Z
8347237 8347237 20251101093852_l1M3O MX000D 2025-11-02T14:45:54.098Z 2025-11-09T15:05:52.538Z
8346773 8346773 20251101085955_qrD9y MX000D 2025-11-02T14:45:00.727Z 2025-11-09T15:05:32.223Z
8345972 8345972 20251101074140_rjx1S MX000D 2025-11-02T14:43:39.507Z 2025-11-09T15:04:51.073Z
8345302 8345302 20251101061850_mZoAS MX000D 2025-11-02T14:42:48.785Z 2025-11-09T15:04:03.194Z
8339515 8339515 20251031103149_xqNcH MX000D 2025-11-02T14:34:17.051Z 2025-11-08T15:17:40.010Z
8339265 8339265 20251031101115_lRoja MX000D 2025-11-02T14:33:40.665Z 2025-11-08T15:17:32.915Z
8337916 8337916 20251031074452_SaA60 MX000D 2025-11-02T14:31:36.732Z 2025-11-08T15:16:30.385Z
8327765 8327765 20251030114728_2j6qA MX000D 2025-11-01T12:37:50.386Z 2025-11-07T15:19:06.479Z
8327455 8327455 20251030111548_OxEB2 MX000D 2025-11-01T12:37:24.501Z 2025-11-07T15:18:59.804Z
8326156 8326156 20251030091518_wF6ZE MX000D 2025-11-01T12:35:18.076Z 2025-11-07T15:17:44.207Z
8308560 8308560 20251029111223_1a3Co MX000D 2025-10-31T12:29:52.819Z 2025-11-06T15:16:14.254Z
8307071 8307071 20251029090746_URXYJ MX000D 2025-10-31T12:26:54.844Z 2025-11-06T15:15:24.723Z
8294890 8294890 20251028110509_2yAlo MX000D 2025-10-30T12:41:27.449Z 2025-11-05T15:24:51.012Z
8293411 8293411 20251028093521_MaKK5 MX000D 2025-10-30T12:39:33.016Z 2025-11-05T15:23:58.209Z
8293068 8293068 20251028091325_Suu36 MX000D 2025-10-30T12:38:42.842Z 2025-11-05T15:23:45.021Z
8276356 8276356 20251027083747_Q03MY MX000D 2025-10-29T12:29:52.018Z 2025-11-04T15:46:54.938Z
8275862 8275862 20251027073956_tGTbz MX000D 2025-10-29T12:28:54.554Z 2025-11-04T15:46:16.279Z
8275506 8275506 20251027065816_m2mRa MX000D 2025-10-29T12:28:04.183Z 2025-11-04T15:46:07.186Z
8274877 8274877 20251027053705_08311 MX000D 2025-10-29T12:26:40.565Z 2025-11-04T15:45:50.206Z
8267653 8267653 20251026115958_XHsxM MX000D 2025-10-28T12:41:19.538Z 2025-11-03T15:17:16.492Z
8265096 8265096 20251026071323_RnSlo MX000D 2025-10-28T12:38:14.391Z 2025-11-03T15:17:02.980Z
8247481 8247481 20251025114957_9gj4X MX000D 2025-10-27T12:42:33.010Z 2025-11-02T15:05:53.057Z
8245837 8245837 20251025094111_ZvmX6 MX000D 2025-10-27T12:40:28.509Z 2025-11-02T15:05:47.952Z
8227682 8227682 20251024110320_LDHhg MX000D 2025-10-26T12:46:26.598Z 2025-11-01T13:11:30.322Z
8225449 8225449 20251024080616_uZ3zn MX000D 2025-10-26T12:43:17.157Z 2025-11-01T13:11:21.943Z
8203830 8203830 20251023094552_jGP2G MX000D 2025-10-25T12:25:44.120Z 2025-10-31T13:09:02.949Z
8185996 8185996 20251021102615_ce59Q MX000D 2025-10-23T12:36:41.045Z 2025-10-29T13:08:13.765Z
8184677 8184677 20251021090225_52g2Q MX000D 2025-10-23T12:34:46.643Z 2025-10-29T13:07:58.312Z
8174057 8174057 20251020115259_zJ48p MX000D 2025-10-22T12:44:48.706Z 2025-10-28T13:09:38.432Z
8173380 8173380 20251020110907_7BGnL MX000D 2025-10-22T12:43:22.170Z 2025-10-28T13:09:35.030Z
8171933 8171933 20251020093812_M5axD MX000D 2025-10-22T12:41:58.316Z 2025-10-28T13:09:19.444Z
8171497 8171497 20251020090857_6JCzN MX000D 2025-10-22T12:40:53.411Z 2025-10-28T13:09:15.250Z
8171437 8171437 20251020090251_37CZd MX000D 2025-10-22T12:40:49.737Z 2025-10-28T13:09:15.022Z
8170600 8170600 20251020080212_YBmKu MX000D 2025-10-22T12:39:56.782Z 2025-10-28T13:09:08.429Z
8169537 8169537 20251020062442_lUdAK MX000D 2025-10-22T12:38:24.340Z 2025-10-28T13:09:01.921Z
8158587 8158587 20251019110518_ktua2 MX000D 2025-10-21T12:36:50.471Z 2025-10-27T13:11:26.870Z
8157895 8157895 20251019090051_fiCMP MX000D 2025-10-21T12:32:11.764Z 2025-10-27T13:11:15.888Z
8151795 8151795 20251019122536_SQwdL MX000D 2025-10-21T12:01:31.807Z 2025-10-28T13:06:49.808Z
8140202 8140202 20251018121522_yCXFt MX000D 2025-10-20T12:02:11.154Z 2025-10-27T13:09:17.766Z
8140110 8140110 20251018120726_2WQZf MX000D 2025-10-20T12:01:56.377Z 2025-10-27T13:09:16.537Z
8140103 8140103 20251018120608_SSFGw MX000D 2025-10-20T12:01:54.963Z 2025-10-27T13:09:16.418Z
8140067 8140067 20251018120144_5mmBf MX000D 2025-10-20T12:01:46.693Z 2025-10-27T13:09:16.332Z
8139943 8139943 20251018115224_ypbW1 MX000D 2025-10-20T12:01:22.371Z 2025-10-27T13:09:15.386Z
8139652 8139652 20251017113544_ac33q MX000D 2025-10-19T12:33:35.146Z 2025-10-25T13:31:44.673Z
8138719 8138719 20251017101805_xDAkk MX000D 2025-10-19T12:32:35.901Z 2025-10-25T13:31:08.429Z
8136182 8136182 20251018080641_CEf5Y MX000D 2025-10-19T12:19:20.502Z 2025-10-19T12:33:44.069Z
8136082 8136082 20251018075716_PXHGQ MX000D 2025-10-19T12:19:14.221Z 2025-10-26T13:16:12.013Z
8115822 8115822 20251016100337_bKTfi MX000D 2025-10-17T12:18:29.170Z 2025-10-24T13:17:07.592Z
8113906 8113906 20251016062648_6UefR MX000D 2025-10-17T12:15:33.632Z 2025-10-24T13:16:54.159Z
8111843 8111843 20251016020714_7hpEz MX000D 2025-10-17T12:11:25.917Z 2025-10-24T13:16:29.603Z
8108030 8108030 20251016113436_52dci MX000D 2025-10-17T12:00:13.217Z 2025-10-25T13:23:51.611Z
8101278 8101278 20251015122855_iWXDh MX000D 2025-10-16T12:01:53.553Z 2025-10-24T13:14:38.584Z
8099957 8099957 20251014081154_CR6jp MX000D 2025-10-15T12:20:31.983Z 2025-10-22T13:10:21.310Z
8069261 8069261 20251006100814_jirk6 MX000D 2025-10-08T12:04:24.616Z 2025-10-15T12:43:20.319Z
8069222 8069222 20251006095614_ADaru MX000D 2025-10-08T12:04:11.925Z 2025-10-15T12:43:19.746Z
8065678 8065678 20251005021121_ZVA0d MX000D 2025-10-07T12:31:23.037Z 2025-10-13T12:33:51.642Z
8063862 8063862 20251004112153_hla2X MX000D 2025-10-07T12:27:08.629Z 2025-10-13T12:32:46.529Z
8059615 8059615 20251005121005_4xBd0 MX000D 2025-10-07T12:06:28.576Z 2025-10-14T12:33:17.580Z
8059350 8059350 20251005112534_ZEQXs MX000D 2025-10-07T12:05:33.385Z 2025-10-14T12:33:14.768Z
8058713 8058713 20251005093637_wFAoI MX000D 2025-10-07T12:02:37.105Z 2025-10-14T12:33:02.466Z
8045657 8045657 20251002093757_B4HQ3 MX000D 2025-10-04T12:05:50.427Z 2025-10-11T12:37:53.410Z
8034202 8034202 20251001102134_m52zN MX000D 2025-10-03T12:08:07.129Z 2025-10-10T12:36:50.155Z
7966400 7966400 20250925103007_2bgd0 MX000D 2025-09-27T12:04:12.928Z 2025-10-04T13:05:48.973Z
7966170 7966170 20250925095523_7W2AG MX000D 2025-09-27T12:03:43.542Z 2025-10-04T13:05:45.603Z

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