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,321 rows where station_code = "FR000U" 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
9267637 9267637 20260127035522_FCUD9 FR000U 2026-01-28T14:22:38.307Z 2026-01-30T14:36:44.587Z
9267576 9267576 20260127031702_m136y FR000U 2026-01-28T14:22:22.913Z 2026-01-30T14:36:37.967Z
9262915 9262915 20260126045139_ccSIb FR000U 2026-01-27T14:16:06.875Z 2026-01-30T14:40:24.500Z
9203502 9203502 20260114051153_x4adx FR000U 2026-01-15T14:24:35.868Z 2026-01-22T15:10:08.916Z
9203398 9203398 20260114045352_yK0Hi FR000U 2026-01-15T14:24:19.724Z 2026-01-22T15:10:06.887Z
9203166 9203166 20260114043842_gFKw4 FR000U 2026-01-15T14:23:28.359Z 2026-01-22T15:10:02.911Z
9188553 9188553 20260112003957_baTJn FR000U 2026-01-13T14:12:57.936Z 2026-01-20T15:21:58.793Z
9181966 9181966 20260111035138_1PEei FR000U 2026-01-12T14:12:45.620Z 2026-01-19T15:17:58.076Z
9181901 9181901 20260111033737_oWf23 FR000U 2026-01-12T14:12:32.621Z 2026-01-19T15:17:53.231Z
9180750 9180750 20260110221017_1Oz8R FR000U 2026-01-12T14:08:15.524Z 2026-01-19T15:16:30.878Z
9180303 9180303 20260110195449_ZrTMj FR000U 2026-01-12T14:06:37.874Z 2026-01-19T15:15:55.642Z
9167722 9167722 20260108043146_3SybU FR000U 2026-01-09T14:08:58.300Z 2026-01-16T15:11:46.541Z
9167681 9167681 20260108041052_C8BPk FR000U 2026-01-09T14:08:49.141Z 2026-01-16T15:11:41.627Z
9167381 9167381 20260108011016_aZh6t FR000U 2026-01-09T14:07:30.428Z 2026-01-16T15:11:15.367Z
9167115 9167115 20260107224733_fyFsV FR000U 2026-01-09T14:06:19.786Z 2026-01-16T15:10:50.710Z
8995269 8995269 20251217234944_kbbGP FR000U 2025-12-26T15:05:21.691Z 2025-12-26T15:05:21.691Z
8995255 8995255 20251217234501_kB6X2 FR000U 2025-12-26T15:05:20.251Z 2025-12-26T15:05:20.251Z
8994902 8994902 20251217215332_tW8EH FR000U 2025-12-26T15:04:45.106Z 2025-12-26T15:04:45.106Z
8985670 8985670 20251218025605_ZjPyx FR000U 2025-12-26T14:35:38.035Z 2025-12-27T15:19:03.302Z
8951981 8951981 20251215021118_hCPL3 FR000U 2025-12-24T15:09:17.212Z 2025-12-24T15:09:17.212Z
8950992 8950992 20251215011906_AF9aD FR000U 2025-12-24T15:07:43.488Z 2025-12-24T15:07:43.488Z
8950862 8950862 20251215011330_FuNQI FR000U 2025-12-24T15:07:39.318Z 2025-12-24T15:07:39.318Z
8947958 8947958 20251214230015_O7xVa FR000U 2025-12-24T15:04:28.849Z 2025-12-24T15:04:28.849Z
8947723 8947723 20251214224840_RMHRF FR000U 2025-12-24T15:04:23.808Z 2025-12-24T15:04:23.808Z
8947564 8947564 20251214223942_uza4D FR000U 2025-12-24T15:04:21.623Z 2025-12-24T15:04:21.623Z
8947529 8947529 20251214223750_Pmibf FR000U 2025-12-24T15:04:21.303Z 2025-12-24T15:04:21.303Z
8947503 8947503 20251214223733_uEzw6 FR000U 2025-12-24T15:04:21.202Z 2025-12-24T15:04:21.202Z
8947476 8947476 20251214223641_o8XeZ FR000U 2025-12-24T15:04:20.989Z 2025-12-24T15:04:20.989Z
8947306 8947306 20251214222812_Zx0Us FR000U 2025-12-24T15:04:18.121Z 2025-12-24T15:04:18.121Z
8946559 8946559 20251214214838_iszw4 FR000U 2025-12-24T15:03:38.027Z 2025-12-24T15:03:38.027Z
8946416 8946416 20251214214208_BHjzS FR000U 2025-12-24T15:03:22.621Z 2025-12-24T15:03:22.621Z
8946213 8946213 20251214213122_YyBHM FR000U 2025-12-24T15:03:06.682Z 2025-12-24T15:03:06.682Z
8944939 8944939 20251214204414_2FS8G FR000U 2025-12-24T15:02:13.907Z 2025-12-24T15:02:13.907Z
8944921 8944921 20251214204339_2FsNy FR000U 2025-12-24T15:02:09.435Z 2025-12-24T15:02:09.435Z
8944012 8944012 20251214201247_YjWw3 FR000U 2025-12-24T15:00:13.691Z 2025-12-24T15:00:13.691Z
8943622 8943622 20251214195727_gfsKO FR000U 2025-12-24T14:59:58.763Z 2025-12-24T14:59:58.763Z
8943530 8943530 20251214195326_K9MmB FR000U 2025-12-24T14:59:56.927Z 2025-12-24T14:59:56.927Z
8943524 8943524 20251214195240_PDKjO FR000U 2025-12-24T14:59:56.877Z 2025-12-24T14:59:56.877Z
8943120 8943120 20251214194042_OwDuR FR000U 2025-12-24T14:59:28.135Z 2025-12-24T14:59:28.135Z
8943034 8943034 20251214193724_oX6eU FR000U 2025-12-24T14:59:23.165Z 2025-12-24T14:59:23.165Z
8942794 8942794 20251214193051_2zAAt FR000U 2025-12-24T14:58:47.001Z 2025-12-24T14:58:47.001Z
8942771 8942771 20251214193024_ALmPo FR000U 2025-12-24T14:58:41.986Z 2025-12-24T14:58:41.986Z
8942515 8942515 20251214192408_9WpP9 FR000U 2025-12-24T14:58:29.021Z 2025-12-24T14:58:29.021Z
8941944 8941944 20251214190528_Iihkl FR000U 2025-12-24T14:58:13.742Z 2025-12-24T14:58:13.742Z
8941932 8941932 20251214190526_vF2bV FR000U 2025-12-24T14:58:13.653Z 2025-12-24T14:58:13.653Z
8941837 8941837 20251214190117_OfpXp FR000U 2025-12-24T14:58:01.495Z 2025-12-24T14:58:01.495Z
8941775 8941775 20251214185943_yKKQ2 FR000U 2025-12-24T14:57:58.187Z 2025-12-24T14:57:58.187Z
8941700 8941700 20251214185642_Kik3x FR000U 2025-12-24T14:57:48.597Z 2025-12-24T14:57:48.597Z
8941113 8941113 20251214183824_qcgqi FR000U 2025-12-24T14:56:54.271Z 2025-12-24T14:56:54.271Z
8939436 8939436 20251214175906_h5uXH FR000U 2025-12-24T14:55:23.337Z 2025-12-24T14:55:23.337Z
8939115 8939115 20251214174857_FKrt0 FR000U 2025-12-24T14:55:12.609Z 2025-12-24T14:55:12.609Z
8938855 8938855 20251214174049_2gqFQ FR000U 2025-12-24T14:55:06.889Z 2025-12-24T14:55:06.889Z
8926631 8926631 20251215031710_WYD6V FR000U 2025-12-24T14:04:29.931Z 2025-12-24T15:09:29.410Z
8905159 8905159 20251214052655_6uqbr FR000U 2025-12-23T14:07:47.737Z 2025-12-24T14:20:36.064Z
8905133 8905133 20251214052616_LSMt2 FR000U 2025-12-23T14:07:46.601Z 2025-12-24T14:20:35.735Z
8904899 8904899 20251214052315_er362 FR000U 2025-12-23T14:07:35.367Z 2025-12-24T14:20:32.951Z
8904860 8904860 20251214052247_tI9Bc FR000U 2025-12-23T14:07:34.825Z 2025-12-24T14:20:32.555Z
8904719 8904719 20251214052120_9QPMV FR000U 2025-12-23T14:07:32.217Z 2025-12-24T14:20:30.966Z
8904360 8904360 20251214051710_qym9R FR000U 2025-12-23T14:07:16.708Z 2025-12-24T14:20:26.357Z
8904324 8904324 20251214051642_ndOFp FR000U 2025-12-23T14:07:13.617Z 2025-12-24T14:20:25.851Z
8904217 8904217 20251214051523_zY2MV FR000U 2025-12-23T14:07:08.437Z 2025-12-24T14:20:24.039Z
8904121 8904121 20251214051429_LRy8g FR000U 2025-12-23T14:07:01.972Z 2025-12-24T14:20:22.206Z
8903875 8903875 20251214051106_c2ucd FR000U 2025-12-23T14:06:42.984Z 2025-12-24T14:20:05.920Z
8903798 8903798 20251214051028_UNAJZ FR000U 2025-12-23T14:06:39.440Z 2025-12-24T14:19:54.974Z
8903631 8903631 20251214050748_9Mqyy FR000U 2025-12-23T14:06:34.377Z 2025-12-24T14:19:47.197Z
8903394 8903394 20251214050441_K22GN FR000U 2025-12-23T14:06:20.723Z 2025-12-24T14:19:40.103Z
8903050 8903050 20251214050038_zbkEu FR000U 2025-12-23T14:05:56.685Z 2025-12-24T14:19:34.561Z
8901828 8901828 20251214044915_wpQ2l FR000U 2025-12-23T14:05:49.059Z 2025-12-24T14:18:53.073Z
8901684 8901684 20251214044750_qpQ90 FR000U 2025-12-23T14:05:47.840Z 2025-12-24T14:18:49.981Z
8901093 8901093 20251214044208_zzdN9 FR000U 2025-12-23T14:05:43.163Z 2025-12-24T14:18:40.988Z
8900987 8900987 20251214044055_32tVK FR000U 2025-12-23T14:05:41.719Z 2025-12-24T14:18:39.162Z
8900760 8900760 20251214043846_XXkq3 FR000U 2025-12-23T14:05:20.474Z 2025-12-24T14:18:22.248Z
8900235 8900235 20251214043317_BQD62 FR000U 2025-12-23T14:04:50.129Z 2025-12-24T14:17:59.363Z
8900151 8900151 20251214043233_hzcmw FR000U 2025-12-23T14:04:46.194Z 2025-12-24T14:17:58.262Z
8900136 8900136 20251214043227_sddcL FR000U 2025-12-23T14:04:45.918Z 2025-12-24T14:17:58.083Z
8899874 8899874 20251214042915_abCwt FR000U 2025-12-23T14:04:33.390Z 2025-12-24T14:17:52.821Z
8899473 8899473 20251214042512_0b8HM FR000U 2025-12-23T14:04:10.771Z 2025-12-24T14:17:45.617Z
8899286 8899286 20251214042415_kYEUG FR000U 2025-12-23T14:04:08.784Z 2025-12-24T14:17:42.299Z
8898661 8898661 20251214041710_22gM9 FR000U 2025-12-23T14:04:02.028Z 2025-12-24T14:17:07.631Z
8898579 8898579 20251214041627_kvcNA FR000U 2025-12-23T14:04:01.484Z 2025-12-24T14:17:06.460Z
8898406 8898406 20251214041523_XuBRZ FR000U 2025-12-23T14:04:00.301Z 2025-12-24T14:17:04.595Z
8898284 8898284 20251214041421_ak3xY FR000U 2025-12-23T14:03:59.207Z 2025-12-24T14:17:00.882Z
8898200 8898200 20251214041402_B9tPL FR000U 2025-12-23T14:03:58.520Z 2025-12-24T14:16:59.607Z
8898158 8898158 20251214041336_qmDV8 FR000U 2025-12-23T14:03:58.217Z 2025-12-24T14:16:59.288Z
8897917 8897917 20251214025406_KVrGW FR000U 2025-12-22T14:12:31.031Z 2025-12-23T14:28:02.908Z
8897882 8897882 20251214025347_aGkZd FR000U 2025-12-22T14:12:30.502Z 2025-12-23T14:28:02.692Z
8897861 8897861 20251214025342_EPCWv FR000U 2025-12-22T14:12:29.939Z 2025-12-23T14:28:02.657Z
8897314 8897314 20251214024739_f34CM FR000U 2025-12-22T14:12:23.011Z 2025-12-23T14:27:58.295Z
8896275 8896275 20251214023941_nASjY FR000U 2025-12-22T14:12:15.143Z 2025-12-23T14:27:55.146Z
8895095 8895095 20251214022930_rrbYK FR000U 2025-12-22T14:12:07.705Z 2025-12-23T14:27:53.359Z
8894971 8894971 20251214022841_dbpMR FR000U 2025-12-22T14:12:06.061Z 2025-12-23T14:27:53.235Z
8894479 8894479 20251214022450_LZVbu FR000U 2025-12-22T14:12:03.284Z 2025-12-23T14:27:52.808Z
8893841 8893841 20251214021909_skcXu FR000U 2025-12-22T14:11:59.725Z 2025-12-23T14:27:51.910Z
8893817 8893817 20251214021858_sR6gx FR000U 2025-12-22T14:11:59.685Z 2025-12-23T14:27:51.894Z
8893590 8893590 20251214021729_OxC3J FR000U 2025-12-22T14:11:58.795Z 2025-12-23T14:27:51.185Z
8893558 8893558 20251214021715_NNNWR FR000U 2025-12-22T14:11:58.753Z 2025-12-23T14:27:51.161Z
8893496 8893496 20251214021636_MQU19 FR000U 2025-12-22T14:11:58.319Z 2025-12-23T14:27:50.490Z
8893330 8893330 20251214021454_5Wf2u FR000U 2025-12-22T14:11:55.793Z 2025-12-23T14:27:49.665Z
8893306 8893306 20251214021452_W5X59 FR000U 2025-12-22T14:11:55.581Z 2025-12-23T14:27:49.654Z
8893183 8893183 20251214021358_TbrVu FR000U 2025-12-22T14:11:53.583Z 2025-12-23T14:27:49.176Z

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