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,341 rows where station_code = "KR0018" 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
9591681 9591681 20260328190213_x3K3U KR0018 2026-03-29T12:04:50.715Z 2026-04-06T12:39:38.867Z
9588126 9588126 20260327193233_f06Jo KR0018 2026-03-28T12:07:12.911Z 2026-04-05T12:35:09.673Z
9579088 9579088 20260325200308_R7n26 KR0018 2026-03-26T12:09:18.069Z 2026-04-03T12:39:15.743Z
9578907 9578907 20260325155023_ijD2F KR0018 2026-03-26T12:08:48.493Z 2026-04-03T12:38:40.165Z
9574942 9574942 20260323174544_KJWPH KR0018 2026-03-25T12:19:55.491Z 2026-03-31T12:28:44.926Z
9570308 9570308 20260322202856_BSR31 KR0018 2026-03-24T12:22:58.435Z 2026-03-30T12:30:39.539Z
9569959 9569959 20260322183547_qtOcn KR0018 2026-03-24T12:22:24.000Z 2026-03-30T12:30:25.489Z
9569938 9569938 20260322182758_j3pZn KR0018 2026-03-24T12:22:22.348Z 2026-03-30T12:30:25.141Z
9569932 9569932 20260322182737_zir9e KR0018 2026-03-24T12:22:22.117Z 2026-03-30T12:30:25.093Z
9569925 9569925 20260322182624_FjdzA KR0018 2026-03-24T12:22:21.579Z 2026-03-30T12:30:24.993Z
9569355 9569355 20260322150544_GnQ4A KR0018 2026-03-24T12:20:44.646Z 2026-03-30T12:29:49.435Z
9568959 9568959 20260322115352_AtixX KR0018 2026-03-24T12:19:12.703Z 2026-03-30T12:29:12.644Z
9568491 9568491 20260323164812_7UV5J KR0018 2026-03-24T12:15:10.870Z 2026-03-24T12:24:25.466Z
9568078 9568078 20260323161131_HlFPF KR0018 2026-03-24T12:14:29.608Z 2026-03-31T12:28:22.631Z
9567706 9567706 20260323154158_DIZxq KR0018 2026-03-24T12:13:59.909Z 2026-03-31T12:28:17.621Z
9567272 9567272 20260323150129_Q2cEG KR0018 2026-03-24T12:13:19.706Z 2026-03-31T12:28:11.782Z
9550106 9550106 20260320160853_NEPhS KR0018 2026-03-22T12:24:55.611Z 2026-03-28T12:36:27.148Z
9547279 9547279 20260321131300_20oJB KR0018 2026-03-22T12:13:19.864Z 2026-03-29T12:20:08.397Z
9541090 9541090 20260319192206_t2wzv KR0018 2026-03-21T12:28:29.657Z 2026-03-27T12:42:33.887Z
9540641 9540641 20260319171000_j3eMZ KR0018 2026-03-21T12:27:46.733Z 2026-03-27T12:42:28.804Z
9540541 9540541 20260319161842_EMWsd KR0018 2026-03-21T12:27:12.599Z 2026-03-27T12:42:24.544Z
9540407 9540407 20260319153630_0Qvg9 KR0018 2026-03-21T12:26:58.536Z 2026-03-27T12:42:21.439Z
9540311 9540311 20260319150348_0rVCA KR0018 2026-03-21T12:26:41.799Z 2026-03-27T12:42:16.006Z
9540219 9540219 20260319143927_52RNE KR0018 2026-03-21T12:26:30.826Z 2026-03-27T12:42:04.203Z
9540036 9540036 20260319123721_BBoJx KR0018 2026-03-21T12:25:58.070Z 2026-03-27T12:41:56.678Z
9539279 9539279 20260320143024_7SLm5 KR0018 2026-03-21T12:19:13.492Z 2026-03-28T12:35:59.030Z
9538845 9538845 20260320135052_TYQBY KR0018 2026-03-21T12:18:28.871Z 2026-03-28T12:35:53.587Z
9538027 9538027 20260320122635_T3Es1 KR0018 2026-03-21T12:16:58.435Z 2026-03-28T12:35:33.758Z
9468440 9468440 20260312205545_Kta7N KR0018 2026-03-13T12:21:49.675Z 2026-03-20T12:37:16.244Z
9468360 9468360 20260312194821_JuSwC KR0018 2026-03-13T12:21:42.667Z 2026-03-20T12:37:15.070Z
9468171 9468171 20260312180214_EwFWE KR0018 2026-03-13T12:21:24.669Z 2026-03-20T12:37:13.220Z
9467993 9467993 20260312161530_KA07v KR0018 2026-03-13T12:20:52.813Z 2026-03-20T12:37:11.459Z
9467959 9467959 20260312155608_rNnTb KR0018 2026-03-13T12:20:40.146Z 2026-03-20T12:37:11.057Z
9467852 9467852 20260312145900_3pk5g KR0018 2026-03-13T12:20:23.053Z 2026-03-20T12:37:09.979Z
9467832 9467832 20260312143851_4o9Fq KR0018 2026-03-13T12:20:18.834Z 2026-03-20T12:37:09.782Z
9467799 9467799 20260312140734_VA8f0 KR0018 2026-03-13T12:20:00.612Z 2026-03-20T12:37:09.351Z
9462113 9462113 20260311202045_CcF7P KR0018 2026-03-12T12:18:32.919Z 2026-03-19T12:45:49.064Z
9461591 9461591 20260311172055_O2aCh KR0018 2026-03-12T12:17:34.295Z 2026-03-19T12:45:35.225Z
9461494 9461494 20260311164436_hMgsV KR0018 2026-03-12T12:17:19.249Z 2026-03-19T12:45:29.104Z
9461433 9461433 20260311161530_bzvm3 KR0018 2026-03-12T12:17:10.665Z 2026-03-19T12:45:23.893Z
9454834 9454834 20260310171732_pJN2e KR0018 2026-03-11T12:09:57.032Z 2026-03-18T12:39:49.814Z
9454593 9454593 20260310163402_opJEM KR0018 2026-03-11T12:09:33.301Z 2026-03-18T12:39:47.559Z
9453258 9453258 20260310131220_50ham KR0018 2026-03-11T12:07:13.643Z 2026-03-18T12:39:21.964Z
9450048 9450048 20260309182644_ePK4f KR0018 2026-03-10T12:14:36.150Z 2026-03-17T12:42:34.169Z
9449866 9449866 20260309165220_wIhdv KR0018 2026-03-10T12:14:08.562Z 2026-03-17T12:42:32.246Z
9449837 9449837 20260309164514_Ji9Fn KR0018 2026-03-10T12:14:03.871Z 2026-03-17T12:42:31.938Z
9449605 9449605 20260309160414_3BqGy KR0018 2026-03-10T12:13:28.170Z 2026-03-17T12:42:30.121Z
9449099 9449099 20260309130902_ZzTe7 KR0018 2026-03-10T12:11:56.485Z 2026-03-17T12:42:26.010Z
9443528 9443528 20260308104037_b2YII KR0018 2026-03-09T12:08:09.553Z 2026-03-16T12:44:05.318Z
9440520 9440520 20260307191824_HvfhC KR0018 2026-03-08T12:13:49.572Z 2026-03-15T12:42:08.288Z
9440461 9440461 20260307183356_80PyQ KR0018 2026-03-08T12:13:39.892Z 2026-03-15T12:42:06.567Z
9440455 9440455 20260307182837_VEnTp KR0018 2026-03-08T12:13:39.579Z 2026-03-15T12:42:06.331Z
9440096 9440096 20260307160932_HV3V2 KR0018 2026-03-08T12:12:38.788Z 2026-03-15T12:42:03.223Z
9440086 9440086 20260307160828_VotAo KR0018 2026-03-08T12:12:36.348Z 2026-03-15T12:42:03.079Z
9440021 9440021 20260307155255_5323P KR0018 2026-03-08T12:12:25.330Z 2026-03-15T12:42:02.609Z
9439982 9439982 20260307154300_gcKD7 KR0018 2026-03-08T12:12:16.431Z 2026-03-15T12:42:02.170Z
9439502 9439502 20260307135424_WHPPI KR0018 2026-03-08T12:10:34.427Z 2026-03-15T12:41:43.046Z
9439384 9439384 20260307133745_F4Y3j KR0018 2026-03-08T12:10:15.778Z 2026-03-15T12:41:42.203Z
9439016 9439016 20260307121023_GpjEj KR0018 2026-03-08T12:09:14.937Z 2026-03-15T12:41:37.883Z
9433739 9433739 20260306113852_OQvp5 KR0018 2026-03-07T14:09:10.776Z 2026-03-14T12:40:00.331Z
9408373 9408373 20260227181716_BnZGW KR0018 2026-02-28T14:25:42.400Z 2026-03-07T14:50:48.397Z
9408017 9408017 20260227103837_HDufR KR0018 2026-02-28T14:23:06.880Z 2026-03-07T14:48:11.092Z
9396620 9396620 20260225203711_dLCen KR0018 2026-02-26T14:23:30.865Z 2026-03-05T14:38:49.138Z
9396592 9396592 20260225202248_3DPcg KR0018 2026-02-26T14:23:27.560Z 2026-03-05T14:38:46.699Z
9396475 9396475 20260225193521_7RPAg KR0018 2026-02-26T14:23:20.730Z 2026-03-05T14:38:41.631Z
9396370 9396370 20260225191559_fIBUa KR0018 2026-02-26T14:23:13.763Z 2026-03-05T14:38:38.586Z
9396083 9396083 20260225181059_35NSo KR0018 2026-02-26T14:22:47.290Z 2026-03-05T14:38:26.326Z
9396034 9396034 20260225180053_m3Y6C KR0018 2026-02-26T14:22:43.894Z 2026-03-05T14:38:24.931Z
9395936 9395936 20260225173849_eT79y KR0018 2026-02-26T14:22:37.724Z 2026-03-05T14:38:22.468Z
9395894 9395894 20260225172622_r4cqJ KR0018 2026-02-26T14:22:34.329Z 2026-03-05T14:38:21.613Z
9395800 9395800 20260225165342_UEoyd KR0018 2026-02-26T14:22:19.537Z 2026-03-05T14:38:10.574Z
9395693 9395693 20260225160603_mOLzv KR0018 2026-02-26T14:22:08.977Z 2026-03-05T14:38:04.752Z
9395669 9395669 20260225155435_2ryND KR0018 2026-02-26T14:22:06.805Z 2026-03-05T14:38:03.220Z
9395592 9395592 20260225151906_9NjIz KR0018 2026-02-26T14:22:01.392Z 2026-03-05T14:38:00.312Z
9388401 9388401 20260224154805_ZOyUg KR0018 2026-02-25T14:22:38.467Z 2026-03-04T14:18:48.463Z
9387521 9387521 20260224134847_GIX21 KR0018 2026-02-25T14:20:49.515Z 2026-03-04T14:18:34.857Z
9381183 9381183 20260222211045_aOCA9 KR0018 2026-02-24T14:24:21.337Z 2026-02-24T14:24:21.337Z
9381160 9381160 20260222210850_M2Ya9 KR0018 2026-02-24T14:24:20.070Z 2026-02-24T14:24:20.070Z
9379998 9379998 20260222184049_Tp1ed KR0018 2026-02-24T14:22:30.930Z 2026-02-24T14:22:30.930Z
9379978 9379978 20260222183705_AF6Mj KR0018 2026-02-24T14:22:29.315Z 2026-02-24T14:22:29.315Z
9379880 9379880 20260222182312_EaD2s KR0018 2026-02-24T14:22:18.385Z 2026-02-24T14:22:18.385Z
9379800 9379800 20260222180555_cb6of KR0018 2026-02-24T14:22:10.179Z 2026-02-24T14:22:10.179Z
9379542 9379542 20260222172633_f1zPQ KR0018 2026-02-24T14:21:42.773Z 2026-02-24T14:21:42.773Z
9379522 9379522 20260222172100_QCY1z KR0018 2026-02-24T14:21:40.570Z 2026-02-24T14:21:40.570Z
9379120 9379120 20260222161145_OhWQ2 KR0018 2026-02-24T14:20:44.375Z 2026-02-24T14:20:44.375Z
9379046 9379046 20260222155614_xHKUM KR0018 2026-02-24T14:20:32.561Z 2026-02-24T14:20:32.561Z
9378970 9378970 20260222154056_bIKEs KR0018 2026-02-24T14:20:18.384Z 2026-02-24T14:20:18.384Z
9378836 9378836 20260222152031_B3A58 KR0018 2026-02-24T14:19:58.467Z 2026-02-24T14:19:58.467Z
9378592 9378592 20260222143209_AAcCs KR0018 2026-02-24T14:19:09.470Z 2026-02-24T14:19:09.470Z
9378459 9378459 20260222135959_pCrOL KR0018 2026-02-24T14:18:42.928Z 2026-02-24T14:18:42.928Z
9371559 9371559 20260221183825_UB90x KR0018 2026-02-23T14:24:36.756Z 2026-03-02T14:22:11.756Z
9371533 9371533 20260221183405_sWbuR KR0018 2026-02-23T14:24:33.937Z 2026-03-02T14:22:11.444Z
9371482 9371482 20260221182247_4i9Bl KR0018 2026-02-23T14:24:23.290Z 2026-03-02T14:22:10.810Z
9371146 9371146 20260221170247_6C50k KR0018 2026-02-23T14:23:34.364Z 2026-03-02T14:22:07.329Z
9370710 9370710 20260221143145_2HLwZ KR0018 2026-02-23T14:20:54.731Z 2026-03-02T14:21:56.605Z
9364457 9364457 20260220205839_pw6tc KR0018 2026-02-22T14:21:28.777Z 2026-03-01T14:22:54.103Z
9364390 9364390 20260220204135_DTxgn KR0018 2026-02-22T14:21:21.585Z 2026-03-01T14:22:53.542Z
9364322 9364322 20260220202628_kB6r2 KR0018 2026-02-22T14:21:14.010Z 2026-03-01T14:22:52.912Z
9364079 9364079 20260220185728_BQtjg KR0018 2026-02-22T14:20:40.409Z 2026-03-01T14:22:50.635Z
9363982 9363982 20260220183242_YXv7Y KR0018 2026-02-22T14:20:25.590Z 2026-03-01T14:22:49.607Z

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