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 = "AU0010" 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
9841502 9841502 20260501172920_Q7c32 AU0010 2026-05-04T12:22:27.233Z 2026-05-04T12:22:27.233Z
9841480 9841480 20260501164343_SLJhQ AU0010 2026-05-04T12:22:18.091Z 2026-05-04T12:22:18.091Z
9841414 9841414 20260501151937_FELiX AU0010 2026-05-04T12:21:53.912Z 2026-05-04T12:21:53.912Z
9841405 9841405 20260501150346_OV2pD AU0010 2026-05-04T12:21:52.521Z 2026-05-04T12:21:52.521Z
9841353 9841353 20260501121426_gy2ME AU0010 2026-05-04T12:21:23.603Z 2026-05-04T12:21:23.603Z
9841340 9841340 20260501112750_M3o8P AU0010 2026-05-04T12:21:17.081Z 2026-05-04T12:21:17.081Z
9841334 9841334 20260501111922_tUsgO AU0010 2026-05-04T12:21:15.337Z 2026-05-04T12:21:15.337Z
9841329 9841329 20260501111649_x0z3N AU0010 2026-05-04T12:21:14.126Z 2026-05-04T12:21:14.126Z
9841230 9841230 20260502170349_W7DMv AU0010 2026-05-04T12:16:48.749Z 2026-05-04T12:16:48.749Z
9841189 9841189 20260502151620_g7R10 AU0010 2026-05-04T12:15:35.791Z 2026-05-04T12:15:35.791Z
9841183 9841183 20260502145325_wuCC4 AU0010 2026-05-04T12:15:28.286Z 2026-05-04T12:15:28.286Z
9841172 9841172 20260502143030_9P6Y3 AU0010 2026-05-04T12:15:10.935Z 2026-05-04T12:15:10.935Z
9841155 9841155 20260502130231_ILcfx AU0010 2026-05-04T12:14:39.352Z 2026-05-04T12:14:39.352Z
9841141 9841141 20260502105921_CQTcg AU0010 2026-05-04T12:13:48.150Z 2026-05-04T12:13:48.150Z
9841135 9841135 20260502104020_VfeBZ AU0010 2026-05-04T12:13:41.682Z 2026-05-04T12:13:41.682Z
9841122 9841122 20260503185124_ADDN1 AU0010 2026-05-04T12:09:53.711Z 2026-05-04T12:09:56.893Z
9838679 9838679 20260502214159_aOnI9 AU0010 2026-05-04T12:01:56.335Z 2026-05-04T12:09:56.182Z
9838495 9838495 20260502203429_DVQjc AU0010 2026-05-04T12:01:14.052Z 2026-05-04T12:09:56.128Z
9838405 9838405 20260502201244_7765a AU0010 2026-05-04T12:00:56.062Z 2026-05-04T12:09:56.092Z
9838366 9838366 20260502195615_sEqSz AU0010 2026-05-04T12:00:46.687Z 2026-05-04T12:09:56.065Z
9838316 9838316 20260502193242_g2mhG AU0010 2026-05-04T12:00:36.039Z 2026-05-04T12:09:56.045Z
9838311 9838311 20260502193217_oW38B AU0010 2026-05-04T12:00:35.650Z 2026-05-04T12:09:56.044Z
9838214 9838214 20260502184401_4i3MZ AU0010 2026-05-04T12:00:18.243Z 2026-05-04T12:09:56.002Z
9837830 9837830 20260502171845_XcYg3 AU0010 2026-05-03T12:14:25.747Z 2026-05-04T12:16:58.149Z
9834549 9834549 20260501215149_DNFcN AU0010 2026-05-03T12:02:42.393Z 2026-05-04T12:11:46.482Z
9834385 9834385 20260501211029_aiLle AU0010 2026-05-03T12:01:51.841Z 2026-05-04T12:11:35.943Z
9834290 9834290 20260501204517_pSzvJ AU0010 2026-05-03T12:01:33.369Z 2026-05-04T12:11:15.918Z
9834286 9834286 20260501204322_TGGnu AU0010 2026-05-03T12:01:32.551Z 2026-05-04T12:11:15.637Z
9834248 9834248 20260501203217_xL3G8 AU0010 2026-05-03T12:01:26.200Z 2026-05-04T12:11:13.117Z
9834195 9834195 20260501195857_0YW6W AU0010 2026-05-03T12:01:08.810Z 2026-05-04T12:11:09.201Z
9834175 9834175 20260501194335_LyfCD AU0010 2026-05-03T12:01:01.980Z 2026-05-04T12:11:07.688Z
9834168 9834168 20260501194159_2hL2j AU0010 2026-05-03T12:00:59.881Z 2026-05-04T12:11:07.204Z
9834045 9834045 20260501175119_W0Fr3 AU0010 2026-05-03T12:00:15.131Z 2026-05-04T12:10:05.440Z
9834040 9834040 20260502213013_3B3aP AU0010 2026-05-03T12:00:11.012Z 2026-05-03T12:00:11.012Z
9834038 9834038 20260502203008_1yRFk AU0010 2026-05-03T12:00:10.145Z 2026-05-03T12:00:10.145Z
9829612 9829612 20260429135915_sjITo AU0010 2026-05-01T12:27:17.358Z 2026-05-04T12:32:06.898Z
9824870 9824870 20260429214158_hcXLD AU0010 2026-05-01T12:06:22.504Z 2026-05-04T12:23:36.176Z
9824834 9824834 20260429213143_JeiMy AU0010 2026-05-01T12:06:09.818Z 2026-05-04T12:23:34.589Z
9824804 9824804 20260429212509_cRGlL AU0010 2026-05-01T12:06:03.852Z 2026-05-04T12:23:33.607Z
9824667 9824667 20260429202327_BSyv8 AU0010 2026-05-01T12:05:28.758Z 2026-05-04T12:23:25.194Z
9824615 9824615 20260429182257_SWKRm AU0010 2026-05-01T12:04:58.977Z 2026-05-04T12:23:20.519Z
9824608 9824608 20260429180234_3b3T0 AU0010 2026-05-01T12:04:38.267Z 2026-05-04T12:23:17.894Z
9824595 9824595 20260429164705_ummHD AU0010 2026-05-01T12:02:53.893Z 2026-05-04T12:22:48.552Z
9819039 9819039 20260428202821_5FNQa AU0010 2026-04-30T12:09:47.961Z 2026-05-04T12:28:57.031Z
9819037 9819037 20260428202546_nGK39 AU0010 2026-04-30T12:09:47.539Z 2026-05-04T12:28:56.895Z
9818989 9818989 20260428192801_a9dGc AU0010 2026-04-30T12:09:39.839Z 2026-05-04T12:28:54.908Z
9818981 9818981 20260428192154_HTb78 AU0010 2026-04-30T12:09:38.211Z 2026-05-04T12:28:54.568Z
9818970 9818970 20260428191041_sXE83 AU0010 2026-04-30T12:09:35.833Z 2026-05-04T12:28:53.538Z
9818941 9818941 20260428184652_3Vrnd AU0010 2026-04-30T12:09:22.273Z 2026-05-04T12:28:51.593Z
9818924 9818924 20260428183637_petvV AU0010 2026-04-30T12:09:14.636Z 2026-05-04T12:28:50.741Z
9804349 9804349 20260425124409_K23Wj AU0010 2026-04-27T12:51:40.031Z 2026-05-02T13:04:26.595Z
9803765 9803765 20260425114208_k4PNj AU0010 2026-04-27T12:50:36.871Z 2026-05-02T13:04:05.977Z
9797825 9797825 20260425214000_Bk8py AU0010 2026-04-27T12:21:00.910Z 2026-05-04T12:43:59.978Z
9797604 9797604 20260425211145_kmO5s AU0010 2026-04-27T12:20:10.708Z 2026-05-04T12:43:39.878Z
9797492 9797492 20260425205337_UrFrR AU0010 2026-04-27T12:19:41.810Z 2026-05-04T12:43:34.792Z
9797381 9797381 20260425203652_CtXOu AU0010 2026-04-27T12:19:10.560Z 2026-05-04T12:43:31.659Z
9797301 9797301 20260425202418_6wDT7 AU0010 2026-04-27T12:18:57.871Z 2026-05-04T12:43:29.742Z
9797163 9797163 20260425195902_foDX4 AU0010 2026-04-27T12:18:24.350Z 2026-05-04T12:43:26.021Z
9797048 9797048 20260425193529_zWmyU AU0010 2026-04-27T12:17:55.647Z 2026-05-04T12:43:22.888Z
9796845 9796845 20260425190907_7Zvfb AU0010 2026-04-27T12:17:04.608Z 2026-05-04T12:43:01.994Z
9796705 9796705 20260425184048_R3gXM AU0010 2026-04-27T12:16:19.801Z 2026-05-04T12:42:56.066Z
9796408 9796408 20260425175455_RDx5O AU0010 2026-04-27T12:15:09.015Z 2026-05-04T12:42:48.898Z
9796093 9796093 20260425173615_Lwow9 AU0010 2026-04-27T12:14:18.687Z 2026-05-04T12:42:44.064Z
9795579 9795579 20260425171113_Dpz5f AU0010 2026-04-27T12:12:57.925Z 2026-05-04T12:42:16.961Z
9795184 9795184 20260425164543_bnFaj AU0010 2026-04-27T12:11:49.156Z 2026-05-04T12:42:10.612Z
9794021 9794021 20260425151621_eRJna AU0010 2026-04-27T12:08:23.594Z 2026-05-04T12:41:32.414Z
9793232 9793232 20260425142434_dzgx3 AU0010 2026-04-27T12:06:08.105Z 2026-05-04T12:41:20.367Z
9793169 9793169 20260425142152_fGexZ AU0010 2026-04-27T12:05:58.661Z 2026-05-04T12:41:18.987Z
9790525 9790525 20260424115704_iVBcu AU0010 2026-04-26T12:34:44.825Z 2026-05-02T13:14:31.934Z
9783576 9783576 20260424213308_Fwegg AU0010 2026-04-26T12:15:00.630Z 2026-05-02T12:59:24.002Z
9783551 9783551 20260424213232_ZU6U5 AU0010 2026-04-26T12:14:59.111Z 2026-05-02T12:59:23.607Z
9783536 9783536 20260424213040_rG26I AU0010 2026-04-26T12:14:58.162Z 2026-05-02T12:59:23.295Z
9783470 9783470 20260424212517_TS3FL AU0010 2026-04-26T12:14:52.121Z 2026-05-02T12:59:21.740Z
9783450 9783450 20260424212244_v2dDC AU0010 2026-04-26T12:14:50.145Z 2026-05-02T12:59:21.010Z
9783180 9783180 20260424205017_3Kizo AU0010 2026-04-26T12:14:00.904Z 2026-05-02T12:58:57.860Z
9782834 9782834 20260424200043_ri92W AU0010 2026-04-26T12:12:53.956Z 2026-05-02T12:58:42.724Z
9782815 9782815 20260424195641_Ftrd3 AU0010 2026-04-26T12:12:51.978Z 2026-05-02T12:58:42.227Z
9782662 9782662 20260424193543_pNl1A AU0010 2026-04-26T12:12:36.959Z 2026-05-02T12:58:36.645Z
9782519 9782519 20260424191208_ntICH AU0010 2026-04-26T12:12:06.036Z 2026-05-02T12:58:16.654Z
9782471 9782471 20260424190407_sJdC6 AU0010 2026-04-26T12:12:01.127Z 2026-05-02T12:58:14.160Z
9782462 9782462 20260424190352_qW3ba AU0010 2026-04-26T12:12:00.668Z 2026-05-02T12:58:14.050Z
9782277 9782277 20260424182956_KnRV1 AU0010 2026-04-26T12:11:29.955Z 2026-05-02T12:58:06.161Z
9782141 9782141 20260424181314_4Fyiy AU0010 2026-04-26T12:11:18.863Z 2026-05-02T12:58:02.045Z
9779949 9779949 20260424160313_GwLkl AU0010 2026-04-26T12:06:50.023Z 2026-05-02T12:56:37.070Z
9778022 9778022 20260424141539_n7ZhW AU0010 2026-04-26T12:02:36.942Z 2026-05-02T12:55:24.576Z
9763439 9763439 20260423180549_Dbogl AU0010 2026-04-25T12:12:38.316Z 2026-05-02T13:07:33.578Z
9763393 9763393 20260423175804_rxYac AU0010 2026-04-25T12:12:32.664Z 2026-05-02T13:07:31.501Z
9763009 9763009 20260423172610_axQlS AU0010 2026-04-25T12:11:22.470Z 2026-05-02T13:07:05.359Z
9762046 9762046 20260423160705_o6tOS AU0010 2026-04-25T12:08:23.665Z 2026-05-02T13:06:17.339Z
9761490 9761490 20260423153126_oUTqn AU0010 2026-04-25T12:06:43.203Z 2026-05-02T13:06:06.561Z
9761230 9761230 20260423151840_VEBsx AU0010 2026-04-25T12:06:11.541Z 2026-05-02T13:06:02.028Z
9760888 9760888 20260423144916_xhB5L AU0010 2026-04-25T12:05:11.312Z 2026-05-02T13:05:51.221Z
9760753 9760753 20260423143757_Kk2oa AU0010 2026-04-25T12:04:42.085Z 2026-05-02T13:05:31.362Z
9747722 9747722 20260422195029_3khiE AU0010 2026-04-24T12:02:52.337Z 2026-04-30T13:06:58.354Z
9744347 9744347 20260422151017_jPJjb AU0010 2026-04-24T12:01:31.480Z 2026-04-30T13:05:22.944Z
9744247 9744247 20260422150557_7CFGW AU0010 2026-04-24T12:01:26.469Z 2026-04-30T13:05:22.104Z
9743181 9743181 20260422134854_RTq3K AU0010 2026-04-24T12:00:54.781Z 2026-04-30T13:05:07.240Z
9732630 9732630 20260421213420_Zdlyo AU0010 2026-04-23T12:10:09.998Z 2026-04-30T13:17:01.677Z
9732484 9732484 20260421211832_W3f8N AU0010 2026-04-23T12:09:41.663Z 2026-04-30T13:17:00.351Z
9732478 9732478 20260421211752_PWMv2 AU0010 2026-04-23T12:09:40.699Z 2026-04-30T13:17:00.214Z

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