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

6,394 rows where station_code = "FR000R" 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
9611738 9611738 20260405031956_XjX32 FR000R 2026-04-06T12:15:51.334Z 2026-04-06T12:16:14.855Z
9611310 9611310 20260405012315_cdQlt FR000R 2026-04-06T12:13:58.984Z 2026-04-06T12:16:14.776Z
9610790 9610790 20260404214812_jtPCB FR000R 2026-04-06T12:11:23.368Z 2026-04-06T12:16:14.662Z
9605030 9605030 20260403040106_gA29l FR000R 2026-04-04T12:00:23.094Z 2026-04-06T12:16:23.156Z
9602886 9602886 20260402035211_hHzjq FR000R 2026-04-03T12:01:04.287Z 2026-04-06T12:21:19.010Z
9602749 9602749 20260402025819_SCh1k FR000R 2026-04-03T12:00:26.694Z 2026-04-06T12:21:07.594Z
9602728 9602728 20260402025138_IBgMV FR000R 2026-04-03T12:00:22.694Z 2026-04-06T12:21:06.258Z
9602675 9602675 20260402022952_q0rb3 FR000R 2026-04-03T12:00:10.134Z 2026-04-06T12:21:01.146Z
9598676 9598676 20260331023939_O3355 FR000R 2026-04-01T12:00:28.833Z 2026-04-06T12:26:45.968Z
9592958 9592958 20260329040436_HQkMT FR000R 2026-03-30T12:02:26.223Z 2026-04-06T12:34:42.341Z
9592956 9592956 20260329040347_h1Z6a FR000R 2026-03-30T12:02:25.721Z 2026-04-06T12:34:42.285Z
9592712 9592712 20260329030452_HIJx4 FR000R 2026-03-30T12:01:41.067Z 2026-04-06T12:34:22.332Z
9592470 9592470 20260329021312_A8esi FR000R 2026-03-30T12:01:03.062Z 2026-04-06T12:34:11.621Z
9588721 9588721 20260327004213_q06iK FR000R 2026-03-28T12:11:43.189Z 2026-04-04T12:42:29.471Z
9586099 9586099 20260327035421_TwCx3 FR000R 2026-03-28T12:02:10.290Z 2026-04-05T12:33:00.991Z
9586014 9586014 20260327033251_DIb9f FR000R 2026-03-28T12:01:58.383Z 2026-04-05T12:32:56.782Z
9585977 9585977 20260327032312_9Im0s FR000R 2026-03-28T12:01:54.762Z 2026-04-05T12:32:55.465Z
9585954 9585954 20260327031558_Hja56 FR000R 2026-03-28T12:01:51.124Z 2026-04-05T12:32:54.436Z
9585952 9585952 20260327031554_nKtbV FR000R 2026-03-28T12:01:50.402Z 2026-04-05T12:32:54.342Z
9585891 9585891 20260327030205_6Bc5e FR000R 2026-03-28T12:01:39.926Z 2026-04-05T12:32:51.641Z
9585760 9585760 20260327022353_A8rKN FR000R 2026-03-28T12:01:13.676Z 2026-04-05T12:32:40.387Z
9585693 9585693 20260327020635_U2Av5 FR000R 2026-03-28T12:01:01.906Z 2026-04-05T12:32:34.969Z
9585534 9585534 20260327013042_UpOJ3 FR000R 2026-03-28T12:00:34.915Z 2026-04-05T12:32:25.670Z
9585376 9585376 20260324234219_7sdbG FR000R 2026-03-27T12:21:15.740Z 2026-04-02T12:37:37.676Z
9580118 9580118 20260325000638_m0Xoi FR000R 2026-03-26T12:15:07.339Z 2026-03-26T12:15:14.261Z
9575862 9575862 20260325002903_G249y FR000R 2026-03-26T12:00:27.207Z 2026-04-03T12:35:26.846Z
9571048 9571048 20260322234111_guI2E FR000R 2026-03-24T12:24:14.310Z 2026-03-30T12:30:54.460Z
9570951 9570951 20260322232115_OmonY FR000R 2026-03-24T12:24:04.268Z 2026-03-30T12:30:52.624Z
9570529 9570529 20260322215239_geaVZ FR000R 2026-03-24T12:23:24.657Z 2026-03-30T12:30:44.781Z
9570419 9570419 20260322211640_Q1k0t FR000R 2026-03-24T12:23:14.381Z 2026-03-30T12:30:42.419Z
9562844 9562844 20260323032556_J8kXQ FR000R 2026-03-24T12:04:15.217Z 2026-03-31T12:26:27.630Z
9562254 9562254 20260323015409_hS3fO FR000R 2026-03-24T12:02:36.129Z 2026-03-31T12:26:05.241Z
9562167 9562167 20260323014017_afURT FR000R 2026-03-24T12:02:20.663Z 2026-03-31T12:26:02.696Z
9561772 9561772 20260323004041_lwjdP FR000R 2026-03-24T12:01:15.395Z 2026-03-31T12:25:53.320Z
9561745 9561745 20260323003711_CKj29 FR000R 2026-03-24T12:01:09.502Z 2026-03-31T12:25:52.525Z
9560584 9560584 20260321214440_fqb0G FR000R 2026-03-23T12:11:56.839Z 2026-03-29T12:21:01.595Z
9559936 9559936 20260321201215_4qrAf FR000R 2026-03-23T12:11:34.101Z 2026-03-29T12:20:56.698Z
9559729 9559729 20260321193418_fCMrk FR000R 2026-03-23T12:11:28.225Z 2026-03-29T12:20:47.255Z
9554609 9554609 20260322032023_aa3EO FR000R 2026-03-23T12:02:42.980Z 2026-03-30T12:28:06.372Z
9554089 9554089 20260322023822_09ikE FR000R 2026-03-23T12:02:13.391Z 2026-03-30T12:27:58.187Z
9553785 9553785 20260322021348_2Dt8A FR000R 2026-03-23T12:01:51.713Z 2026-03-30T12:27:52.524Z
9553566 9553566 20260322015358_cSn56 FR000R 2026-03-23T12:01:40.593Z 2026-03-30T12:27:49.330Z
9553137 9553137 20260322011642_5dLfg FR000R 2026-03-23T12:01:14.919Z 2026-03-30T12:27:35.526Z
9553087 9553087 20260322010950_KBBor FR000R 2026-03-23T12:01:12.458Z 2026-03-30T12:27:34.698Z
9553040 9553040 20260322010443_EYr2U FR000R 2026-03-23T12:01:09.990Z 2026-03-30T12:27:33.897Z
9552659 9552659 20260322002844_aPrn4 FR000R 2026-03-23T12:00:41.037Z 2026-03-30T12:27:27.704Z
9552548 9552548 20260322001903_3Q3a3 FR000R 2026-03-23T12:00:32.033Z 2026-03-30T12:27:25.997Z
9551893 9551893 20260320220552_Y21AU FR000R 2026-03-22T12:27:15.943Z 2026-03-28T12:37:03.721Z
9543514 9543514 20260321040749_XrC02 FR000R 2026-03-22T12:04:02.345Z 2026-03-29T12:19:08.427Z
9543468 9543468 20260321035905_7kua9 FR000R 2026-03-22T12:03:53.964Z 2026-03-29T12:19:07.883Z
9542889 9542889 20260321014612_Wz0e2 FR000R 2026-03-22T12:01:54.269Z 2026-03-29T12:18:59.526Z
9542222 9542222 20260319230233_jbvvC FR000R 2026-03-21T12:29:52.096Z 2026-03-27T12:42:50.230Z
9542148 9542148 20260319225227_PBICW FR000R 2026-03-21T12:29:42.918Z 2026-03-27T12:42:45.968Z
9542115 9542115 20260319224816_HMt9q FR000R 2026-03-21T12:29:40.228Z 2026-03-27T12:42:45.175Z
9542012 9542012 20260319222759_RVw2V FR000R 2026-03-21T12:29:34.967Z 2026-03-27T12:42:44.095Z
9541881 9541881 20260319220049_w2DCS FR000R 2026-03-21T12:29:27.894Z 2026-03-27T12:42:42.726Z
9541475 9541475 20260319204218_mE5gx FR000R 2026-03-21T12:28:59.383Z 2026-03-27T12:42:38.060Z
9534449 9534449 20260320034957_vhN9m FR000R 2026-03-21T12:08:01.384Z 2026-03-28T12:34:18.379Z
9534417 9534417 20260320034843_GHCnD FR000R 2026-03-21T12:07:57.394Z 2026-03-28T12:34:18.081Z
9534288 9534288 20260320034004_q6FJY FR000R 2026-03-21T12:07:38.090Z 2026-03-28T12:34:17.032Z
9532858 9532858 20260320013412_RFKZE FR000R 2026-03-21T12:03:49.027Z 2026-03-28T12:33:45.209Z
9532754 9532754 20260320012321_tvJx3 FR000R 2026-03-21T12:03:30.636Z 2026-03-28T12:33:36.393Z
9532616 9532616 20260320011340_3GXyG FR000R 2026-03-21T12:03:12.533Z 2026-03-28T12:33:34.610Z
9532150 9532150 20260320002250_T3Ge5 FR000R 2026-03-21T12:01:50.927Z 2026-03-28T12:33:24.944Z
9531852 9531852 20260319235506_3YSm7 FR000R 2026-03-21T12:01:01.504Z 2026-03-28T12:33:22.170Z
9531686 9531686 20260319233522_SwKcx FR000R 2026-03-21T12:00:28.189Z 2026-03-28T12:33:20.080Z
9531293 9531293 20260318225512_UIvSN FR000R 2026-03-20T12:25:05.519Z 2026-03-26T12:39:18.628Z
9530415 9530415 20260318205233_kI6Fr FR000R 2026-03-20T12:24:22.281Z 2026-03-26T12:39:12.002Z
9530361 9530361 20260318204110_PB6WR FR000R 2026-03-20T12:24:19.440Z 2026-03-26T12:39:11.456Z
9529907 9529907 20260318194038_ZbGrH FR000R 2026-03-20T12:23:48.282Z 2026-03-26T12:39:07.337Z
9529890 9529890 20260318193916_6S8k2 FR000R 2026-03-20T12:23:47.565Z 2026-03-26T12:39:07.252Z
9521411 9521411 20260319041136_XG6Gr FR000R 2026-03-20T12:07:57.396Z 2026-03-27T12:40:54.476Z
9520959 9520959 20260319034555_Rm6aG FR000R 2026-03-20T12:07:17.393Z 2026-03-27T12:40:49.361Z
9520124 9520124 20260319025512_qESnw FR000R 2026-03-20T12:05:46.766Z 2026-03-27T12:40:39.298Z
9519786 9519786 20260319023614_otW0c FR000R 2026-03-20T12:05:06.555Z 2026-03-27T12:40:35.543Z
9519706 9519706 20260319023055_CCRCK FR000R 2026-03-20T12:04:57.474Z 2026-03-27T12:40:34.621Z
9519319 9519319 20260319020050_Syyli FR000R 2026-03-20T12:04:16.868Z 2026-03-27T12:40:20.050Z
9518650 9518650 20260319011435_FePNr FR000R 2026-03-20T12:03:02.838Z 2026-03-27T12:40:12.325Z
9518360 9518360 20260319005349_jPSsr FR000R 2026-03-20T12:02:23.294Z 2026-03-27T12:40:08.756Z
9518184 9518184 20260319003934_ZRJjS FR000R 2026-03-20T12:02:04.846Z 2026-03-27T12:40:07.192Z
9518168 9518168 20260319003908_bUbNt FR000R 2026-03-20T12:02:02.939Z 2026-03-27T12:40:07.031Z
9517562 9517562 20260318233931_OYEOA FR000R 2026-03-20T12:00:42.985Z 2026-03-27T12:40:00.898Z
9517281 9517281 20260317230154_0QFHB FR000R 2026-03-19T12:27:25.097Z 2026-03-25T12:43:09.837Z
9516085 9516085 20260317195415_bW26y FR000R 2026-03-19T12:25:38.237Z 2026-03-25T12:42:48.003Z
9511424 9511424 20260318035238_ULrxX FR000R 2026-03-19T12:10:09.742Z 2026-03-26T12:37:36.812Z
9511267 9511267 20260318034342_8MS2r FR000R 2026-03-19T12:09:49.754Z 2026-03-26T12:37:32.496Z
9511027 9511027 20260318033356_A3aIr FR000R 2026-03-19T12:09:19.433Z 2026-03-26T12:37:18.873Z
9510704 9510704 20260318030946_aOLDi FR000R 2026-03-19T12:08:23.656Z 2026-03-26T12:37:15.700Z
9509439 9509439 20260318014837_66K5g FR000R 2026-03-19T12:05:18.660Z 2026-03-26T12:37:05.463Z
9509194 9509194 20260318012953_TSsqx FR000R 2026-03-19T12:04:43.306Z 2026-03-26T12:37:03.701Z
9509190 9509190 20260318012953_3CItY FR000R 2026-03-19T12:04:42.901Z 2026-03-26T12:37:03.679Z
9509188 9509188 20260318012953_aM6Xf FR000R 2026-03-19T12:04:42.491Z 2026-03-26T12:37:03.676Z
9508515 9508515 20260318010232_B6jqA FR000R 2026-03-19T12:03:16.468Z 2026-03-26T12:36:59.160Z
9508420 9508420 20260318005313_lxfTu FR000R 2026-03-19T12:03:02.767Z 2026-03-26T12:36:58.377Z
9508417 9508417 20260318005312_ntZb7 FR000R 2026-03-19T12:03:02.471Z 2026-03-26T12:36:58.371Z
9508288 9508288 20260318004125_bnB1v FR000R 2026-03-19T12:02:49.547Z 2026-03-26T12:36:57.576Z
9507464 9507464 20260315193004_E95W8 FR000R 2026-03-18T12:25:51.288Z 2026-03-23T12:22:41.655Z
9492770 9492770 20260314215356_WcQKi FR000R 2026-03-16T12:29:01.595Z 2026-03-22T12:42:54.264Z
9486019 9486019 20260315043247_qtkA6 FR000R 2026-03-16T12:08:21.861Z 2026-03-23T12:21:54.995Z
9485843 9485843 20260315040125_Gmp2k FR000R 2026-03-16T12:07:49.540Z 2026-03-23T12:21:54.303Z

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