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

3,981 rows where station_code = "AU002C" 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
8667262 8667262 20251129193137_SXtN2 AU002C 2025-12-02T14:35:58.530Z 2025-12-06T14:45:49.190Z
8666974 8666974 20251129125150_UKswE AU002C 2025-12-02T14:33:23.029Z 2025-12-06T14:43:59.179Z
8662857 8662857 20251130194120_LlVsA AU002C 2025-12-02T14:16:52.471Z 2025-12-06T14:39:33.493Z
8642598 8642598 20251128162948_dRNxK AU002C 2025-11-30T14:18:20.880Z 2025-12-06T14:53:33.987Z
8641048 8641048 20251128132320_a354l AU002C 2025-11-30T14:13:52.132Z 2025-12-06T14:52:20.006Z
8562194 8562194 20251121134646_Xw4wV AU002C 2025-11-23T14:04:53.810Z 2025-11-30T15:03:24.328Z
8561998 8561998 20251121132057_Zc8oi AU002C 2025-11-23T14:04:19.434Z 2025-11-30T15:03:20.760Z
8471121 8471121 20251113150236_LHzxE AU002C 2025-11-16T14:25:30.252Z 2025-11-22T15:19:13.176Z
8456580 8456580 20251113185952_QtR9D AU002C 2025-11-15T14:11:31.703Z 2025-11-22T15:20:44.982Z
8456467 8456467 20251113184717_piBxA AU002C 2025-11-15T14:11:21.252Z 2025-11-22T15:20:44.440Z
8429994 8429994 20251108131847_JbCAZ AU002C 2025-11-12T14:45:50.468Z 2025-11-17T14:57:45.435Z
8419900 8419900 20251110175132_epvL1 AU002C 2025-11-12T14:08:39.525Z 2025-11-19T15:13:30.035Z
8419813 8419813 20251110173953_oI3YE AU002C 2025-11-12T14:08:28.230Z 2025-11-19T15:13:28.535Z
8419772 8419772 20251110173339_PXRar AU002C 2025-11-12T14:08:09.497Z 2025-11-19T15:13:25.147Z
8419708 8419708 20251110172254_KpY1l AU002C 2025-11-12T14:07:55.783Z 2025-11-19T15:13:20.920Z
8419631 8419631 20251110170828_3eWtL AU002C 2025-11-12T14:07:32.592Z 2025-11-19T15:13:18.463Z
8419144 8419144 20251110154048_UIfEV AU002C 2025-11-12T14:05:36.700Z 2025-11-19T15:13:01.397Z
8419065 8419065 20251110152531_TAp32 AU002C 2025-11-12T14:05:07.958Z 2025-11-19T15:12:58.223Z
8418964 8418964 20251110150750_NqeC5 AU002C 2025-11-12T14:04:42.634Z 2025-11-19T15:12:54.381Z
8401872 8401872 20251108174639_RNM2n AU002C 2025-11-10T14:04:37.783Z 2025-11-17T14:58:03.491Z
8401820 8401820 20251108173818_YZd6h AU002C 2025-11-10T14:04:29.685Z 2025-11-17T14:58:02.999Z
8401816 8401816 20251108173757_UAaTs AU002C 2025-11-10T14:04:28.794Z 2025-11-17T14:58:02.811Z
8401693 8401693 20251108162459_Vj1u3 AU002C 2025-11-10T14:03:55.112Z 2025-11-17T14:57:57.121Z
8401682 8401682 20251108162147_uJHRx AU002C 2025-11-10T14:03:52.557Z 2025-11-17T14:57:57.009Z
8401565 8401565 20251108152638_wRf2G AU002C 2025-11-10T14:03:09.095Z 2025-11-17T14:57:53.509Z
8401323 8401323 20251108142241_6FCQ7 AU002C 2025-11-10T14:02:12.204Z 2025-11-17T14:57:47.199Z
8401307 8401307 20251108141915_fKr6D AU002C 2025-11-10T14:02:02.895Z 2025-11-17T14:57:47.074Z
8401302 8401302 20251108141832_2B0hJ AU002C 2025-11-10T14:02:01.055Z 2025-11-17T14:57:46.970Z
8401278 8401278 20251108140934_xrggF AU002C 2025-11-10T14:01:56.701Z 2025-11-17T14:57:46.761Z
8401274 8401274 20251108140839_J57V5 AU002C 2025-11-10T14:01:55.902Z 2025-11-17T14:57:46.753Z
8401265 8401265 20251108140605_quG0A AU002C 2025-11-10T14:01:54.885Z 2025-11-17T14:57:46.736Z
8401182 8401182 20251108131527_4q2UL AU002C 2025-11-10T14:01:19.647Z 2025-11-17T14:57:45.283Z
8395754 8395754 20251107180457_rtBwt AU002C 2025-11-09T14:05:42.321Z 2025-11-16T15:02:42.700Z
8395587 8395587 20251107172052_RMYLR AU002C 2025-11-09T14:05:00.060Z 2025-11-16T15:02:34.320Z
8395534 8395534 20251107170710_O2klm AU002C 2025-11-09T14:04:48.255Z 2025-11-16T15:02:29.761Z
8395476 8395476 20251107164011_Q5H1f AU002C 2025-11-09T14:04:25.351Z 2025-11-10T14:25:35.767Z
8395080 8395080 20251107135521_2aP8g AU002C 2025-11-09T14:02:15.148Z 2025-11-16T15:02:01.545Z
8395051 8395051 20251107134708_5tvQ8 AU002C 2025-11-09T14:02:03.544Z 2025-11-16T15:02:00.772Z
8395029 8395029 20251107133650_SXplE AU002C 2025-11-09T14:01:55.216Z 2025-11-10T14:24:36.699Z
8394958 8394958 20251107125506_evCaq AU002C 2025-11-09T14:01:27.117Z 2025-11-16T15:01:54.376Z
8394655 8394655 20251106122100_LM1a8 AU002C 2025-11-08T14:30:58.281Z 2025-11-14T15:08:57.041Z
8360703 8360703 20251102154333_I2onR AU002C 2025-11-04T14:05:34.698Z 2025-11-11T15:02:35.687Z
8360673 8360673 20251102154044_sxtnE AU002C 2025-11-04T14:05:30.114Z 2025-11-11T15:02:35.353Z
8360572 8360572 20251102153516_HzrcA AU002C 2025-11-04T14:05:06.414Z 2025-11-11T15:02:34.090Z
8360421 8360421 20251102152100_Q9XVf AU002C 2025-11-04T14:04:32.042Z 2025-11-11T15:02:31.980Z
8359921 8359921 20251102142844_A3rQO AU002C 2025-11-04T14:02:35.925Z 2025-11-11T15:02:25.033Z
8349019 8349019 20251101171806_Cr3fL AU002C 2025-11-03T14:05:18.988Z 2025-11-10T15:04:01.692Z
8349002 8349002 20251101171533_SCqGX AU002C 2025-11-03T14:05:15.604Z 2025-11-10T15:04:00.524Z
8348346 8348346 20251101150448_viaLi AU002C 2025-11-03T14:02:33.982Z 2025-11-10T15:03:06.429Z
8347969 8347969 20251101134406_eltXS AU002C 2025-11-03T14:00:48.518Z 2025-11-10T15:02:20.080Z
8316378 8316378 20251030165253_I3yJh AU002C 2025-11-01T12:05:24.324Z 2025-11-08T15:10:30.969Z
8316276 8316276 20251030162002_JZhXv AU002C 2025-11-01T12:05:01.326Z 2025-11-08T15:10:27.768Z
8316272 8316272 20251030161817_brvlZ AU002C 2025-11-01T12:05:00.847Z 2025-11-08T15:10:27.731Z
8288185 8288185 20251028170510_zyFRz AU002C 2025-10-30T12:09:35.998Z 2025-11-06T15:11:02.285Z
8288165 8288165 20251028170337_yDYVu AU002C 2025-10-30T12:09:26.523Z 2025-11-06T15:11:01.959Z
8287909 8287909 20251028163529_k29QO AU002C 2025-10-30T12:08:38.087Z 2025-11-06T15:10:54.472Z
8287656 8287656 20251028160855_7R3d4 AU002C 2025-10-30T12:07:50.988Z 2025-11-06T15:10:46.575Z
8286306 8286306 20251028142936_nvFsQ AU002C 2025-10-30T12:03:26.241Z 2025-11-06T15:10:23.261Z
8249114 8249114 20251026165521_1pBBr AU002C 2025-10-28T12:04:33.348Z 2025-11-04T15:39:33.323Z
8248901 8248901 20251026160720_0A9YL AU002C 2025-10-28T12:03:39.668Z 2025-11-04T15:39:25.052Z
8248785 8248785 20251026153917_mJWLN AU002C 2025-10-28T12:03:14.152Z 2025-11-04T15:39:21.563Z
8209390 8209390 20251023170547_Ji5HS AU002C 2025-10-26T12:17:36.506Z 2025-11-01T13:09:35.247Z
8209220 8209220 20251023163600_YCApC AU002C 2025-10-26T12:16:57.001Z 2025-11-01T13:09:34.371Z
8156981 8156981 20251018174635_tpYDf AU002C 2025-10-21T12:19:01.253Z 2025-10-27T13:09:38.271Z
8156977 8156977 20251018172742_cwrYG AU002C 2025-10-21T12:18:58.124Z 2025-10-27T13:09:37.669Z
8156930 8156930 20251018154828_6WVsM AU002C 2025-10-21T12:18:26.315Z 2025-10-27T13:09:33.291Z
8109182 8109182 20251015161814_tuQLE AU002C 2025-10-17T12:04:18.481Z 2025-10-24T13:15:13.660Z
8109045 8109045 20251015150858_8C2Rh AU002C 2025-10-17T12:03:44.498Z 2025-10-24T13:14:59.151Z
8097139 8097139 20251013172520_S4Lo0 AU002C 2025-10-15T12:11:23.942Z 2025-10-22T13:09:20.279Z
8097123 8097123 20251013170246_chFvo AU002C 2025-10-15T12:11:17.588Z 2025-10-22T13:09:18.762Z
8097115 8097115 20251013163106_Lop2Z AU002C 2025-10-15T12:11:12.798Z 2025-10-22T13:09:13.108Z
8060064 8060064 20251005170018_WEkdV AU002C 2025-10-07T12:08:13.619Z 2025-10-14T12:33:30.684Z
8047624 8047624 20251002184730_44ImK AU002C 2025-10-04T12:14:23.816Z 2025-10-11T12:39:25.203Z
8047164 8047164 20251002161635_l03aV AU002C 2025-10-04T12:12:26.411Z 2025-10-11T12:39:07.467Z
8037406 8037406 20251001202859_k3k1P AU002C 2025-10-03T12:18:01.328Z 2025-10-10T12:39:45.053Z
8037313 8037313 20251001195101_uEkI3 AU002C 2025-10-03T12:17:46.708Z 2025-10-10T12:39:37.173Z
8037091 8037091 20251001183451_PD7lG AU002C 2025-10-03T12:17:08.725Z 2025-10-10T12:39:06.152Z
8037033 8037033 20251001181801_HDlWZ AU002C 2025-10-03T12:16:55.201Z 2025-10-10T12:38:58.199Z
8037011 8037011 20251001181339_id0Pb AU002C 2025-10-03T12:16:49.743Z 2025-10-10T12:38:57.942Z
8036989 8036989 20251001181128_DhdaR AU002C 2025-10-03T12:16:46.510Z 2025-10-10T12:38:57.062Z
8036926 8036926 20251001175629_Lh53G AU002C 2025-10-03T12:16:38.240Z 2025-10-10T12:38:54.246Z
8036555 8036555 20251001162233_XNp72 AU002C 2025-10-03T12:15:20.727Z 2025-10-10T12:38:40.244Z
8036550 8036550 20251001162144_4pyyj AU002C 2025-10-03T12:15:19.949Z 2025-10-10T12:38:40.131Z
8036486 8036486 20251001161413_3nKSo AU002C 2025-10-03T12:15:05.454Z 2025-10-10T12:38:38.352Z
7982197 7982197 20250926182422_MR26E AU002C 2025-09-28T12:19:16.190Z 2025-10-05T13:10:13.464Z
7981467 7981467 20250926164720_esEWp AU002C 2025-09-28T12:17:52.872Z 2025-10-05T13:09:59.792Z
7981379 7981379 20250926163936_up3jn AU002C 2025-09-28T12:17:34.470Z 2025-10-05T13:09:57.398Z
7970649 7970649 20250925192609_hd0HE AU002C 2025-09-27T12:09:37.802Z 2025-10-04T13:06:35.709Z
7943398 7943398 20250923194548_I506x AU002C 2025-09-25T12:22:36.054Z 2025-10-02T13:26:13.426Z
7943139 7943139 20250923192525_DPuVP AU002C 2025-09-25T12:22:10.318Z 2025-10-02T13:26:07.670Z
7943019 7943019 20250923191919_Ca4Ns AU002C 2025-09-25T12:21:44.459Z 2025-10-02T13:26:05.935Z
7942830 7942830 20250923185420_eC2oH AU002C 2025-09-25T12:21:09.254Z 2025-10-02T13:25:59.569Z
7942769 7942769 20250923184753_Rexas AU002C 2025-09-25T12:21:00.730Z 2025-10-02T13:25:58.077Z
7942577 7942577 20250923182317_dq9Ud AU002C 2025-09-25T12:20:21.627Z 2025-10-02T13:25:52.452Z
7942520 7942520 20250923181224_tDu23 AU002C 2025-09-25T12:20:12.792Z 2025-10-02T13:25:49.297Z
7942512 7942512 20250923181144_ztBFB AU002C 2025-09-25T12:20:11.844Z 2025-10-02T13:25:48.813Z
7942352 7942352 20250923173541_SWN4T AU002C 2025-09-25T12:19:31.614Z 2025-10-02T13:25:41.056Z
7942334 7942334 20250923173039_7vqqt AU002C 2025-09-25T12:19:29.179Z 2025-10-02T13:25:39.912Z
7942283 7942283 20250923172022_up8a9 AU002C 2025-09-25T12:19:13.632Z 2025-10-02T13:25:38.468Z
7942244 7942244 20250923171414_9DX39 AU002C 2025-09-25T12:19:03.038Z 2025-10-02T13:25:36.507Z

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