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

7,321 rows where station_code = "FR000A" 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
9260601 9260601 20260125054907_hIQbC FR000A 2026-01-26T14:22:32.530Z 2026-01-30T14:45:00.632Z
9260236 9260236 20260125031253_m2bNE FR000A 2026-01-26T14:20:54.298Z 2026-01-30T14:44:41.082Z
9260100 9260100 20260125023625_d2DPE FR000A 2026-01-26T14:20:17.122Z 2026-01-30T14:44:26.944Z
9260026 9260026 20260125020803_TsXwK FR000A 2026-01-26T14:19:49.338Z 2026-01-30T14:44:22.759Z
9260014 9260014 20260125020344_ntXtP FR000A 2026-01-26T14:19:46.919Z 2026-01-30T14:44:22.125Z
9259950 9259950 20260125012347_7nlPn FR000A 2026-01-26T14:19:31.921Z 2026-01-30T14:44:18.313Z
9259699 9259699 20260124232449_5sgi0 FR000A 2026-01-26T14:18:08.565Z 2026-01-30T14:43:51.101Z
9254942 9254942 20260123231913_Mh3td FR000A 2026-01-25T14:11:23.018Z 2026-01-30T14:47:14.034Z
9251806 9251806 20260122230531_KFneX FR000A 2026-01-24T14:13:17.994Z 2026-01-30T14:50:05.121Z
9251375 9251375 20260122195218_gEJAM FR000A 2026-01-24T14:11:29.284Z 2026-01-30T14:49:43.862Z
9208099 9208099 20260115041523_gUSx5 FR000A 2026-01-16T14:11:20.058Z 2026-01-22T15:04:01.280Z
9207717 9207717 20260115025210_ttpfq FR000A 2026-01-16T14:09:46.147Z 2026-01-22T15:03:30.601Z
9207326 9207326 20260115005658_MPDJ9 FR000A 2026-01-16T14:08:17.761Z 2026-01-22T15:03:18.961Z
9207163 9207163 20260114230737_33RHv FR000A 2026-01-16T14:07:28.357Z 2026-01-22T15:03:12.491Z
9195411 9195411 20260113012035_cXyaH FR000A 2026-01-14T14:13:13.198Z 2026-01-21T15:04:40.148Z
9195361 9195361 20260113011217_0TZ8n FR000A 2026-01-14T14:13:04.368Z 2026-01-21T15:04:39.543Z
9182599 9182599 20260111055312_CbJ38 FR000A 2026-01-12T14:15:06.870Z 2026-01-19T15:18:50.958Z
9182377 9182377 20260111051232_s1k6n FR000A 2026-01-12T14:14:17.669Z 2026-01-19T15:18:29.886Z
9182356 9182356 20260111051006_q7enp FR000A 2026-01-12T14:14:15.033Z 2026-01-19T15:18:29.131Z
9182300 9182300 20260111045836_doEdg FR000A 2026-01-12T14:14:04.928Z 2026-01-19T15:18:24.890Z
9182250 9182250 20260111045049_5iQHv FR000A 2026-01-12T14:13:52.939Z 2026-01-19T15:18:22.674Z
9182199 9182199 20260111044120_IIjWO FR000A 2026-01-12T14:13:42.110Z 2026-01-19T15:18:20.451Z
9181958 9181958 20260111034912_3hed2 FR000A 2026-01-12T14:12:43.769Z 2026-01-19T15:17:57.498Z
9181740 9181740 20260111030120_ZJLNL FR000A 2026-01-12T14:11:57.213Z 2026-01-19T15:17:46.650Z
9181491 9181491 20260111015743_UlnJX FR000A 2026-01-12T14:10:58.512Z 2026-01-19T15:17:21.498Z
9181287 9181287 20260111011333_cw49C FR000A 2026-01-12T14:10:15.982Z 2026-01-19T15:17:11.452Z
9181120 9181120 20260111002507_8ewE6 FR000A 2026-01-12T14:09:38.253Z 2026-01-19T15:17:04.324Z
9181028 9181028 20260110235657_Xgjbn FR000A 2026-01-12T14:09:18.452Z 2026-01-19T15:16:44.837Z
9181020 9181020 20260110235541_FAUh3 FR000A 2026-01-12T14:09:15.382Z 2026-01-19T15:16:44.462Z
9180953 9180953 20260110233305_tv0Xb FR000A 2026-01-12T14:09:03.164Z 2026-01-19T15:16:40.562Z
9180950 9180950 20260110233305_TYspX FR000A 2026-01-12T14:09:02.600Z 2026-01-19T15:16:40.048Z
9176828 9176828 20260110062631_INDlL FR000A 2026-01-11T14:10:07.197Z 2026-01-18T15:08:57.871Z
9176424 9176424 20260110052914_rFCKH FR000A 2026-01-11T14:08:57.845Z 2026-01-18T15:08:38.632Z
9162326 9162326 20260107020354_YFH2B FR000A 2026-01-08T14:04:33.826Z 2026-01-13T15:02:01.646Z
9162143 9162143 20260106225352_QfP3w FR000A 2026-01-08T14:03:11.126Z 2026-01-13T15:01:40.022Z
9158095 9158095 20260105200254_fHZ6U FR000A 2026-01-07T14:04:50.274Z 2026-01-13T15:06:54.757Z
9157677 9157677 20260105182341_iCiTI FR000A 2026-01-07T14:03:09.829Z 2026-01-13T15:06:24.094Z
9157574 9157574 20260105175758_dCYnc FR000A 2026-01-07T14:02:41.778Z 2026-01-13T15:06:18.243Z
9149207 9149207 20260104192400_3iEIE FR000A 2026-01-06T14:04:20.962Z 2026-01-13T15:11:48.883Z
9135121 9135121 20260103184112_Dbz1b FR000A 2026-01-05T14:03:44.509Z 2026-01-12T15:00:10.518Z
9128786 9128786 20260101183757_76hin FR000A 2026-01-03T14:23:49.246Z 2026-01-09T14:54:30.528Z
9126804 9126804 20260102005256_78xvV FR000A 2026-01-03T14:06:49.465Z 2026-01-09T14:49:04.493Z
9126479 9126479 20260101213924_EfFB5 FR000A 2026-01-03T14:04:43.647Z 2026-01-09T14:48:45.738Z
9126370 9126370 20260101194449_2jduj FR000A 2026-01-03T14:03:18.857Z 2026-01-09T14:48:21.554Z
9126368 9126368 20260101194436_QtJ2s FR000A 2026-01-03T14:03:14.863Z 2026-01-09T14:48:21.377Z
9126279 9126279 20260101190454_49v2P FR000A 2026-01-03T14:02:09.609Z 2026-01-09T14:48:12.165Z
9122102 9122102 20260101042906_I5oP7 FR000A 2026-01-02T14:11:10.655Z 2026-01-09T14:53:01.132Z
9122100 9122100 20260101042856_WTowS FR000A 2026-01-02T14:11:09.963Z 2026-01-09T14:53:01.016Z
9122084 9122084 20260101042628_4lAdl FR000A 2026-01-02T14:11:02.381Z 2026-01-09T14:52:59.985Z
9121782 9121782 20260101024228_0n2M3 FR000A 2026-01-02T14:09:24.181Z 2026-01-09T14:52:38.512Z
9121707 9121707 20260101014824_yUMNA FR000A 2026-01-02T14:08:52.618Z 2026-01-09T14:52:30.001Z
9121515 9121515 20251231232628_WiWfG FR000A 2026-01-02T14:07:46.388Z 2026-01-09T14:52:13.499Z
9121485 9121485 20251231231423_ah2p4 FR000A 2026-01-02T14:07:38.933Z 2026-01-09T14:52:10.339Z
9121366 9121366 20251231213815_VQzCZ FR000A 2026-01-02T14:06:59.912Z 2026-01-09T14:51:55.195Z
9119504 9119504 20251230181129_COMjJ FR000A 2026-01-01T14:56:20.242Z 2026-01-07T15:12:48.952Z
9116339 9116339 20251231060428_QXOE3 FR000A 2026-01-01T14:27:48.709Z 2026-01-08T15:11:44.010Z
9116335 9116335 20251231060408_nEXlt FR000A 2026-01-01T14:27:48.102Z 2026-01-08T15:11:43.694Z
9116254 9116254 20251231055858_T8klo FR000A 2026-01-01T14:27:35.716Z 2026-01-08T15:11:40.576Z
9116164 9116164 20251231055347_zkk1B FR000A 2026-01-01T14:27:25.038Z 2026-01-08T15:11:36.777Z
9115283 9115283 20251231045657_28lcs FR000A 2026-01-01T14:24:56.126Z 2026-01-08T15:10:40.248Z
9114866 9114866 20251231043346_navTp FR000A 2026-01-01T14:23:42.383Z 2026-01-08T15:10:11.990Z
9114307 9114307 20251231041120_bvEcM FR000A 2026-01-01T14:22:08.015Z 2026-01-08T15:09:42.184Z
9113641 9113641 20251231034035_NS9i6 FR000A 2026-01-01T14:19:51.624Z 2026-01-08T15:08:55.193Z
9113078 9113078 20251231030949_IvKSi FR000A 2026-01-01T14:17:26.795Z 2026-01-08T15:08:22.386Z
9113025 9113025 20251231030808_W3WkT FR000A 2026-01-01T14:17:14.236Z 2026-01-08T15:08:20.418Z
9112487 9112487 20251231023031_wkflX FR000A 2026-01-01T14:15:17.904Z 2026-01-08T15:07:46.548Z
9111722 9111722 20251231013856_BQeIX FR000A 2026-01-01T14:12:35.551Z 2026-01-08T15:06:54.231Z
9111677 9111677 20251231013446_E4VbK FR000A 2026-01-01T14:12:28.254Z 2026-01-08T15:06:50.791Z
9111138 9111138 20251231004200_7EOgl FR000A 2026-01-01T14:10:16.260Z 2026-01-08T15:06:17.755Z
9110951 9110951 20251231002211_3kFC4 FR000A 2026-01-01T14:09:32.064Z 2026-01-08T15:06:08.140Z
9110841 9110841 20251231000723_TG7x1 FR000A 2026-01-01T14:08:59.739Z 2026-01-08T15:05:55.911Z
9109981 9109981 20251230215452_REmYX FR000A 2026-01-01T14:05:10.494Z 2026-01-08T15:04:52.981Z
9074663 9074663 20251225202009_3x4EV FR000A 2025-12-29T15:01:13.713Z 2026-01-02T15:48:35.287Z
9072351 9072351 20251226205423_9hadb FR000A 2025-12-29T14:50:54.342Z 2026-01-03T15:44:03.655Z
9071424 9071424 20251226183845_Y3TD6 FR000A 2025-12-29T14:49:29.039Z 2026-01-03T15:42:54.726Z
9071001 9071001 20251226173923_ukH73 FR000A 2025-12-29T14:48:47.666Z 2025-12-30T15:22:28.052Z
9070819 9070819 20251226171807_2wrVg FR000A 2025-12-29T14:48:23.048Z 2026-01-03T15:42:13.840Z
9063080 9063080 20251226025354_H22fA FR000A 2025-12-29T14:34:40.857Z 2026-01-03T15:35:04.411Z
9062944 9062944 20251226024531_CmYs3 FR000A 2025-12-29T14:34:20.371Z 2026-01-03T15:34:49.393Z
9062366 9062366 20251226020943_1oGR4 FR000A 2025-12-29T14:33:07.793Z 2026-01-03T15:34:16.965Z
9062275 9062275 20251226020214_Kntew FR000A 2025-12-29T14:32:57.515Z 2026-01-03T15:34:14.444Z
9062214 9062214 20251226015813_52HRe FR000A 2025-12-29T14:32:53.139Z 2026-01-03T15:34:12.974Z
9062163 9062163 20251226015534_I2WVb FR000A 2025-12-29T14:32:49.279Z 2026-01-03T15:34:10.240Z
9061793 9061793 20251226012744_Q4hK0 FR000A 2025-12-29T14:32:06.830Z 2025-12-29T14:51:13.426Z
9061002 9061002 20251226002525_2p7LN FR000A 2025-12-29T14:30:24.717Z 2026-01-03T15:33:23.886Z
9060669 9060669 20251226000436_uZFv8 FR000A 2025-12-29T14:29:49.818Z 2025-12-29T14:51:12.812Z
9060218 9060218 20251225233549_uzVIP FR000A 2025-12-29T14:29:03.963Z 2026-01-03T15:32:38.837Z
9060055 9060055 20251225232435_WSXQv FR000A 2025-12-29T14:28:43.204Z 2026-01-03T15:32:32.266Z
9060031 9060031 20251225232250_ZDzJl FR000A 2025-12-29T14:28:39.786Z 2026-01-03T15:32:31.502Z
9059988 9059988 20251225231618_IZSRH FR000A 2025-12-29T14:28:35.367Z 2026-01-03T15:32:30.244Z
9059943 9059943 20251225231122_fAya1 FR000A 2025-12-29T14:28:28.459Z 2026-01-03T15:32:28.751Z
9057411 9057411 20251227050049_z8RtO FR000A 2025-12-29T14:22:59.562Z 2026-01-04T15:29:45.933Z
9057192 9057192 20251227045145_JIUvG FR000A 2025-12-29T14:22:29.523Z 2026-01-04T15:29:26.612Z
9056614 9056614 20251227042505_FuLRt FR000A 2025-12-29T14:21:10.729Z 2026-01-04T15:29:06.978Z
9056296 9056296 20251227040659_Dcb7j FR000A 2025-12-29T14:20:24.790Z 2026-01-04T15:28:47.480Z
9056144 9056144 20251227040024_Ca9eD FR000A 2025-12-29T14:19:59.955Z 2026-01-04T15:28:41.787Z
9055431 9055431 20251227032010_kIpR0 FR000A 2025-12-29T14:18:01.141Z 2025-12-30T15:01:04.080Z
9055408 9055408 20251227031931_HDPa3 FR000A 2025-12-29T14:17:58.145Z 2026-01-04T15:28:03.630Z
9055157 9055157 20251227030832_kiuuk FR000A 2025-12-29T14:17:20.216Z 2026-01-04T15:27:45.008Z
9055068 9055068 20251227030502_FDQAa FR000A 2025-12-29T14:17:02.162Z 2026-01-04T15:27:40.992Z

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