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

281 rows where station_code = "MY0005" 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
8697119 8697119 20251207133816_taImG MY0005 2025-12-08T14:10:31.471Z 2025-12-16T15:10:53.078Z
8562202 8562202 20251121134845_kJj1L MY0005 2025-11-23T14:04:56.224Z 2025-11-30T15:03:24.366Z
8430075 8430075 20251107165051_WeG7J MY0005 2025-11-12T14:52:52.113Z 2025-11-16T15:02:28.643Z
8430071 8430071 20251107160118_DPrDc MY0005 2025-11-12T14:52:49.626Z 2025-11-16T15:02:18.839Z
8109156 8109156 20251015161008_twdKq MY0005 2025-10-17T12:04:05.851Z 2025-10-24T13:15:11.570Z
7937094 7937094 20250920203213_qvJqD MY0005 2025-09-24T13:00:04.839Z 2025-09-29T13:05:01.103Z
6311250 6311250 20250310200257_vXqJm MY0005 2025-03-13T12:13:54.269Z 2025-03-19T12:37:14.419Z
6308647 6308647 20250311194256_TVpKn MY0005 2025-03-13T12:03:07.333Z 2025-03-20T12:43:10.928Z
6238320 6238320 20250306211742_r3BB2 MY0005 2025-03-07T14:03:52.005Z 2025-03-15T12:34:15.897Z
6234461 6234461 20250303151608_4uM6Z MY0005 2025-03-05T14:16:44.164Z 2025-03-11T13:35:46.809Z
6230020 6230020 20250302122849_WSU4I MY0005 2025-03-04T14:33:45.188Z 2025-03-10T13:52:16.439Z
6221659 6221659 20250302190816_NBQdm MY0005 2025-03-04T14:03:54.081Z 2025-03-11T13:28:22.262Z
6221210 6221210 20250302174436_89ydZ MY0005 2025-03-04T14:01:44.119Z 2025-03-11T13:27:49.161Z
6182405 6182405 20250226204002_39lvh MY0005 2025-02-28T14:04:35.443Z 2025-03-07T16:51:27.716Z
6159820 6159820 20250224115153_63DSH MY0005 2025-02-25T14:15:11.613Z 2025-03-04T15:25:25.182Z
5174640 5174640 20240927193141_NIkqm MY0005 2024-09-28T12:14:11.197Z 2024-10-05T12:29:02.029Z
4518864 4518864 20240628173815_uQFcP MY0005 2024-06-30T12:02:18.464Z 2024-07-07T12:13:44.404Z
4479964 4479964 20240616193606_gHEd2 MY0005 2024-06-19T12:10:01.837Z 2024-06-24T12:11:50.000Z
4401783 4401783 20240531183835_eSR3D MY0005 2024-06-03T12:09:14.739Z 2024-06-09T12:06:00.103Z
4349905 4349905 20240510205547_eSYJV MY0005 2024-05-21T12:03:39.010Z 2024-05-22T12:11:12.606Z
4347718 4347718 20240510200506_G3HZA MY0005 2024-05-20T12:06:29.570Z 2024-05-22T12:11:09.735Z
4347716 4347716 20240510200444_QfGKW MY0005 2024-05-20T12:06:29.389Z 2024-05-22T12:11:09.620Z
4347584 4347584 20240510192154_oqvor MY0005 2024-05-20T12:06:21.097Z 2024-05-22T12:11:06.201Z
4344356 4344356 20240510145352_VIXy0 MY0005 2024-05-20T12:01:46.286Z 2024-05-22T12:09:40.311Z
4344115 4344115 20240510141733_hDYel MY0005 2024-05-20T12:01:23.053Z 2024-05-22T12:09:30.274Z
4343620 4343620 20240510125053_kMq9L MY0005 2024-05-20T12:00:26.258Z 2024-05-22T12:09:03.225Z
4306495 4306495 20240506170636_S05Dc MY0005 2024-05-14T12:05:44.297Z 2024-05-16T12:12:52.225Z
3985132 3985132 20240217180331_nbXxE MY0005 2024-02-19T14:04:50.196Z 2024-02-26T14:16:22.335Z
3985055 3985055 20240217173255_tT29Z MY0005 2024-02-19T14:04:40.142Z 2024-02-26T14:16:19.963Z
3980753 3980753 20240216190649_pyM3r MY0005 2024-02-18T14:04:49.577Z 2024-02-25T14:18:25.185Z
3980602 3980602 20240216182923_67V9Q MY0005 2024-02-18T14:04:24.251Z 2024-02-25T14:18:22.659Z
3980533 3980533 20240216181452_5Q2GT MY0005 2024-02-18T14:04:16.812Z 2024-02-25T14:18:21.735Z
3980341 3980341 20240216171229_yKLxU MY0005 2024-02-18T14:03:44.121Z 2024-02-25T14:18:15.673Z
3980097 3980097 20240216161251_r85Cl MY0005 2024-02-18T14:03:03.888Z 2024-02-25T14:18:06.377Z
3970848 3970848 20240214194222_i6vIo MY0005 2024-02-16T14:04:38.630Z 2024-02-23T14:20:51.573Z
3970745 3970745 20240214183313_W7LRm MY0005 2024-02-16T14:04:18.143Z 2024-02-23T14:20:50.123Z
3970690 3970690 20240214180215_Q22lO MY0005 2024-02-16T14:04:10.998Z 2024-02-23T14:20:49.446Z
3970373 3970373 20240214161410_DDhhu MY0005 2024-02-16T14:03:29.112Z 2024-02-23T14:20:44.685Z
3923493 3923493 20240204124329_39clT MY0005 2024-02-06T14:11:17.574Z 2024-02-12T14:23:36.933Z
3800140 3800140 20240110212601_jGGz7 MY0005 2024-01-13T14:16:08.004Z 2024-01-19T14:28:03.244Z
3800101 3800101 20240110211647_GTEn6 MY0005 2024-01-13T14:16:05.890Z 2024-01-19T14:28:03.103Z
3799782 3799782 20240110202513_aM2c0 MY0005 2024-01-13T14:15:35.718Z 2024-01-19T14:28:01.343Z
3799781 3799781 20240110202406_wBNsx MY0005 2024-01-13T14:15:35.448Z 2024-01-19T14:28:01.340Z
3799551 3799551 20240110192703_TqaLF MY0005 2024-01-13T14:15:16.953Z 2024-01-19T14:27:57.263Z
3799500 3799500 20240110191922_AiMt3 MY0005 2024-01-13T14:15:14.485Z 2024-01-19T14:27:56.783Z
3798666 3798666 20240110162437_2fAKO MY0005 2024-01-13T14:13:41.075Z 2024-01-19T14:27:44.347Z
3797706 3797706 20240110130706_y86ff MY0005 2024-01-13T14:12:06.449Z 2024-01-19T14:27:35.325Z
3797511 3797511 20240110124559_7Pw5y MY0005 2024-01-13T14:11:45.044Z 2024-01-19T14:27:32.340Z
3797287 3797287 20240110122024_lCkHz MY0005 2024-01-13T14:11:14.799Z 2024-01-19T14:27:29.418Z
3787960 3787960 20240109141901_rRUpZ MY0005 2024-01-12T14:07:50.171Z 2024-01-18T14:25:40.480Z
3782558 3782558 20240108152702_7YVAw MY0005 2024-01-11T14:09:23.416Z 2024-01-17T14:23:31.050Z
3770230 3770230 20240105171553_vyCXL MY0005 2024-01-09T14:16:51.416Z 2024-01-14T14:23:13.742Z
3753841 3753841 20240104172622_bPWHI MY0005 2024-01-07T14:08:34.391Z 2024-01-13T14:26:05.325Z
3753279 3753279 20240104153824_2n7gI MY0005 2024-01-07T14:07:37.953Z 2024-01-13T14:26:01.004Z
3739308 3739308 20240103203245_XKoJV MY0005 2024-01-06T00:06:14.089Z 2024-01-12T14:25:21.089Z
3736797 3736797 20240103131053_MwlFP MY0005 2024-01-06T00:06:13.839Z 2024-01-12T14:25:09.525Z
3680562 3680562 20231217193013_3Dsiv MY0005 2024-01-06T00:05:38.039Z 2024-01-06T00:05:38.039Z
3680494 3680494 20231217192127_p6Zo3 MY0005 2024-01-06T00:05:38.031Z 2024-01-06T00:05:38.031Z
3680057 3680057 20231217182205_Vst2f MY0005 2024-01-06T00:05:37.984Z 2024-01-06T00:05:37.984Z
3662000 3662000 20231215135957_B9j5h MY0005 2024-01-06T00:05:31.932Z 2024-01-06T00:05:31.932Z
3600773 3600773 20231213203247_r1eX9 MY0005 2024-01-06T00:05:21.415Z 2024-01-06T00:05:21.415Z
3600345 3600345 20231213201220_0F6W1 MY0005 2024-01-06T00:05:21.382Z 2024-01-06T00:05:21.382Z
3600269 3600269 20231213200555_78VdP MY0005 2024-01-06T00:05:21.375Z 2024-01-06T00:05:21.375Z
3600222 3600222 20231213200325_c9Zjl MY0005 2024-01-06T00:05:21.371Z 2024-01-06T00:05:21.371Z
3599132 3599132 20231213182854_frZwI MY0005 2024-01-06T00:05:21.254Z 2024-01-06T00:05:21.254Z
3599019 3599019 20231213181724_osx1O MY0005 2024-01-06T00:05:21.241Z 2024-01-06T00:05:21.241Z
3598938 3598938 20231213180621_id9zj MY0005 2024-01-06T00:05:21.232Z 2024-01-06T00:05:21.232Z
3598456 3598456 20231213170841_A7k2s MY0005 2024-01-06T00:05:21.179Z 2024-01-06T00:05:21.179Z
3598331 3598331 20231213165020_DTEWX MY0005 2024-01-06T00:05:21.163Z 2024-01-06T00:05:21.163Z
3598333 3598333 20231213165021_L1FeT MY0005 2024-01-06T00:05:21.163Z 2024-01-06T00:05:21.163Z
3598134 3598134 20231213155824_vOzrx MY0005 2024-01-06T00:05:21.139Z 2024-01-06T00:05:21.139Z
3598108 3598108 20231213155152_scLNZ MY0005 2024-01-06T00:05:21.136Z 2024-01-06T00:05:21.136Z
3597988 3597988 20231213152822_tb9A5 MY0005 2024-01-06T00:05:21.121Z 2024-01-06T00:05:21.121Z
3597517 3597517 20231213144900_8uvsm MY0005 2024-01-06T00:05:18.973Z 2024-01-06T00:05:18.973Z
3597083 3597083 20231213141631_lqy6q MY0005 2024-01-06T00:05:18.926Z 2024-01-06T00:05:18.926Z
3586143 3586143 20231212205122_IVOCf MY0005 2024-01-06T00:05:17.592Z 2024-01-06T00:05:17.592Z
3585819 3585819 20231212194903_Ox6Zl MY0005 2024-01-06T00:05:17.553Z 2024-01-06T00:05:17.553Z
3585496 3585496 20231212190810_sUCPC MY0005 2024-01-06T00:05:17.514Z 2024-01-06T00:05:17.514Z
3585434 3585434 20231212185908_iPzsd MY0005 2024-01-06T00:05:17.506Z 2024-01-06T00:05:17.506Z
3583933 3583933 20231212163606_1GBff MY0005 2024-01-06T00:05:17.336Z 2024-01-06T00:05:17.336Z
3575739 3575739 20231211173038_2gfgW MY0005 2024-01-06T00:05:14.917Z 2024-01-06T00:05:14.917Z
3575623 3575623 20231211171817_Xnncz MY0005 2024-01-06T00:05:14.905Z 2024-01-06T00:05:14.905Z
3567625 3567625 20231210201310_Iq2Do MY0005 2024-01-06T00:05:12.741Z 2024-01-06T00:05:12.741Z
3567392 3567392 20231210192300_Ts5Lu MY0005 2024-01-06T00:05:12.716Z 2024-01-06T00:05:12.716Z
3567250 3567250 20231210190228_wPthy MY0005 2024-01-06T00:05:12.703Z 2024-01-06T00:05:12.703Z
3567124 3567124 20231210184106_P2t3R MY0005 2024-01-06T00:05:12.690Z 2024-01-06T00:05:12.690Z
3566827 3566827 20231210175045_o6Xdu MY0005 2024-01-06T00:05:12.656Z 2024-01-06T00:05:12.656Z
3555844 3555844 20231209204930_7o71d MY0005 2024-01-06T00:05:10.151Z 2024-01-06T00:05:10.151Z
3555822 3555822 20231209204326_sa4jb MY0005 2024-01-06T00:05:10.149Z 2024-01-06T00:05:10.149Z
3555611 3555611 20231209195024_5mKP8 MY0005 2024-01-06T00:05:10.125Z 2024-01-06T00:05:10.125Z
3555600 3555600 20231209194909_RycHx MY0005 2024-01-06T00:05:10.124Z 2024-01-06T00:05:10.124Z
3555380 3555380 20231209191311_dvUmM MY0005 2024-01-06T00:05:10.098Z 2024-01-06T00:05:10.098Z
3555310 3555310 20231209190449_N8Vgn MY0005 2024-01-06T00:05:10.087Z 2024-01-06T00:05:10.087Z
3555051 3555051 20231209181608_aj75r MY0005 2024-01-06T00:05:10.058Z 2024-01-06T00:05:10.058Z
3555014 3555014 20231209180921_S0Zj4 MY0005 2024-01-06T00:05:10.054Z 2024-01-06T00:05:10.054Z
3554644 3554644 20231209170952_GqifU MY0005 2024-01-06T00:05:10.014Z 2024-01-06T00:05:10.014Z
3554087 3554087 20231209150535_FWCld MY0005 2024-01-06T00:05:08.597Z 2024-01-06T00:05:08.597Z
3553960 3553960 20231209141141_XS78j MY0005 2024-01-06T00:05:08.581Z 2024-01-06T00:05:08.581Z
3435752 3435752 20231119193459_pSvAC MY0005 2024-01-06T00:04:31.485Z 2024-01-06T00:04:31.485Z
3435754 3435754 20231119193500_9kkZx MY0005 2024-01-06T00:04:31.485Z 2024-01-06T00:04:31.485Z

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