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

553 rows where station_code = "MY0002" 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
8751273 8751273 20251209204613_TF1Np MY0002 2025-12-13T15:39:33.434Z 2025-12-17T15:27:17.278Z
8740785 8740785 20251210200642_DXv5O MY0002 2025-12-13T15:19:38.279Z 2025-12-17T15:18:13.573Z
8740701 8740701 20251210195351_EEA62 MY0002 2025-12-13T15:19:11.360Z 2025-12-17T15:18:12.367Z
8740239 8740239 20251210185136_61MHY MY0002 2025-12-13T15:18:10.149Z 2025-12-17T15:18:03.003Z
8740135 8740135 20251210183441_j3nsN MY0002 2025-12-13T15:18:04.152Z 2025-12-17T15:18:01.072Z
8740129 8740129 20251210183325_Nd53W MY0002 2025-12-13T15:18:03.649Z 2025-12-17T15:18:00.887Z
8740005 8740005 20251210181326_DqNmK MY0002 2025-12-13T15:17:38.141Z 2025-12-17T15:17:55.888Z
8686853 8686853 20251203210252_gPNdp MY0002 2025-12-05T14:13:03.800Z 2025-12-11T14:41:45.726Z
8686664 8686664 20251203202814_b5ODm MY0002 2025-12-05T14:12:34.433Z 2025-12-11T14:41:31.605Z
8686624 8686624 20251203202024_aNFGH MY0002 2025-12-05T14:12:30.606Z 2025-12-11T14:41:30.802Z
8686074 8686074 20251203182650_bQBiX MY0002 2025-12-05T14:10:59.724Z 2025-12-11T14:41:15.644Z
8686065 8686065 20251203182339_BN1ED MY0002 2025-12-05T14:10:58.483Z 2025-12-11T14:41:15.395Z
8685773 8685773 20251203164526_6Eyhp MY0002 2025-12-05T14:09:55.221Z 2025-12-11T14:40:42.477Z
8663669 8663669 20251130212220_GRG1M MY0002 2025-12-02T14:18:50.306Z 2025-12-09T14:57:45.555Z
8663597 8663597 20251130210716_cMK0k MY0002 2025-12-02T14:18:32.671Z 2025-12-09T14:57:34.657Z
8663421 8663421 20251130204431_YFlUl MY0002 2025-12-02T14:18:16.011Z 2025-12-09T14:57:31.583Z
8663289 8663289 20251130202720_7N9Te MY0002 2025-12-02T14:17:56.002Z 2025-12-09T14:57:27.752Z
8662955 8662955 20251130195020_SZWJ3 MY0002 2025-12-02T14:17:12.353Z 2025-12-09T14:57:22.321Z
8586777 8586777 20251123205046_CudBC MY0002 2025-11-25T14:13:55.573Z 2025-12-02T15:11:03.078Z
8586223 8586223 20251123185954_55Lzc MY0002 2025-11-25T14:12:18.537Z 2025-12-02T15:10:45.055Z
8586109 8586109 20251123184545_CMV13 MY0002 2025-11-25T14:11:56.884Z 2025-12-02T15:10:43.902Z
8467357 8467357 20251114201109_23qxY MY0002 2025-11-16T14:14:29.493Z 2025-11-23T15:17:08.652Z
8430083 8430083 20251107201009_GurTA MY0002 2025-11-12T14:53:49.319Z 2025-11-16T15:03:25.933Z
8349058 8349058 20251101172546_sx1hF MY0002 2025-11-03T14:05:41.526Z 2025-11-10T15:04:08.518Z
8179203 8179203 20251021204458_UKlcB MY0002 2025-10-23T12:15:39.338Z 2025-10-30T13:12:51.068Z
8179071 8179071 20251021203142_so2eS MY0002 2025-10-23T12:15:23.408Z 2025-10-30T13:12:50.371Z
8179062 8179062 20251021203007_hUF1a MY0002 2025-10-23T12:15:22.643Z 2025-10-30T13:12:50.351Z
8178846 8178846 20251021201300_4ECvA MY0002 2025-10-23T12:14:41.588Z 2025-10-30T13:12:49.231Z
8178841 8178841 20251021201202_lqqd0 MY0002 2025-10-23T12:14:41.000Z 2025-10-30T13:12:49.207Z
8178823 8178823 20251021201038_FV6d3 MY0002 2025-10-23T12:14:39.354Z 2025-10-30T13:12:48.884Z
8178689 8178689 20251021195405_HPZaO MY0002 2025-10-23T12:14:05.878Z 2025-10-30T13:12:48.339Z
8109155 8109155 20251015161008_twdKq MY0002 2025-10-17T12:04:05.851Z 2025-10-24T13:15:11.570Z
8090197 8090197 20251013162834_C4Lyv MY0002 2025-10-14T12:02:45.111Z 2025-10-22T13:09:12.809Z
8037460 8037460 20251001205951_sW2JX MY0002 2025-10-03T12:18:08.085Z 2025-10-10T12:39:47.506Z
8037454 8037454 20251001205748_2ZNnB MY0002 2025-10-03T12:18:07.210Z 2025-10-10T12:39:47.367Z
7957540 7957540 20250924210229_qREWI MY0002 2025-09-26T12:19:59.565Z 2025-10-03T13:03:59.322Z
7955414 7955414 20250924143641_SBG7m MY0002 2025-09-26T12:14:05.766Z 2025-10-03T13:03:34.141Z
7955145 7955145 20250924125159_75W7z MY0002 2025-09-26T12:13:09.660Z 2025-10-03T13:03:25.720Z
7954977 7954977 20250924120348_4XHmK MY0002 2025-09-26T12:12:38.305Z 2025-10-03T13:03:23.547Z
7937088 7937088 20250920202700_5vdy3 MY0002 2025-09-24T13:00:03.101Z 2025-09-29T13:04:58.815Z
7904076 7904076 20250920211331_9XtsQ MY0002 2025-09-22T12:32:22.281Z 2025-09-29T13:05:08.267Z
7903492 7903492 20250920201655_ltzpY MY0002 2025-09-22T12:31:14.347Z 2025-09-29T13:04:57.245Z
7758310 7758310 20250903192253_UScW7 MY0002 2025-09-05T12:05:22.174Z 2025-09-12T12:47:47.678Z
7758260 7758260 20250903190352_cKe3Q MY0002 2025-09-05T12:05:07.590Z 2025-09-12T12:47:44.077Z
7758160 7758160 20250903183757_r2A5y MY0002 2025-09-05T12:04:34.215Z 2025-09-12T12:47:39.435Z
7632782 7632782 20250823212046_c52z3 MY0002 2025-08-25T12:19:19.152Z 2025-09-01T12:55:58.394Z
7632564 7632564 20250823210202_VAprt MY0002 2025-08-25T12:18:43.578Z 2025-09-01T12:55:57.054Z
7632161 7632161 20250823202509_cNyUQ MY0002 2025-08-25T12:17:27.097Z 2025-09-01T12:55:54.053Z
7586450 7586450 20250818211315_x59C0 MY0002 2025-08-21T12:35:43.740Z 2025-08-27T13:14:23.394Z
7586135 7586135 20250818204837_1rCPh MY0002 2025-08-21T12:35:26.154Z 2025-08-27T13:14:17.558Z
7585900 7585900 20250818202323_01ddt MY0002 2025-08-21T12:35:12.104Z 2025-08-27T13:14:09.085Z
7585689 7585689 20250818195321_Dox3B MY0002 2025-08-21T12:35:01.522Z 2025-08-27T13:14:02.414Z
7570574 7570574 20250818193949_r26ul MY0002 2025-08-20T12:21:09.960Z 2025-08-27T13:14:00.997Z
7570154 7570154 20250818172628_ej14G MY0002 2025-08-20T12:20:04.922Z 2025-08-27T13:13:50.539Z
7362450 7362450 20250803210149_jk2u3 MY0002 2025-08-06T12:10:04.316Z 2025-08-12T12:55:58.735Z
7362409 7362409 20250803205247_3dc35 MY0002 2025-08-06T12:10:01.769Z 2025-08-12T12:55:58.539Z
7362407 7362407 20250803205154_WK5eC MY0002 2025-08-06T12:10:01.569Z 2025-08-12T12:55:58.537Z
7362384 7362384 20250803204455_al9xN MY0002 2025-08-06T12:09:57.640Z 2025-08-12T12:55:58.276Z
7362318 7362318 20250803201917_p0lxs MY0002 2025-08-06T12:09:52.516Z 2025-08-12T12:55:57.565Z
7362312 7362312 20250803201810_9wr5F MY0002 2025-08-06T12:09:51.782Z 2025-08-12T12:55:56.384Z
7362304 7362304 20250803201628_UnL2z MY0002 2025-08-06T12:09:51.197Z 2025-08-12T12:55:56.106Z
7321246 7321246 20250801161311_ZolD4 MY0002 2025-08-04T12:11:55.984Z 2025-08-10T12:58:48.637Z
7298978 7298978 20250731211901_cVS3J MY0002 2025-08-02T12:24:42.113Z 2025-08-09T13:05:26.213Z
7298817 7298817 20250731210640_l9CO8 MY0002 2025-08-02T12:24:39.898Z 2025-08-09T13:05:20.963Z
7259288 7259288 20250729211330_nl9FB MY0002 2025-07-31T12:06:10.594Z 2025-08-07T12:48:45.423Z
7259232 7259232 20250729210610_McWSd MY0002 2025-07-31T12:06:08.621Z 2025-08-07T12:48:45.265Z
7259218 7259218 20250729210430_JVyWn MY0002 2025-07-31T12:06:08.156Z 2025-08-07T12:48:45.208Z
7217574 7217574 20250726210053_oZPPB MY0002 2025-07-28T12:24:39.881Z 2025-08-04T12:48:49.284Z
7217546 7217546 20250726205118_DKmmS MY0002 2025-07-28T12:24:38.296Z 2025-08-04T12:48:49.150Z
7217459 7217459 20250726202954_p19Yw MY0002 2025-07-28T12:24:33.550Z 2025-08-04T12:48:48.704Z
7215489 7215489 20250726174727_BVxIg MY0002 2025-07-28T12:22:09.442Z 2025-08-04T12:48:44.041Z
7215284 7215284 20250726173820_SJZd9 MY0002 2025-07-28T12:21:51.559Z 2025-08-04T12:48:43.335Z
7214897 7214897 20250726172105_qXuEv MY0002 2025-07-28T12:21:38.360Z 2025-08-04T12:48:42.825Z
7214787 7214787 20250726171557_I1NqM MY0002 2025-07-28T12:21:33.065Z 2025-08-04T12:48:42.655Z
7214347 7214347 20250726165839_i3ZfI MY0002 2025-07-28T12:20:50.565Z 2025-08-04T12:48:42.161Z
7214041 7214041 20250726164709_REx8b MY0002 2025-07-28T12:20:35.600Z 2025-08-04T12:48:41.678Z
7211455 7211455 20250726144825_a9yxZ MY0002 2025-07-28T12:17:08.144Z 2025-08-04T12:48:35.859Z
7211101 7211101 20250726143318_UUDN8 MY0002 2025-07-28T12:16:25.600Z 2025-08-04T12:48:35.540Z
7210551 7210551 20250726140336_36l2r MY0002 2025-07-28T12:15:32.965Z 2025-08-04T12:48:33.673Z
7210463 7210463 20250726135924_9uuFz MY0002 2025-07-28T12:15:29.084Z 2025-08-04T12:48:33.553Z
7197037 7197037 20250725162129_xLz2f MY0002 2025-07-27T12:20:01.504Z 2025-08-03T13:04:36.158Z
7196363 7196363 20250725154010_rLLyk MY0002 2025-07-27T12:19:08.576Z 2025-08-03T13:04:27.879Z
7169377 7169377 20250723180359_hxH3c MY0002 2025-07-25T12:00:54.152Z 2025-07-31T12:23:44.514Z
7168388 7168388 20250723165941_DBGv4 MY0002 2025-07-25T12:00:48.254Z 2025-07-31T12:23:43.052Z
7167664 7167664 20250723161722_X0YAb MY0002 2025-07-25T12:00:46.594Z 2025-07-31T12:23:42.018Z
7158719 7158719 20250722211332_M1f33 MY0002 2025-07-24T12:00:28.351Z 2025-07-30T12:09:15.940Z
7158633 7158633 20250722204848_MasLb MY0002 2025-07-24T12:00:27.926Z 2025-07-30T12:09:15.788Z
7158467 7158467 20250722193547_TRHav MY0002 2025-07-24T12:00:27.509Z 2025-07-30T12:09:15.372Z
7143546 7143546 20250721174257_lvka3 MY0002 2025-07-23T12:02:16.996Z 2025-07-29T12:48:02.833Z
7143537 7143537 20250721173702_A5lb1 MY0002 2025-07-23T12:02:16.680Z 2025-07-29T12:48:02.639Z
7143335 7143335 20250721161728_YF2CX MY0002 2025-07-23T12:02:10.360Z 2025-07-29T12:47:57.820Z
7126902 7126902 20250720210937_yiYQ4 MY0002 2025-07-22T12:00:11.879Z 2025-07-29T12:46:44.889Z
6662502 6662502 20250504130951_yIIr4 MY0002 2025-05-06T12:27:39.352Z 2025-05-12T12:35:32.125Z
6657709 6657709 20250504190620_3bGzR MY0002 2025-05-06T12:15:22.210Z 2025-05-13T12:38:04.980Z
6559848 6559848 20250423182107_AS20D MY0002 2025-04-25T12:18:04.660Z 2025-05-02T12:34:54.344Z
6518313 6518313 20250417133553_YaM83 MY0002 2025-04-18T12:04:07.636Z 2025-04-26T12:34:38.972Z
6461039 6461039 20250403203355_Z5M8p MY0002 2025-04-05T12:27:39.300Z 2025-04-11T12:35:01.389Z
6311249 6311249 20250310200257_vXqJm MY0002 2025-03-13T12:13:54.269Z 2025-03-19T12:37:14.419Z
6308646 6308646 20250311194256_TVpKn MY0002 2025-03-13T12:03:07.300Z 2025-03-20T12:43:10.928Z
6238319 6238319 20250306211742_r3BB2 MY0002 2025-03-07T14:03:51.992Z 2025-03-15T12:34:15.897Z

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