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

>10,000 rows count all where station_code = "AU001E" 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
9851491 9851491 20260504181159_cIcIg AU001E 2026-05-06T12:15:41.537Z 2026-05-06T12:17:26.247Z
9851483 9851483 20260504180605_gxkLI AU001E 2026-05-06T12:15:38.807Z 2026-05-06T12:17:26.223Z
9851459 9851459 20260504174645_VVLVl AU001E 2026-05-06T12:15:30.218Z 2026-05-06T12:17:26.157Z
9851332 9851332 20260504152457_rB4Im AU001E 2026-05-06T12:13:25.068Z 2026-05-06T12:17:25.354Z
9851326 9851326 20260504151018_hpjJk AU001E 2026-05-06T12:13:19.679Z 2026-05-06T12:17:25.310Z
9846536 9846536 20260503180834_kCVSP AU001E 2026-05-05T12:16:51.267Z 2026-05-06T12:21:20.945Z
9846458 9846458 20260503171354_C5u8H AU001E 2026-05-05T12:16:13.107Z 2026-05-06T12:21:15.910Z
9841347 9841347 20260501120042_CXVoa AU001E 2026-05-04T12:21:22.340Z 2026-05-06T12:27:15.094Z
9830186 9830186 20260430213636_0rF8g AU001E 2026-05-02T12:03:10.999Z 2026-05-06T12:25:15.654Z
9829864 9829864 20260430192450_SRh2m AU001E 2026-05-02T12:02:07.809Z 2026-05-06T12:25:04.238Z
9829643 9829643 20260429160853_YKKMD AU001E 2026-05-01T12:28:26.476Z 2026-05-06T12:35:48.968Z
9829601 9829601 20260429113752_d7NRE AU001E 2026-05-01T12:26:44.972Z 2026-05-06T12:34:55.101Z
9824603 9824603 20260429173125_IQjJ6 AU001E 2026-05-01T12:04:03.350Z 2026-05-06T12:28:17.048Z
9797346 9797346 20260425203123_GI84M AU001E 2026-04-27T12:19:03.963Z 2026-05-04T12:43:30.635Z
9796890 9796890 20260425191716_2hG23 AU001E 2026-04-27T12:17:14.624Z 2026-05-04T12:43:03.121Z
9796782 9796782 20260425185706_OSVY3 AU001E 2026-04-27T12:16:42.692Z 2026-05-04T12:43:00.255Z
9796775 9796775 20260425185435_ptqLw AU001E 2026-04-27T12:16:40.694Z 2026-05-04T12:42:58.064Z
9796714 9796714 20260425184220_gni2d AU001E 2026-04-27T12:16:29.055Z 2026-05-04T12:42:56.379Z
9796690 9796690 20260425183753_QiY2m AU001E 2026-04-27T12:16:13.751Z 2026-05-04T12:42:55.599Z
9796684 9796684 20260425183736_qGJS5 AU001E 2026-04-27T12:16:12.202Z 2026-05-04T12:42:55.363Z
9796494 9796494 20260425180514_pKNSX AU001E 2026-04-27T12:15:33.263Z 2026-05-04T12:42:50.584Z
9796448 9796448 20260425175811_IMxCY AU001E 2026-04-27T12:15:18.043Z 2026-05-04T12:42:49.528Z
9795979 9795979 20260425173017_fJj9w AU001E 2026-04-27T12:14:03.863Z 2026-05-04T12:42:41.268Z
9794945 9794945 20260425163200_Ks3jM AU001E 2026-04-27T12:11:10.187Z 2026-05-04T12:42:06.770Z
9794080 9794080 20260425152053_NpleX AU001E 2026-04-27T12:08:33.521Z 2026-05-04T12:41:33.238Z
9793537 9793537 20260425144748_WxhCc AU001E 2026-04-27T12:07:06.300Z 2026-05-04T12:41:25.493Z
9793371 9793371 20260425143214_mIkK4 AU001E 2026-04-27T12:06:30.874Z 2026-05-04T12:41:22.395Z
9790826 9790826 20260424122553_Mp23R AU001E 2026-04-26T12:34:48.988Z 2026-05-02T13:14:38.097Z
9790545 9790545 20260424115812_cphYf AU001E 2026-04-26T12:34:45.131Z 2026-05-02T13:14:32.143Z
9790522 9790522 20260424115704_xPcsu AU001E 2026-04-26T12:34:44.641Z 2026-05-02T13:14:31.842Z
9790360 9790360 20260424114241_y0w42 AU001E 2026-04-26T12:34:41.263Z 2026-05-02T13:14:29.371Z
9790231 9790231 20260424113148_ARy2V AU001E 2026-04-26T12:34:38.561Z 2026-05-02T13:14:26.769Z
9783811 9783811 20260424215108_tcbuH AU001E 2026-04-26T12:15:34.589Z 2026-05-02T12:59:32.066Z
9783006 9783006 20260424202655_f8x4E AU001E 2026-04-26T12:13:27.743Z 2026-05-02T12:58:50.851Z
9782895 9782895 20260424200902_Rucn2 AU001E 2026-04-26T12:13:15.211Z 2026-05-02T12:58:44.712Z
9782849 9782849 20260424200404_xbvwc AU001E 2026-04-26T12:13:01.425Z 2026-05-02T12:58:43.282Z
9782804 9782804 20260424195551_Xqlax AU001E 2026-04-26T12:12:51.148Z 2026-05-02T12:58:42.036Z
9782430 9782430 20260424185956_TZ4R6 AU001E 2026-04-26T12:11:58.495Z 2026-05-02T12:58:12.867Z
9782405 9782405 20260424185717_F7Whv AU001E 2026-04-26T12:11:55.983Z 2026-05-02T12:58:11.608Z
9782102 9782102 20260424180952_XERgB AU001E 2026-04-26T12:11:06.426Z 2026-05-02T12:58:01.123Z
9781555 9781555 20260424173332_Fy3iR AU001E 2026-04-26T12:09:55.013Z 2026-05-02T12:57:32.484Z
9781453 9781453 20260424172835_1X9sA AU001E 2026-04-26T12:09:42.781Z 2026-05-02T12:57:26.600Z
9780630 9780630 20260424164302_D8tyY AU001E 2026-04-26T12:08:04.103Z 2026-05-02T12:57:07.858Z
9779871 9779871 20260424155940_jzSkv AU001E 2026-04-26T12:06:33.364Z 2026-05-02T12:56:35.671Z
9779779 9779779 20260424155452_2EPLo AU001E 2026-04-26T12:06:28.261Z 2026-05-02T12:56:34.234Z
9778478 9778478 20260424144520_6Si7g AU001E 2026-04-26T12:03:48.251Z 2026-05-02T12:55:37.500Z
9776505 9776505 20260423114929_BJIBo AU001E 2026-04-25T12:58:37.069Z 2026-04-30T13:15:11.360Z
9763484 9763484 20260423181312_drAr6 AU001E 2026-04-25T12:12:49.823Z 2026-05-02T13:07:34.620Z
9762131 9762131 20260423161755_eYoUF AU001E 2026-04-25T12:08:40.791Z 2026-05-02T13:06:30.781Z
9761512 9761512 20260423153433_58SPS AU001E 2026-04-25T12:06:46.425Z 2026-05-02T13:06:07.112Z
9761232 9761232 20260423151942_QtkZN AU001E 2026-04-25T12:06:12.142Z 2026-05-02T13:06:02.223Z
9760884 9760884 20260423144902_chsSB AU001E 2026-04-25T12:05:10.649Z 2026-05-02T13:05:47.963Z
9760541 9760541 20260423142339_wsoeG AU001E 2026-04-25T12:04:04.935Z 2026-05-02T13:05:24.988Z
9759985 9759985 20260423133529_vsPIj AU001E 2026-04-25T12:02:24.204Z 2026-05-02T13:05:14.741Z
9759814 9759814 20260423131749_Dw0R5 AU001E 2026-04-25T12:01:52.515Z 2026-05-02T13:05:11.099Z
9747320 9747320 20260422175848_y4Tyh AU001E 2026-04-24T12:02:38.739Z 2026-04-30T13:06:53.422Z
9744931 9744931 20260422154043_nx302 AU001E 2026-04-24T12:01:44.026Z 2026-04-30T13:05:34.464Z
9744590 9744590 20260422152415_Ifgp2 AU001E 2026-04-24T12:01:37.113Z 2026-04-30T13:05:24.976Z
9744277 9744277 20260422150653_ktMoN AU001E 2026-04-24T12:01:27.082Z 2026-04-30T13:05:22.421Z
9743067 9743067 20260422134341_9aMig AU001E 2026-04-24T12:00:49.679Z 2026-04-30T13:05:06.474Z
9742303 9742303 20260422123841_UunRq AU001E 2026-04-24T12:00:26.207Z 2026-04-30T13:04:58.925Z
9742202 9742202 20260422122938_0aNYt AU001E 2026-04-24T12:00:23.554Z 2026-04-30T13:04:48.049Z
9742183 9742183 20260422122638_e6Rso AU001E 2026-04-24T12:00:22.822Z 2026-04-30T13:04:43.145Z
9742138 9742138 20260422121936_Yk45w AU001E 2026-04-24T12:00:21.098Z 2026-04-30T13:04:40.179Z
9742018 9742018 20260422120321_hCgkA AU001E 2026-04-24T12:00:17.628Z 2026-04-30T13:04:36.111Z
9741846 9741846 20260421110628_bqMwn AU001E 2026-04-23T12:38:37.107Z 2026-04-29T13:23:13.175Z
9731825 9731825 20260421200015_gpIOk AU001E 2026-04-23T12:07:39.255Z 2026-04-30T13:16:52.879Z
9731751 9731751 20260421194039_tTaJC AU001E 2026-04-23T12:07:17.856Z 2026-04-30T13:16:51.926Z
9731577 9731577 20260421183129_xwDdP AU001E 2026-04-23T12:06:38.963Z 2026-04-30T13:16:49.646Z
9731575 9731575 20260421183057_PtTSa AU001E 2026-04-23T12:06:38.461Z 2026-04-30T13:16:49.568Z
9731400 9731400 20260421172530_w9moR AU001E 2026-04-23T12:05:36.848Z 2026-04-30T13:16:45.875Z
9731365 9731365 20260421171402_dBDs3 AU001E 2026-04-23T12:05:23.370Z 2026-04-30T13:16:39.071Z
9731355 9731355 20260421171145_1TFPD AU001E 2026-04-23T12:05:19.842Z 2026-04-30T13:16:37.678Z
9731225 9731225 20260421162039_09G3f AU001E 2026-04-23T12:04:41.332Z 2026-04-30T13:16:00.547Z
9731144 9731144 20260421155149_MDASA AU001E 2026-04-23T12:04:10.353Z 2026-04-30T13:15:59.145Z
9730855 9730855 20260421140124_ini3c AU001E 2026-04-23T12:02:37.520Z 2026-04-30T13:15:51.292Z
9730679 9730679 20260421124232_mHF5Q AU001E 2026-04-23T12:01:32.082Z 2026-04-30T13:15:47.342Z
9730564 9730564 20260421113815_Hl76k AU001E 2026-04-23T12:00:54.639Z 2026-04-30T13:15:44.646Z
9724313 9724313 20260420212436_esMQN AU001E 2026-04-22T12:13:49.068Z 2026-04-29T13:19:14.844Z
9724231 9724231 20260420211547_acNBb AU001E 2026-04-22T12:13:41.294Z 2026-04-29T13:19:14.135Z
9724212 9724212 20260420211427_IV02H AU001E 2026-04-22T12:13:39.303Z 2026-04-29T13:19:13.931Z
9724172 9724172 20260420211001_hu4VI AU001E 2026-04-22T12:13:29.499Z 2026-04-29T13:19:13.417Z
9723890 9723890 20260420203734_3sm3C AU001E 2026-04-22T12:12:38.989Z 2026-04-29T13:19:09.844Z
9723764 9723764 20260420201747_PMKax AU001E 2026-04-22T12:12:08.626Z 2026-04-29T13:19:08.225Z
9723721 9723721 20260420200542_3HIPw AU001E 2026-04-22T12:11:49.135Z 2026-04-29T13:19:07.274Z
9723012 9723012 20260420171109_CGzHf AU001E 2026-04-22T12:09:05.942Z 2026-04-29T13:18:16.295Z
9717224 9717224 20260419211725_Cbx0Z AU001E 2026-04-21T12:19:05.105Z 2026-04-28T13:37:05.954Z
9717192 9717192 20260419211632_3w6gJ AU001E 2026-04-21T12:18:59.887Z 2026-04-28T13:37:05.666Z
9717067 9717067 20260419205614_gEu2V AU001E 2026-04-21T12:18:35.936Z 2026-04-28T13:37:03.346Z
9717045 9717045 20260419205314_1RrDh AU001E 2026-04-21T12:18:28.623Z 2026-04-28T13:37:02.956Z
9716925 9716925 20260419203026_0CBV9 AU001E 2026-04-21T12:18:00.558Z 2026-04-28T13:36:54.102Z
9716845 9716845 20260419201953_vqubd AU001E 2026-04-21T12:17:38.932Z 2026-04-28T13:36:34.102Z
9716808 9716808 20260419200739_ZS4Tk AU001E 2026-04-21T12:17:29.371Z 2026-04-28T13:36:26.485Z
9716782 9716782 20260419195306_GLGpW AU001E 2026-04-21T12:17:24.312Z 2026-04-28T13:36:15.733Z
9716536 9716536 20260419185826_H5vGG AU001E 2026-04-21T12:16:22.689Z 2026-04-28T13:36:05.894Z
9716083 9716083 20260419173445_eeP0j AU001E 2026-04-21T12:14:46.251Z 2026-04-28T13:35:57.653Z
9715936 9715936 20260419170511_QOxer AU001E 2026-04-21T12:14:07.820Z 2026-04-28T13:35:53.534Z
9715260 9715260 20260419141331_I9wm4 AU001E 2026-04-21T12:10:52.850Z 2026-04-28T13:34:46.298Z
9715246 9715246 20260419141229_g6rvs AU001E 2026-04-21T12:10:49.554Z 2026-04-28T13:34:45.976Z
9715191 9715191 20260419135849_XcfBo AU001E 2026-04-21T12:10:32.475Z 2026-04-28T13:34:44.744Z

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