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

8,299 rows where station_code = "FR0013" 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
9847155 9847155 20260504220814_v9Bpj FR0013 2026-05-06T12:01:30.460Z 2026-05-06T12:17:21.020Z
9846809 9846809 20260504203633_PrFaL FR0013 2026-05-06T12:00:31.932Z 2026-05-06T12:17:20.884Z
9846745 9846745 20260504202449_kasAL FR0013 2026-05-06T12:00:22.588Z 2026-05-06T12:17:20.865Z
9842625 9842625 20260504020904_K4HVW FR0013 2026-05-05T12:04:06.876Z 2026-05-06T12:17:24.214Z
9842474 9842474 20260504012518_SBnr5 FR0013 2026-05-05T12:03:32.156Z 2026-05-06T12:17:24.131Z
9842412 9842412 20260504004757_V52dN FR0013 2026-05-05T12:03:19.810Z 2026-05-06T12:17:24.088Z
9842404 9842404 20260504004037_UTf2X FR0013 2026-05-05T12:03:18.112Z 2026-05-06T12:17:24.083Z
9842001 9842001 20260503212133_VxA8b FR0013 2026-05-05T12:01:36.377Z 2026-05-06T12:17:23.838Z
9841979 9841979 20260503211542_XjSXg FR0013 2026-05-05T12:01:31.212Z 2026-05-06T12:17:23.822Z
9832074 9832074 20260501025415_zPS2f FR0013 2026-05-02T12:08:45.358Z 2026-05-06T12:26:40.642Z
9831244 9831244 20260501010105_vHod2 FR0013 2026-05-02T12:06:20.321Z 2026-05-06T12:26:24.044Z
9831005 9831005 20260501003407_j9h2c FR0013 2026-05-02T12:05:45.670Z 2026-05-06T12:26:04.608Z
9830765 9830765 20260430234942_KZrzv FR0013 2026-05-02T12:04:56.502Z 2026-05-06T12:25:57.096Z
9830289 9830289 20260430220638_hZUN4 FR0013 2026-05-02T12:03:31.939Z 2026-05-06T12:25:47.136Z
9830055 9830055 20260430205936_mz2LY FR0013 2026-05-02T12:02:47.828Z 2026-05-06T12:25:12.686Z
9829942 9829942 20260430203135_51fEl FR0013 2026-05-02T12:02:29.544Z 2026-05-06T12:25:06.010Z
9827251 9827251 20260430030605_C6jue FR0013 2026-05-01T12:13:30.279Z 2026-05-06T12:30:24.205Z
9827241 9827241 20260430030553_DoCZh FR0013 2026-05-01T12:13:29.769Z 2026-05-06T12:30:24.157Z
9826897 9826897 20260430023506_FspuZ FR0013 2026-05-01T12:12:43.170Z 2026-05-06T12:29:54.766Z
9826546 9826546 20260430020115_SNtok FR0013 2026-05-01T12:11:45.895Z 2026-05-06T12:29:46.290Z
9826432 9826432 20260430015258_b6GaD FR0013 2026-05-01T12:11:28.856Z 2026-05-06T12:29:44.220Z
9826050 9826050 20260430010941_myXR0 FR0013 2026-05-01T12:10:07.211Z 2026-05-06T12:29:37.164Z
9825731 9825731 20260430002855_9NhLD FR0013 2026-05-01T12:09:10.805Z 2026-05-06T12:29:09.568Z
9825617 9825617 20260430001140_4Fiyx FR0013 2026-05-01T12:08:52.022Z 2026-05-06T12:29:07.873Z
9825477 9825477 20260429235313_wuC9r FR0013 2026-05-01T12:08:22.233Z 2026-05-06T12:29:02.930Z
9825263 9825263 20260429231206_ffrNO FR0013 2026-05-01T12:07:44.021Z 2026-05-06T12:28:58.672Z
9825252 9825252 20260429231129_Fk0GS FR0013 2026-05-01T12:07:37.796Z 2026-05-06T12:28:58.417Z
9824751 9824751 20260429211119_96GFk FR0013 2026-05-01T12:05:49.964Z 2026-05-06T12:28:47.949Z
9821586 9821586 20260429025441_TaOyF FR0013 2026-04-30T12:18:28.552Z 2026-05-06T12:34:36.813Z
9821496 9821496 20260429024813_LE33x FR0013 2026-04-30T12:18:09.156Z 2026-05-06T12:34:35.993Z
9821478 9821478 20260429024649_2VFE9 FR0013 2026-04-30T12:18:08.025Z 2026-05-06T12:34:35.874Z
9821312 9821312 20260429023317_2vOtS FR0013 2026-04-30T12:17:45.386Z 2026-05-06T12:34:33.666Z
9821166 9821166 20260429021616_i5F7T FR0013 2026-04-30T12:17:22.078Z 2026-05-06T12:34:08.179Z
9821102 9821102 20260429020832_DWc7M FR0013 2026-04-30T12:17:07.947Z 2026-05-06T12:34:02.379Z
9820698 9820698 20260429012512_W2nMm FR0013 2026-04-30T12:15:50.931Z 2026-05-06T12:33:46.023Z
9820547 9820547 20260429011430_dRkKX FR0013 2026-04-30T12:15:23.616Z 2026-05-06T12:33:44.261Z
9819926 9819926 20260429000131_akHVz FR0013 2026-04-30T12:13:27.746Z 2026-05-06T12:33:35.524Z
9819609 9819609 20260428225322_b6r6H FR0013 2026-04-30T12:12:11.839Z 2026-05-06T12:33:17.878Z
9819357 9819357 20260428220053_543FW FR0013 2026-04-30T12:11:14.050Z 2026-05-06T12:32:44.549Z
9819200 9819200 20260428212910_p76Rh FR0013 2026-04-30T12:10:42.526Z 2026-05-06T12:32:42.131Z
9807238 9807238 20260427025511_bZ7uU FR0013 2026-04-28T12:15:32.650Z 2026-05-05T12:34:23.001Z
9807192 9807192 20260427024930_3s8JO FR0013 2026-04-28T12:15:18.709Z 2026-05-05T12:34:22.500Z
9807167 9807167 20260427024620_WjqvV FR0013 2026-04-28T12:15:12.695Z 2026-05-05T12:34:22.076Z
9807060 9807060 20260427023054_3i55Q FR0013 2026-04-28T12:14:49.117Z 2026-05-05T12:34:20.205Z
9807016 9807016 20260427022208_it2Se FR0013 2026-04-28T12:14:38.641Z 2026-05-05T12:34:19.630Z
9806520 9806520 20260427011659_34QSX FR0013 2026-04-28T12:12:14.231Z 2026-05-05T12:34:10.793Z
9806509 9806509 20260427011557_YX7bX FR0013 2026-04-28T12:12:12.659Z 2026-05-05T12:34:09.746Z
9806207 9806207 20260427002652_ZwGyt FR0013 2026-04-28T12:10:44.678Z 2026-05-05T12:33:49.625Z
9806205 9806205 20260427002636_0E2zC FR0013 2026-04-28T12:10:44.112Z 2026-05-05T12:33:48.683Z
9800537 9800537 20260426024223_U5DGA FR0013 2026-04-27T12:30:01.103Z 2026-05-04T12:45:44.708Z
9800503 9800503 20260426023906_qOKLs FR0013 2026-04-27T12:29:57.831Z 2026-05-04T12:45:34.639Z
9800344 9800344 20260426022653_WaV4w FR0013 2026-04-27T12:29:27.406Z 2026-05-04T12:45:31.723Z
9800336 9800336 20260426022533_VgoDX FR0013 2026-04-27T12:29:26.477Z 2026-05-04T12:45:31.499Z
9799963 9799963 20260426015601_irbwW FR0013 2026-04-27T12:28:18.380Z 2026-05-04T12:45:21.562Z
9799857 9799857 20260426014822_e7XT1 FR0013 2026-04-27T12:28:03.964Z 2026-05-04T12:45:19.616Z
9799723 9799723 20260426013830_qUaZ5 FR0013 2026-04-27T12:27:35.919Z 2026-05-04T12:45:16.791Z
9799356 9799356 20260426010337_LNG1v FR0013 2026-04-27T12:26:26.158Z 2026-05-04T12:44:56.482Z
9798778 9798778 20260426000026_aYGcI FR0013 2026-04-27T12:24:11.489Z 2026-05-04T12:44:39.207Z
9797479 9797479 20260425205230_rUPbk FR0013 2026-04-27T12:19:40.064Z 2026-05-04T12:43:34.437Z
9797316 9797316 20260425202639_Wn2I4 FR0013 2026-04-27T12:18:59.430Z 2026-05-04T12:43:29.882Z
9787838 9787838 20260425030843_iNKv5 FR0013 2026-04-26T12:23:15.327Z 2026-05-02T13:02:31.692Z
9787555 9787555 20260425024411_XqoXT FR0013 2026-04-26T12:22:41.486Z 2026-05-02T13:02:24.881Z
9787464 9787464 20260425023719_FzDnS FR0013 2026-04-26T12:22:33.972Z 2026-05-02T13:02:23.098Z
9787360 9787360 20260425023027_KOn29 FR0013 2026-04-26T12:22:29.222Z 2026-05-02T13:02:06.442Z
9787349 9787349 20260425022946_scHF2 FR0013 2026-04-26T12:22:28.582Z 2026-05-02T13:02:05.920Z
9786950 9786950 20260425020507_ZEAj7 FR0013 2026-04-26T12:21:45.385Z 2026-05-02T13:01:52.568Z
9786795 9786795 20260425015423_KL5jH FR0013 2026-04-26T12:21:34.063Z 2026-05-02T13:01:48.214Z
9786753 9786753 20260425015213_SR7iG FR0013 2026-04-26T12:21:18.550Z 2026-05-02T13:01:47.719Z
9786685 9786685 20260425014843_WdLOd FR0013 2026-04-26T12:21:15.924Z 2026-05-02T13:01:46.521Z
9785752 9785752 20260425004626_LBsll FR0013 2026-04-26T12:19:43.326Z 2026-05-02T13:01:09.163Z
9785653 9785653 20260425003920_3ZvlO FR0013 2026-04-26T12:19:24.703Z 2026-05-02T13:01:05.112Z
9785227 9785227 20260425000732_p3ZyW FR0013 2026-04-26T12:18:41.753Z 2026-05-02T13:00:39.437Z
9784542 9784542 20260424231051_IQjQe FR0013 2026-04-26T12:17:19.743Z 2026-05-02T13:00:09.285Z
9784217 9784217 20260424223251_gD3x8 FR0013 2026-04-26T12:16:37.043Z 2026-05-02T12:59:54.652Z
9784207 9784207 20260424223055_nkeOX FR0013 2026-04-26T12:16:22.492Z 2026-05-02T12:59:53.899Z
9783332 9783332 20260424211120_DpAFm FR0013 2026-04-26T12:14:32.543Z 2026-05-02T12:59:16.193Z
9772186 9772186 20260422211612_QwFsv FR0013 2026-04-25T12:42:30.307Z 2026-04-30T13:07:28.740Z
9770434 9770434 20260424032108_XWx1P FR0013 2026-04-25T12:32:01.751Z 2026-05-02T13:12:21.212Z
9770303 9770303 20260424030956_Xaw8Y FR0013 2026-04-25T12:31:52.806Z 2026-05-02T13:12:19.714Z
9769956 9769956 20260424024631_JXsfQ FR0013 2026-04-25T12:31:01.103Z 2026-05-02T13:12:14.219Z
9768883 9768883 20260424014957_3Obj3 FR0013 2026-04-25T12:28:30.632Z 2026-05-02T13:11:28.996Z
9768856 9768856 20260424014852_qahV4 FR0013 2026-04-25T12:28:20.218Z 2026-05-02T13:11:28.615Z
9768700 9768700 20260424014419_r7st5 FR0013 2026-04-25T12:28:01.959Z 2026-05-02T13:11:13.954Z
9768596 9768596 20260424013738_DsW4H FR0013 2026-04-25T12:27:40.328Z 2026-05-02T13:11:11.356Z
9768392 9768392 20260424012735_zCh2U FR0013 2026-04-25T12:27:08.898Z 2026-05-02T13:11:05.848Z
9767463 9767463 20260424004418_J08NT FR0013 2026-04-25T12:24:37.654Z 2026-05-02T13:10:09.875Z
9767245 9767245 20260424003131_ZMIhd FR0013 2026-04-25T12:24:03.958Z 2026-05-02T13:10:06.297Z
9766833 9766833 20260424000928_26su4 FR0013 2026-04-25T12:23:05.131Z 2026-05-02T13:09:59.631Z
9766567 9766567 20260423235217_hRwUD FR0013 2026-04-25T12:22:20.887Z 2026-05-02T13:09:46.604Z
9766264 9766264 20260423233346_WFqVc FR0013 2026-04-25T12:21:32.600Z 2026-05-02T13:09:15.722Z
9765551 9765551 20260423224844_bjn4D FR0013 2026-04-25T12:19:43.092Z 2026-05-02T13:09:03.286Z
9765487 9765487 20260423224319_rOwOB FR0013 2026-04-25T12:19:33.163Z 2026-05-02T13:09:01.939Z
9765224 9765224 20260423222747_ykxGJ FR0013 2026-04-25T12:18:59.577Z 2026-05-02T13:08:58.016Z
9765035 9765035 20260423220652_Rwpk8 FR0013 2026-04-25T12:18:13.439Z 2026-05-02T13:08:43.080Z
9764621 9764621 20260423212436_kgfQ7 FR0013 2026-04-25T12:16:50.880Z 2026-05-02T13:08:25.738Z
9764573 9764573 20260423211659_3602c FR0013 2026-04-25T12:16:44.436Z 2026-05-02T13:08:24.384Z
9764437 9764437 20260423210427_8zYds FR0013 2026-04-25T12:16:13.877Z 2026-05-02T13:08:21.250Z
9764407 9764407 20260423210333_2BDzV FR0013 2026-04-25T12:16:05.900Z 2026-05-02T13:08:20.901Z
9764251 9764251 20260423204811_hK3dC FR0013 2026-04-25T12:15:30.469Z 2026-05-02T13:07:55.435Z
9757868 9757868 20260423032733_BMNQL FR0013 2026-04-24T12:07:20.483Z 2026-04-30T13:12:35.191Z

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