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

1,444 rows where station_code = "SI0004" 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
8439175 8439175 20251112032206_x2N47 SI0004 2025-11-13T14:25:52.559Z 2025-11-20T15:25:11.535Z
8439139 8439139 20251112031805_VODI3 SI0004 2025-11-13T14:25:49.330Z 2025-11-20T15:25:11.087Z
8439098 8439098 20251112031215_W2InR SI0004 2025-11-13T14:25:40.424Z 2025-11-20T15:25:04.405Z
8439069 8439069 20251112030859_vIqhk SI0004 2025-11-13T14:25:28.778Z 2025-11-20T15:25:03.559Z
8439039 8439039 20251112030445_b1WB5 SI0004 2025-11-13T14:25:24.363Z 2025-11-20T15:24:56.923Z
8438940 8438940 20251112025405_acsLn SI0004 2025-11-13T14:25:11.848Z 2025-11-13T14:25:11.848Z
8438896 8438896 20251112024917_32Tce SI0004 2025-11-13T14:25:07.208Z 2025-11-13T14:25:07.208Z
8438887 8438887 20251112024756_3Z3hE SI0004 2025-11-13T14:25:06.006Z 2025-11-20T15:24:50.576Z
8438869 8438869 20251112024623_xN8A1 SI0004 2025-11-13T14:25:04.228Z 2025-11-13T14:25:04.228Z
8438839 8438839 20251112024419_d30sh SI0004 2025-11-13T14:25:01.247Z 2025-11-20T15:24:49.252Z
8438728 8438728 20251112023145_t20MN SI0004 2025-11-13T14:24:33.719Z 2025-11-20T15:24:46.293Z
8438638 8438638 20251112022145_ZTjlG SI0004 2025-11-13T14:24:24.542Z 2025-11-20T15:24:43.610Z
8438615 8438615 20251112021852_ExGzO SI0004 2025-11-13T14:24:20.864Z 2025-11-20T15:24:43.109Z
8438503 8438503 20251112020700_6KTgW SI0004 2025-11-13T14:23:55.264Z 2025-11-20T15:24:37.443Z
8438452 8438452 20251112015953_JA2JO SI0004 2025-11-13T14:23:48.031Z 2025-11-20T15:24:35.873Z
8438396 8438396 20251112015115_7qI2c SI0004 2025-11-13T14:23:41.703Z 2025-11-20T15:24:31.418Z
8438332 8438332 20251112014606_QiMTA SI0004 2025-11-13T14:23:34.863Z 2025-11-20T15:24:25.292Z
8438318 8438318 20251112014341_I3634 SI0004 2025-11-13T14:23:22.544Z 2025-11-20T15:24:24.530Z
8438283 8438283 20251112014227_dBh63 SI0004 2025-11-13T14:23:14.520Z 2025-11-20T15:24:23.339Z
8438167 8438167 20251112013102_nm64s SI0004 2025-11-13T14:22:59.608Z 2025-11-20T15:24:16.873Z
8438156 8438156 20251112013043_PGYI5 SI0004 2025-11-13T14:22:58.395Z 2025-11-20T15:24:16.527Z
8438115 8438115 20251112012508_LOEYS SI0004 2025-11-13T14:22:54.172Z 2025-11-20T15:24:14.943Z
8438108 8438108 20251112012418_TO3bX SI0004 2025-11-13T14:22:53.434Z 2025-11-20T15:24:14.563Z
8438106 8438106 20251112012307_3m2T2 SI0004 2025-11-13T14:22:53.349Z 2025-11-20T15:24:14.416Z
8438049 8438049 20251112011611_D2BnQ SI0004 2025-11-13T14:22:43.368Z 2025-11-20T15:24:12.918Z
8437900 8437900 20251112005507_y83Ju SI0004 2025-11-13T14:22:16.084Z 2025-11-20T15:23:56.649Z
8437831 8437831 20251112004933_MMEsL SI0004 2025-11-13T14:22:09.330Z 2025-11-20T15:23:54.766Z
8437711 8437711 20251112003725_CDwIY SI0004 2025-11-13T14:21:49.700Z 2025-11-20T15:23:51.033Z
8437665 8437665 20251112003258_XPHdY SI0004 2025-11-13T14:21:46.235Z 2025-11-20T15:23:49.905Z
8437640 8437640 20251112003055_DK8K1 SI0004 2025-11-13T14:21:43.701Z 2025-11-20T15:23:49.448Z
8437526 8437526 20251112001517_DEp98 SI0004 2025-11-13T14:21:15.560Z 2025-11-20T15:23:42.142Z
8437385 8437385 20251111235704_Pqssq SI0004 2025-11-13T14:21:00.562Z 2025-11-20T15:23:29.674Z
8437315 8437315 20251111234910_Bcb0L SI0004 2025-11-13T14:20:37.206Z 2025-11-20T15:23:27.522Z
8437310 8437310 20251111234905_WqKtw SI0004 2025-11-13T14:20:36.747Z 2025-11-20T15:23:27.440Z
8437295 8437295 20251111234814_KOhmL SI0004 2025-11-13T14:20:35.579Z 2025-11-20T15:23:25.028Z
8437173 8437173 20251111233441_ldMSG SI0004 2025-11-13T14:20:20.764Z 2025-11-13T14:31:42.440Z
8437160 8437160 20251111233338_SbE3c SI0004 2025-11-13T14:20:19.622Z 2025-11-20T15:23:19.136Z
8412227 8412227 20251109195712_6mJT3 SI0004 2025-11-11T14:13:24.051Z 2025-11-18T15:20:09.005Z
8412186 8412186 20251109195500_HnLlu SI0004 2025-11-11T14:13:18.807Z 2025-11-18T15:20:08.461Z
8412114 8412114 20251109195004_07ZKU SI0004 2025-11-11T14:12:58.447Z 2025-11-18T15:20:07.898Z
8412086 8412086 20251109194901_RxP7q SI0004 2025-11-11T14:12:56.479Z 2025-11-18T15:20:07.812Z
8412070 8412070 20251109194835_wJ27E SI0004 2025-11-11T14:12:55.396Z 2025-11-18T15:20:07.469Z
8411712 8411712 20251109191536_FkfUh SI0004 2025-11-11T14:11:47.236Z 2025-11-18T15:19:53.369Z
8411404 8411404 20251109184815_MS2Yl SI0004 2025-11-11T14:10:51.002Z 2025-11-18T15:19:37.853Z
8411324 8411324 20251109183927_1hya2 SI0004 2025-11-11T14:10:31.114Z 2025-11-18T15:19:34.154Z
8411222 8411222 20251109182355_8UlAq SI0004 2025-11-11T14:10:13.865Z 2025-11-18T15:19:30.820Z
8411206 8411206 20251109182202_J23f4 SI0004 2025-11-11T14:10:11.700Z 2025-11-18T15:19:30.586Z
8411110 8411110 20251109181115_wU3in SI0004 2025-11-11T14:09:46.507Z 2025-11-18T15:19:24.882Z
8410906 8410906 20251109174737_yRzPT SI0004 2025-11-11T14:09:05.296Z 2025-11-18T15:19:16.259Z
8397628 8397628 20251108021325_Arn6c SI0004 2025-11-09T14:12:45.955Z 2025-11-16T15:04:24.506Z
8397187 8397187 20251108005455_sGiwc SI0004 2025-11-09T14:11:16.984Z 2025-11-16T15:04:09.220Z
8397012 8397012 20251108000338_ysSHl SI0004 2025-11-09T14:10:31.825Z 2025-11-16T15:03:56.767Z
8397010 8397010 20251108000338_2KcRN SI0004 2025-11-09T14:10:31.144Z 2025-11-16T15:03:56.728Z
8396828 8396828 20251107231618_BYaPR SI0004 2025-11-09T14:09:55.243Z 2025-11-16T15:03:44.134Z
8396785 8396785 20251107230152_oCwxk SI0004 2025-11-09T14:09:47.282Z 2025-11-16T15:03:40.472Z
8383176 8383176 20251104003001_1W76n SI0004 2025-11-06T14:24:10.057Z 2025-11-12T15:10:15.981Z
8383166 8383166 20251104002020_KeJFt SI0004 2025-11-06T14:24:06.290Z 2025-11-12T15:10:14.487Z
8383154 8383154 20251103234455_Jrg2I SI0004 2025-11-06T14:24:00.700Z 2025-11-12T15:10:07.266Z
8383145 8383145 20251103233848_NSxk2 SI0004 2025-11-06T14:23:58.658Z 2025-11-12T15:10:05.455Z
8383129 8383129 20251103232028_Prwv4 SI0004 2025-11-06T14:23:54.985Z 2025-11-12T15:09:56.802Z
8383118 8383118 20251103224640_XzXTQ SI0004 2025-11-06T14:23:51.047Z 2025-11-12T15:09:47.661Z
8383092 8383092 20251103215637_97zwM SI0004 2025-11-06T14:23:28.857Z 2025-11-12T15:09:29.444Z
8383088 8383088 20251103214017_INBuT SI0004 2025-11-06T14:23:24.403Z 2025-11-12T15:09:27.424Z
8383086 8383086 20251103213916_U8M5U SI0004 2025-11-06T14:23:23.835Z 2025-11-12T15:09:27.072Z
8380300 8380300 20251105013402_qRW3B SI0004 2025-11-06T14:11:17.337Z 2025-11-13T15:14:50.371Z
8380153 8380153 20251105005501_9Zk93 SI0004 2025-11-06T14:10:37.604Z 2025-11-13T15:14:42.439Z
8379945 8379945 20251105000601_p4cAF SI0004 2025-11-06T14:09:54.304Z 2025-11-13T15:14:33.851Z
8379897 8379897 20251104235944_J3KRS SI0004 2025-11-06T14:09:37.511Z 2025-11-13T15:14:33.058Z
8379851 8379851 20251104235148_zgGKo SI0004 2025-11-06T14:09:26.685Z 2025-11-13T15:14:32.371Z
8379761 8379761 20251104233607_EUQDV SI0004 2025-11-06T14:09:03.235Z 2025-11-13T15:14:30.389Z
8379693 8379693 20251104231707_T3FHb SI0004 2025-11-06T14:08:49.476Z 2025-11-13T15:14:27.524Z
8379687 8379687 20251104231415_ArvOG SI0004 2025-11-06T14:08:48.192Z 2025-11-13T15:14:25.802Z
8379680 8379680 20251104231239_VDu8z SI0004 2025-11-06T14:08:47.019Z 2025-11-13T15:14:25.773Z
8379649 8379649 20251104230711_9doOW SI0004 2025-11-06T14:08:41.791Z 2025-11-13T15:14:24.125Z
8343676 8343676 20251101025228_m7YyR SI0004 2025-11-02T14:41:36.038Z 2025-11-09T15:03:10.638Z
8343662 8343662 20251101024936_HRNF8 SI0004 2025-11-02T14:41:26.974Z 2025-11-09T15:03:06.911Z
8343556 8343556 20251101023646_oc3Dm SI0004 2025-11-02T14:40:59.785Z 2025-11-09T15:02:47.962Z
8343543 8343543 20251101023612_CMvdU SI0004 2025-11-02T14:40:59.155Z 2025-11-09T15:02:45.925Z
8343340 8343340 20251101020950_Q0I4U SI0004 2025-11-02T14:40:29.631Z 2025-11-09T15:02:14.042Z
8343266 8343266 20251101015609_020Yt SI0004 2025-11-02T14:40:09.956Z 2025-11-09T15:02:04.518Z
8343174 8343174 20251101013852_6Lstt SI0004 2025-11-02T14:39:48.659Z 2025-11-09T15:01:34.706Z
8342551 8342551 20251031235815_GeXat SI0004 2025-11-02T14:38:48.391Z 2025-11-09T15:00:37.815Z
8342415 8342415 20251031233646_YgBdJ SI0004 2025-11-02T14:38:44.758Z 2025-11-09T15:00:34.166Z
8342361 8342361 20251031232512_QQMhq SI0004 2025-11-02T14:38:42.987Z 2025-11-09T15:00:32.800Z
8342338 8342338 20251031232310_sNxu3 SI0004 2025-11-02T14:38:42.767Z 2025-11-09T15:00:32.542Z
8342336 8342336 20251031232133_1oGUx SI0004 2025-11-02T14:38:42.723Z 2025-11-09T15:00:32.511Z
8342326 8342326 20251031232039_E8KQb SI0004 2025-11-02T14:38:42.380Z 2025-11-09T15:00:32.404Z
8342242 8342242 20251031230610_CTJY8 SI0004 2025-11-02T14:38:39.810Z 2025-11-09T15:00:30.678Z
8282880 8282880 20251028025332_yLIWu SI0004 2025-10-29T12:43:31.698Z 2025-11-05T15:21:52.381Z
8282877 8282877 20251028025254_P60ZA SI0004 2025-10-29T12:43:31.554Z 2025-10-29T12:43:31.554Z
8282800 8282800 20251028024742_wtl59 SI0004 2025-10-29T12:43:28.557Z 2025-11-05T15:21:49.861Z
8282764 8282764 20251028024553_efV6X SI0004 2025-10-29T12:43:27.424Z 2025-11-05T15:21:48.032Z
8282725 8282725 20251028024335_Ebp3u SI0004 2025-10-29T12:43:25.677Z 2025-11-05T15:21:47.486Z
8282601 8282601 20251028023358_Bx1Pu SI0004 2025-10-29T12:43:21.056Z 2025-11-05T15:21:44.787Z
8282590 8282590 20251028023332_O3Al4 SI0004 2025-10-29T12:43:20.693Z 2025-11-05T15:21:44.670Z
8282587 8282587 20251028023325_fiI4H SI0004 2025-10-29T12:43:20.540Z 2025-11-05T15:21:44.645Z
8282564 8282564 20251028023119_4PxtM SI0004 2025-10-29T12:43:19.474Z 2025-11-05T15:21:44.436Z
8282520 8282520 20251028022903_lR3xN SI0004 2025-10-29T12:43:16.900Z 2025-10-29T12:43:16.900Z
8282489 8282489 20251028022714_WrlZw SI0004 2025-10-29T12:43:10.461Z 2025-11-05T15:21:43.752Z
8282317 8282317 20251028021715_bACWI SI0004 2025-10-29T12:42:46.410Z 2025-11-05T15:21:42.473Z

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