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,700 rows where station_code = "US005F" 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
9607079 9607079 20260404032800_LLiO2 US005F 2026-04-05T12:00:21.423Z 2026-04-06T12:16:14.356Z
9605329 9605329 20260403084513_P3UAf US005F 2026-04-04T12:01:49.481Z 2026-04-06T12:17:42.789Z
9603716 9603716 20260402115741_DgWFA US005F 2026-04-03T12:04:17.748Z 2026-04-06T12:22:24.237Z
9603682 9603682 20260402114754_s3oNX US005F 2026-04-03T12:04:10.632Z 2026-04-06T12:22:22.028Z
9603415 9603415 20260402100756_vWTC5 US005F 2026-04-03T12:03:00.319Z 2026-04-06T12:21:59.085Z
9590380 9590380 20260328084204_Xn2xb US005F 2026-03-29T12:02:31.133Z 2026-04-06T12:38:04.136Z
9587215 9587215 20260327114440_Mbwci US005F 2026-03-28T12:05:02.605Z 2026-04-05T12:34:08.719Z
9587162 9587162 20260327113030_PgS3G US005F 2026-03-28T12:04:55.370Z 2026-04-05T12:34:04.787Z
9587157 9587157 20260327112931_7RfZW US005F 2026-03-28T12:04:54.919Z 2026-04-05T12:34:04.660Z
9586951 9586951 20260327102523_SVm37 US005F 2026-03-28T12:04:25.893Z 2026-04-05T12:33:55.714Z
9586868 9586868 20260327100224_w9RYr US005F 2026-03-28T12:04:15.651Z 2026-04-05T12:33:52.526Z
9586527 9586527 20260327081224_PCOYJ US005F 2026-03-28T12:03:20.647Z 2026-04-05T12:33:29.337Z
9586214 9586214 20260327045750_e4blm US005F 2026-03-28T12:02:32.244Z 2026-04-05T12:33:08.338Z
9583080 9583080 20260326105103_HHLZ8 US005F 2026-03-27T12:07:38.317Z 2026-04-04T12:40:44.659Z
9582376 9582376 20260326070735_ZHgde US005F 2026-03-27T12:05:34.765Z 2026-04-04T12:39:58.290Z
9582243 9582243 20260326053927_UYfjH US005F 2026-03-27T12:05:04.939Z 2026-04-04T12:39:44.598Z
9578610 9578610 20260325123655_MnDa4 US005F 2026-03-26T12:08:05.085Z 2026-04-03T12:38:10.924Z
9577981 9577981 20260325092552_NyDvI US005F 2026-03-26T12:06:30.548Z 2026-04-03T12:37:33.235Z
9577970 9577970 20260325092448_ovagd US005F 2026-03-26T12:06:29.235Z 2026-04-03T12:37:32.888Z
9577425 9577425 20260325060741_nwIX0 US005F 2026-03-26T12:05:06.448Z 2026-04-03T12:37:01.136Z
9577417 9577417 20260325060204_hLx97 US005F 2026-03-26T12:05:05.199Z 2026-04-03T12:37:00.840Z
9577346 9577346 20260325050402_ydp3q US005F 2026-03-26T12:04:51.504Z 2026-04-03T12:36:57.859Z
9577284 9577284 20260325043932_wT70g US005F 2026-03-26T12:04:39.932Z 2026-04-03T12:36:55.061Z
9573473 9573473 20260324121937_LmHaZ US005F 2026-03-25T12:08:06.028Z 2026-04-02T12:36:10.777Z
9573267 9573267 20260324114235_vl2bM US005F 2026-03-25T12:07:36.589Z 2026-04-02T12:36:02.103Z
9572789 9572789 20260324102100_Hsa3F US005F 2026-03-25T12:06:18.666Z 2026-04-02T12:35:38.159Z
9572723 9572723 20260324100311_qXwPf US005F 2026-03-25T12:06:08.820Z 2026-04-02T12:35:36.391Z
9572511 9572511 20260324092101_2erKI US005F 2026-03-25T12:05:25.913Z 2026-04-02T12:35:28.084Z
9572102 9572102 20260324073518_8yBUy US005F 2026-03-25T12:03:49.241Z 2026-04-02T12:35:03.394Z
9572059 9572059 20260324071903_RtCXd US005F 2026-03-25T12:03:38.098Z 2026-04-02T12:35:01.258Z
9571904 9571904 20260324054041_ONEOB US005F 2026-03-25T12:03:08.788Z 2026-04-02T12:34:54.473Z
9565866 9565866 20260323124524_2BoPg US005F 2026-03-24T12:10:57.279Z 2026-03-31T12:27:42.506Z
9565779 9565779 20260323124045_esOV2 US005F 2026-03-24T12:10:50.817Z 2026-03-31T12:27:41.280Z
9565479 9565479 20260323121153_mXpzA US005F 2026-03-24T12:10:15.644Z 2026-03-31T12:27:36.135Z
9565422 9565422 20260323120805_Z0tOT US005F 2026-03-24T12:10:04.517Z 2026-03-31T12:27:34.884Z
9564062 9564062 20260323095623_BfvZQ US005F 2026-03-24T12:07:21.048Z 2026-03-31T12:27:01.800Z
9564014 9564014 20260323094934_CePBK US005F 2026-03-24T12:07:12.635Z 2026-03-31T12:27:00.962Z
9563113 9563113 20260323065927_UL58s US005F 2026-03-24T12:05:08.790Z 2026-03-31T12:26:35.464Z
9557006 9557006 20260322123303_B99xR US005F 2026-03-23T12:05:27.683Z 2026-03-30T12:29:18.513Z
9556835 9556835 20260322115256_dqGg5 US005F 2026-03-23T12:05:16.052Z 2026-03-30T12:29:12.368Z
9556495 9556495 20260322104525_hchhf US005F 2026-03-23T12:04:51.591Z 2026-03-30T12:29:02.694Z
9555711 9555711 20260322073806_zpx73 US005F 2026-03-23T12:03:48.556Z 2026-03-30T12:28:32.809Z
9555541 9555541 20260322062016_fG2sL US005F 2026-03-23T12:03:36.000Z 2026-03-30T12:28:28.898Z
9546607 9546607 20260321121210_KIDeZ US005F 2026-03-22T12:12:07.715Z 2026-03-29T12:20:02.708Z
9546142 9546142 20260321114008_A93T3 US005F 2026-03-22T12:11:10.352Z 2026-03-29T12:19:47.942Z
9545759 9545759 20260321110452_XsABM US005F 2026-03-22T12:10:09.839Z 2026-03-29T12:19:43.086Z
9544846 9544846 20260321093109_X7iog US005F 2026-03-22T12:07:58.308Z 2026-03-29T12:19:34.561Z
9544339 9544339 20260321082115_ku2kC US005F 2026-03-22T12:06:31.125Z 2026-03-29T12:19:28.581Z
9544241 9544241 20260321080615_PU6Lu US005F 2026-03-22T12:06:12.336Z 2026-03-29T12:19:24.543Z
9544147 9544147 20260321074438_aIE2C US005F 2026-03-22T12:05:51.756Z 2026-03-29T12:19:16.851Z
9543833 9543833 20260321054448_sH0Ua US005F 2026-03-22T12:04:53.616Z 2026-03-29T12:19:11.758Z
9537907 9537907 20260320121254_c7YJx US005F 2026-03-21T12:16:41.088Z 2026-03-28T12:35:30.590Z
9537423 9537423 20260320113629_j9PuL US005F 2026-03-21T12:15:44.954Z 2026-03-28T12:35:25.858Z
9537419 9537419 20260320113612_pP31Z US005F 2026-03-21T12:15:44.078Z 2026-03-28T12:35:25.833Z
9537383 9537383 20260320113445_6lDl3 US005F 2026-03-21T12:15:39.431Z 2026-03-28T12:35:25.552Z
9537328 9537328 20260320112902_G7Wox US005F 2026-03-21T12:15:33.432Z 2026-03-28T12:35:24.954Z
9537114 9537114 20260320110640_lncc3 US005F 2026-03-21T12:15:06.488Z 2026-03-28T12:35:21.661Z
9537014 9537014 20260320105810_mHlfU US005F 2026-03-21T12:14:55.608Z 2026-03-28T12:35:20.219Z
9536893 9536893 20260320104255_iePIu US005F 2026-03-21T12:14:37.991Z 2026-03-28T12:35:18.484Z
9536890 9536890 20260320104240_CGcky US005F 2026-03-21T12:14:37.580Z 2026-03-28T12:35:18.418Z
9536848 9536848 20260320103758_qEjNH US005F 2026-03-21T12:14:31.621Z 2026-03-28T12:35:17.324Z
9536704 9536704 20260320102131_kxq11 US005F 2026-03-21T12:14:08.849Z 2026-03-28T12:35:05.424Z
9536410 9536410 20260320094708_KPKXH US005F 2026-03-21T12:13:21.940Z 2026-03-28T12:35:01.439Z
9535928 9535928 20260320084710_mtawO US005F 2026-03-21T12:12:10.892Z 2026-03-28T12:34:53.911Z
9535715 9535715 20260320082538_ceiO3 US005F 2026-03-21T12:11:40.736Z 2026-03-28T12:34:49.721Z
9535584 9535584 20260320080342_QD5cA US005F 2026-03-21T12:11:15.007Z 2026-03-28T12:34:47.376Z
9535120 9535120 20260320054122_ikb7u US005F 2026-03-21T12:09:48.761Z 2026-03-28T12:34:27.798Z
9535043 9535043 20260320051724_pI7M3 US005F 2026-03-21T12:09:34.873Z 2026-03-28T12:34:26.175Z
9524617 9524617 20260319121805_vblq2 US005F 2026-03-20T12:13:16.218Z 2026-03-27T12:41:54.699Z
9524611 9524611 20260319121801_zdB1H US005F 2026-03-20T12:13:15.553Z 2026-03-27T12:41:54.633Z
9524596 9524596 20260319121720_N39ez US005F 2026-03-20T12:13:11.684Z 2026-03-27T12:41:54.533Z
9524319 9524319 20260319114303_nAC6e US005F 2026-03-20T12:12:49.575Z 2026-03-27T12:41:51.243Z
9524284 9524284 20260319113703_YTvD9 US005F 2026-03-20T12:12:43.290Z 2026-03-27T12:41:50.774Z
9523592 9523592 20260319102109_uyGVh US005F 2026-03-20T12:11:42.403Z 2026-03-27T12:41:30.455Z
9523405 9523405 20260319095811_tHFsJ US005F 2026-03-20T12:11:23.509Z 2026-03-27T12:41:28.681Z
9523373 9523373 20260319095333_v08OJ US005F 2026-03-20T12:11:17.563Z 2026-03-27T12:41:28.204Z
9522945 9522945 20260319090945_c22St US005F 2026-03-20T12:10:37.531Z 2026-03-27T12:41:23.189Z
9522860 9522860 20260319090212_xHzOc US005F 2026-03-20T12:10:27.226Z 2026-03-27T12:41:22.270Z
9522326 9522326 20260319072653_r3RCM US005F 2026-03-20T12:09:36.746Z 2026-03-27T12:41:16.752Z
9522316 9522316 20260319072610_TzAEa US005F 2026-03-20T12:09:35.588Z 2026-03-27T12:41:16.655Z
9522212 9522212 20260319065248_eyZgS US005F 2026-03-20T12:09:19.803Z 2026-03-27T12:41:15.218Z
9522155 9522155 20260319062441_cww4B US005F 2026-03-20T12:09:11.092Z 2026-03-27T12:41:14.406Z
9520343 9520343 20260319031053_iT5UF US005F 2026-03-20T12:06:15.382Z 2026-03-27T12:40:42.188Z
9515097 9515097 20260318124219_mOzVu US005F 2026-03-19T12:19:03.721Z 2026-03-26T12:38:21.765Z
9514978 9514978 20260318122349_MeuMj US005F 2026-03-19T12:18:46.133Z 2026-03-26T12:38:20.929Z
9514653 9514653 20260318114741_ZADpT US005F 2026-03-19T12:18:03.244Z 2026-03-26T12:38:18.012Z
9514408 9514408 20260318112403_Qfrgs US005F 2026-03-19T12:17:24.211Z 2026-03-26T12:38:16.131Z
9514082 9514082 20260318104350_ULGUN US005F 2026-03-19T12:16:47.424Z 2026-03-26T12:38:13.897Z
9513705 9513705 20260318095300_Wu2IX US005F 2026-03-19T12:15:57.621Z 2026-03-26T12:37:59.175Z
9513671 9513671 20260318094914_RnVfx US005F 2026-03-19T12:15:53.570Z 2026-03-26T12:37:57.342Z
9513516 9513516 20260318092847_l2Ct3 US005F 2026-03-19T12:15:32.246Z 2026-03-26T12:37:55.995Z
9512361 9512361 20260318053520_R5Znd US005F 2026-03-19T12:12:18.516Z 2026-03-26T12:37:44.414Z
9512316 9512316 20260318050848_Yspkk US005F 2026-03-19T12:12:09.711Z 2026-03-26T12:37:43.922Z
9511892 9511892 20260318042754_oW4Xu US005F 2026-03-19T12:11:16.821Z 2026-03-26T12:37:40.602Z
9510925 9510925 20260318032408_RZLoy US005F 2026-03-19T12:09:00.983Z 2026-03-26T12:37:17.992Z
9510297 9510297 20260318024246_25S9o US005F 2026-03-19T12:07:17.830Z 2026-03-26T12:37:11.419Z
9503820 9503820 20260317095701_7gbo6 US005F 2026-03-18T12:06:33.271Z 2026-03-25T12:42:18.112Z
9503320 9503320 20260317083120_58OQx US005F 2026-03-18T12:05:23.336Z 2026-03-25T12:42:15.284Z
9503113 9503113 20260317080428_DhX3N US005F 2026-03-18T12:04:57.235Z 2026-03-25T12:42:13.787Z
9502963 9502963 20260317072908_rpRku US005F 2026-03-18T12:04:32.915Z 2026-03-25T12:42:05.297Z

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