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

963 rows where station_code = "KR003E" 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
8662202 8662202 20251130181730_3FfUW KR003E 2025-12-02T14:14:40.836Z 2025-12-06T14:38:55.423Z
8662101 8662101 20251130175700_I6Ts5 KR003E 2025-12-02T14:14:18.683Z 2025-12-06T14:38:50.103Z
8649701 8649701 20251129180857_mUHnO KR003E 2025-12-01T14:13:33.206Z 2025-12-06T14:45:36.820Z
8644139 8644139 20251128190203_Ru9xo KR003E 2025-11-30T14:21:23.242Z 2025-12-06T14:54:38.585Z
8643940 8643940 20251128184035_V6iW2 KR003E 2025-11-30T14:20:50.302Z 2025-12-06T14:54:33.638Z
8643068 8643068 20251128171628_07x1H KR003E 2025-11-30T14:19:16.832Z 2025-12-06T14:53:39.980Z
8642994 8642994 20251128171004_NYDRv KR003E 2025-11-30T14:19:12.126Z 2025-12-06T14:53:39.116Z
8642913 8642913 20251128170154_mz2Uv KR003E 2025-11-30T14:18:58.119Z 2025-12-06T14:53:37.769Z
8642776 8642776 20251128164713_OnOys KR003E 2025-11-30T14:18:36.045Z 2025-12-06T14:53:36.250Z
8642736 8642736 20251128164232_bGAEh KR003E 2025-11-30T14:18:33.691Z 2025-12-06T14:53:35.821Z
8642434 8642434 20251128160343_wd2U3 KR003E 2025-11-30T14:17:54.219Z 2025-12-06T14:53:31.576Z
8642349 8642349 20251128155245_aa2pD KR003E 2025-11-30T14:17:48.896Z 2025-12-06T14:53:30.479Z
8641608 8641608 20251128150111_iRIev KR003E 2025-11-30T14:16:34.698Z 2025-12-06T14:52:40.015Z
8641530 8641530 20251128145832_ZZNgP KR003E 2025-11-30T14:16:30.536Z 2025-12-06T14:52:38.368Z
8631798 8631798 20251127200155_mPlzb KR003E 2025-11-29T14:16:24.753Z 2025-12-06T15:00:42.248Z
8631564 8631564 20251127192534_bw5Tn KR003E 2025-11-29T14:15:45.541Z 2025-12-06T15:00:20.446Z
8631342 8631342 20251127185140_o3MjN KR003E 2025-11-29T14:15:08.467Z 2025-12-06T15:00:05.088Z
8631265 8631265 20251127184255_EJfAD KR003E 2025-11-29T14:15:02.177Z 2025-12-06T15:00:01.232Z
8631085 8631085 20251127181503_uHZlU KR003E 2025-11-29T14:14:32.246Z 2025-12-06T14:59:53.267Z
8630806 8630806 20251127172909_ANUEt KR003E 2025-11-29T14:13:47.942Z 2025-12-06T14:59:31.335Z
8630602 8630602 20251127165048_MRsb2 KR003E 2025-11-29T14:13:04.481Z 2025-12-06T14:59:13.896Z
8630399 8630399 20251127160803_jzT4R KR003E 2025-11-29T14:12:36.727Z 2025-12-06T14:59:03.605Z
8630375 8630375 20251127160254_wXHyZ KR003E 2025-11-29T14:12:24.276Z 2025-12-06T14:59:02.631Z
8576942 8576942 20251122164904_i3fUC KR003E 2025-11-24T14:07:04.248Z 2025-12-01T15:18:41.659Z
8564690 8564690 20251121185532_4LE2Z KR003E 2025-11-23T14:11:31.589Z 2025-11-30T15:04:25.886Z
8563946 8563946 20251121173954_y6N2h KR003E 2025-11-23T14:09:37.922Z 2025-11-30T15:03:56.665Z
8563798 8563798 20251121172214_sTYlq KR003E 2025-11-23T14:09:20.606Z 2025-11-30T15:03:46.558Z
8563543 8563543 20251121163846_3a2yo KR003E 2025-11-23T14:08:33.538Z 2025-11-30T15:03:40.783Z
8547598 8547598 20251120200220_9JHOz KR003E 2025-11-22T14:15:19.782Z 2025-11-29T14:54:20.482Z
8547549 8547549 20251120200036_8py1q KR003E 2025-11-22T14:15:16.177Z 2025-11-29T14:54:20.326Z
8547451 8547451 20251120195050_N6Hph KR003E 2025-11-22T14:15:09.735Z 2025-11-29T14:54:20.021Z
8533209 8533209 20251119180334_E3lFI KR003E 2025-11-21T14:10:04.761Z 2025-11-28T14:54:26.819Z
8533178 8533178 20251119180124_KSfVS KR003E 2025-11-21T14:10:01.283Z 2025-11-28T14:54:24.933Z
8520415 8520415 20251118192405_ShT27 KR003E 2025-11-20T14:09:55.428Z 2025-11-27T15:11:33.172Z
8520284 8520284 20251118191145_W13YZ KR003E 2025-11-20T14:09:28.448Z 2025-11-27T15:11:32.453Z
8520278 8520278 20251118191136_mTGhf KR003E 2025-11-20T14:09:28.235Z 2025-11-27T15:11:32.438Z
8520145 8520145 20251118185320_6OpH9 KR003E 2025-11-20T14:09:05.613Z 2025-11-27T15:11:31.481Z
8489832 8489832 20251116174440_5mL8b KR003E 2025-11-18T14:11:38.938Z 2025-11-25T15:07:42.715Z
8489664 8489664 20251116171806_yAAEw KR003E 2025-11-18T14:11:03.506Z 2025-11-25T15:07:37.576Z
8479332 8479332 20251115190941_cgjfO KR003E 2025-11-17T14:15:39.899Z 2025-11-24T15:04:42.242Z
8479080 8479080 20251115183452_3Av1q KR003E 2025-11-17T14:14:56.173Z 2025-11-24T15:04:32.255Z
8478166 8478166 20251115165309_2EHkN KR003E 2025-11-17T14:12:51.076Z 2025-11-24T15:04:02.299Z
8477669 8477669 20251115155026_tQcLh KR003E 2025-11-17T14:11:37.073Z 2025-11-24T15:03:46.220Z
8466758 8466758 20251114185659_lKhZF KR003E 2025-11-16T14:13:02.981Z 2025-11-23T15:17:04.820Z
8465807 8465807 20251114171309_8z29C KR003E 2025-11-16T14:10:07.773Z 2025-11-23T15:16:58.313Z
8456787 8456787 20251113191748_sDZOV KR003E 2025-11-15T14:12:03.762Z 2025-11-22T15:20:46.246Z
8456722 8456722 20251113191425_UAvAm KR003E 2025-11-15T14:11:58.353Z 2025-11-22T15:20:45.968Z
8456602 8456602 20251113190155_agfpK KR003E 2025-11-15T14:11:33.505Z 2025-11-22T15:20:45.029Z
8456515 8456515 20251113185232_BC1Vb KR003E 2025-11-15T14:11:24.660Z 2025-11-22T15:20:44.657Z
8456350 8456350 20251113182953_UaU5m KR003E 2025-11-15T14:11:02.834Z 2025-11-22T15:20:43.464Z
8456262 8456262 20251113181808_UfGz5 KR003E 2025-11-15T14:10:47.619Z 2025-11-22T15:20:42.810Z
8456203 8456203 20251113181509_5bGR4 KR003E 2025-11-15T14:10:41.032Z 2025-11-22T15:20:41.313Z
8455864 8455864 20251113174358_2TdRb KR003E 2025-11-15T14:10:00.972Z 2025-11-22T15:20:28.657Z
8455614 8455614 20251113171745_C4iwg KR003E 2025-11-15T14:09:25.942Z 2025-11-22T15:20:20.181Z
8435663 8435663 20251111195714_Z4TDs KR003E 2025-11-13T14:16:07.816Z 2025-11-20T15:22:25.785Z
8435609 8435609 20251111195317_Nfs58 KR003E 2025-11-13T14:15:54.005Z 2025-11-20T15:22:24.765Z
8435528 8435528 20251111194503_035FD KR003E 2025-11-13T14:15:41.797Z 2025-11-20T15:22:22.258Z
8435213 8435213 20251111191903_iFpgd KR003E 2025-11-13T14:14:56.893Z 2025-11-20T15:22:06.982Z
8435028 8435028 20251111190404_AaJtu KR003E 2025-11-13T14:14:20.266Z 2025-11-20T15:21:58.924Z
8434871 8434871 20251111185033_tCFRc KR003E 2025-11-13T14:13:49.984Z 2025-11-20T15:21:52.911Z
8434842 8434842 20251111184847_yigfn KR003E 2025-11-13T14:13:47.685Z 2025-11-20T15:21:52.188Z
8434770 8434770 20251111184358_2ksI5 KR003E 2025-11-13T14:13:39.330Z 2025-11-20T15:21:49.771Z
8434751 8434751 20251111184102_zQAJq KR003E 2025-11-13T14:13:37.465Z 2025-11-20T15:21:49.458Z
8433737 8433737 20251111171726_QKDN4 KR003E 2025-11-13T14:11:01.635Z 2025-11-20T15:21:04.214Z
8433273 8433273 20251111164740_2MGpd KR003E 2025-11-13T14:09:44.100Z 2025-11-20T15:20:37.297Z
8433132 8433132 20251111163749_JEyhX KR003E 2025-11-13T14:09:30.801Z 2025-11-20T15:20:34.969Z
8432944 8432944 20251111161948_V8lVj KR003E 2025-11-13T14:09:03.584Z 2025-11-20T15:20:27.801Z
8432799 8432799 20251111160211_tUB2G KR003E 2025-11-13T14:08:34.320Z 2025-11-20T15:20:22.858Z
8432523 8432523 20251111153558_bzUJ0 KR003E 2025-11-13T14:07:50.715Z 2025-11-20T15:20:15.840Z
8363700 8363700 20251102204616_ZVLGq KR003E 2025-11-04T14:15:07.063Z 2025-11-11T15:05:17.053Z
8363694 8363694 20251102204524_AfOiS KR003E 2025-11-04T14:15:05.886Z 2025-11-11T15:05:16.808Z
8363562 8363562 20251102203019_72et7 KR003E 2025-11-04T14:14:41.081Z 2025-11-11T15:05:12.040Z
8363391 8363391 20251102201309_IqsPO KR003E 2025-11-04T14:14:10.790Z 2025-11-11T15:05:04.560Z
8363209 8363209 20251102195842_uA4ox KR003E 2025-11-04T14:13:34.475Z 2025-11-11T15:04:54.626Z
8362978 8362978 20251102194500_Cp7Vu KR003E 2025-11-04T14:12:52.091Z 2025-11-11T15:04:21.847Z
8362869 8362869 20251102193636_Oe3bP KR003E 2025-11-04T14:12:34.755Z 2025-11-11T15:04:11.014Z
8362821 8362821 20251102193035_Qt2Yo KR003E 2025-11-04T14:12:27.599Z 2025-11-11T15:04:03.824Z
8361990 8361990 20251102183736_h3Phq KR003E 2025-11-04T14:10:06.466Z 2025-11-11T15:03:20.005Z
8304374 8304374 20251029200938_VLv8E KR003E 2025-10-31T12:08:32.987Z 2025-11-07T15:11:03.291Z
8304352 8304352 20251029195020_gcb5y KR003E 2025-10-31T12:08:29.117Z 2025-11-07T15:10:52.339Z
8304298 8304298 20251029193700_RlBmV KR003E 2025-10-31T12:08:21.118Z 2025-11-07T15:10:46.826Z
8304201 8304201 20251029192415_O6JpZ KR003E 2025-10-31T12:08:02.509Z 2025-11-07T15:10:40.700Z
8304195 8304195 20251029192150_7In95 KR003E 2025-10-31T12:08:01.923Z 2025-11-07T15:10:39.275Z
8304119 8304119 20251029190949_4iGXp KR003E 2025-10-31T12:07:56.028Z 2025-11-07T15:10:34.512Z
8304039 8304039 20251029185038_smmks KR003E 2025-10-31T12:07:50.230Z 2025-11-07T15:10:27.956Z
8303832 8303832 20251029180854_0qEXY KR003E 2025-10-31T12:07:17.407Z 2025-11-07T15:09:57.648Z
8303615 8303615 20251029174331_S3BJ3 KR003E 2025-10-31T12:06:57.642Z 2025-11-07T15:09:39.980Z
8290572 8290572 20251028202815_8LUtU KR003E 2025-10-30T12:17:16.491Z 2025-11-06T15:12:08.595Z
8289865 8289865 20251028191616_VrfLv KR003E 2025-10-30T12:14:57.447Z 2025-11-06T15:12:02.192Z
8289411 8289411 20251028184128_em2dT KR003E 2025-10-30T12:13:31.187Z 2025-11-06T15:11:54.197Z
8289305 8289305 20251028183316_ZOHSw KR003E 2025-10-30T12:13:05.321Z 2025-11-06T15:11:50.504Z
8289281 8289281 20251028183134_uH8PE KR003E 2025-10-30T12:13:03.945Z 2025-11-06T15:11:50.343Z
8272289 8272289 20251027200726_IBhHs KR003E 2025-10-29T12:09:37.770Z 2025-11-05T15:20:23.375Z
8272223 8272223 20251027200227_Ug7kn KR003E 2025-10-29T12:09:32.827Z 2025-11-05T15:20:21.616Z
8272193 8272193 20251027195950_A1TJ1 KR003E 2025-10-29T12:09:30.046Z 2025-11-05T15:20:21.173Z
8272122 8272122 20251027195559_Rice8 KR003E 2025-10-29T12:09:25.593Z 2025-11-05T15:20:20.441Z
8271672 8271672 20251027192228_1iwsI KR003E 2025-10-29T12:08:28.257Z 2025-11-05T15:20:05.572Z
8271635 8271635 20251027191814_CcCLu KR003E 2025-10-29T12:08:23.163Z 2025-11-05T15:20:03.608Z
8271593 8271593 20251027191353_cIILp KR003E 2025-10-29T12:08:18.494Z 2025-11-05T15:20:02.136Z
8271482 8271482 20251027190438_Sgufy KR003E 2025-10-29T12:08:09.653Z 2025-11-05T15:19:58.288Z

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