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

2,545 rows where station_code = "KR002J" 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
8749888 8749888 20251209161335_Di8HI KR002J 2025-12-13T15:37:02.140Z 2025-12-17T15:26:14.717Z
8749881 8749881 20251209161246_xafW1 KR002J 2025-12-13T15:37:02.084Z 2025-12-17T15:26:14.701Z
8749579 8749579 20251209151131_E26vz KR002J 2025-12-13T15:36:38.694Z 2025-12-17T15:26:10.952Z
8749555 8749555 20251209150834_kaFV7 KR002J 2025-12-13T15:36:35.112Z 2025-12-17T15:26:10.717Z
8748692 8748692 20251209130926_RvGXF KR002J 2025-12-13T15:35:03.688Z 2025-12-17T15:25:11.134Z
8748328 8748328 20251209121725_DYHdU KR002J 2025-12-13T15:34:17.885Z 2025-12-17T15:25:03.259Z
8748133 8748133 20251209115135_383Sw KR002J 2025-12-13T15:33:42.132Z 2025-12-17T15:24:59.162Z
8747927 8747927 20251209112014_kVcan KR002J 2025-12-13T15:33:26.559Z 2025-12-17T15:24:42.163Z
8747752 8747752 20251209105218_GY5Og KR002J 2025-12-13T15:32:54.722Z 2025-12-17T15:24:17.998Z
8747472 8747472 20251209093718_e98Q3 KR002J 2025-12-13T15:31:55.446Z 2025-12-17T15:23:17.129Z
8731101 8731101 20251211124442_VSywZ KR002J 2025-12-13T14:41:39.342Z 2025-12-20T14:23:43.079Z
8730944 8730944 20251211123541_sxrpZ KR002J 2025-12-13T14:41:16.017Z 2025-12-20T14:23:42.034Z
8730859 8730859 20251211115521_uyzSs KR002J 2025-12-13T14:38:55.969Z 2025-12-20T14:23:37.572Z
8730850 8730850 20251211115119_w3JyX KR002J 2025-12-13T14:38:37.598Z 2025-12-20T14:23:37.098Z
8730822 8730822 20251211114050_ysckN KR002J 2025-12-13T14:37:55.040Z 2025-12-20T14:23:35.476Z
8730786 8730786 20251211113045_Oum2m KR002J 2025-12-13T14:37:10.661Z 2025-12-20T14:23:31.385Z
8730698 8730698 20251211100951_nPy1w KR002J 2025-12-13T14:33:02.916Z 2025-12-20T14:23:02.060Z
8730650 8730650 20251211093009_gkkbV KR002J 2025-12-13T14:31:19.128Z 2025-12-20T14:22:51.045Z
8705939 8705939 20251208211131_U4D3C KR002J 2025-12-09T14:17:26.127Z 2025-12-09T14:17:26.127Z
8705928 8705928 20251208211028_uU8YP KR002J 2025-12-09T14:17:25.211Z 2025-12-17T15:33:38.058Z
8705840 8705840 20251208204749_DkoQl KR002J 2025-12-09T14:17:17.680Z 2025-12-17T15:33:31.803Z
8705733 8705733 20251208203031_DdvnE KR002J 2025-12-09T14:17:10.290Z 2025-12-17T15:33:22.974Z
8705629 8705629 20251208201227_04GaD KR002J 2025-12-09T14:16:59.222Z 2025-12-17T15:33:15.489Z
8705591 8705591 20251208195435_gQnAH KR002J 2025-12-09T14:16:44.405Z 2025-12-17T15:33:10.025Z
8705527 8705527 20251208194141_Zogf3 KR002J 2025-12-09T14:16:37.734Z 2025-12-17T15:32:58.317Z
8705480 8705480 20251208193404_JKrWt KR002J 2025-12-09T14:16:35.489Z 2025-12-17T15:32:57.426Z
8705470 8705470 20251208193200_vaaMn KR002J 2025-12-09T14:16:35.293Z 2025-12-17T15:32:56.328Z
8705407 8705407 20251208190213_6DMwA KR002J 2025-12-09T14:16:30.512Z 2025-12-17T15:32:52.267Z
8705296 8705296 20251208183703_7IX2I KR002J 2025-12-09T14:16:23.818Z 2025-12-17T15:32:38.696Z
8705285 8705285 20251208183354_UTvxt KR002J 2025-12-09T14:16:23.185Z 2025-12-17T15:32:38.085Z
8705110 8705110 20251208175900_fsYdu KR002J 2025-12-09T14:16:01.797Z 2025-12-17T15:32:07.113Z
8705103 8705103 20251208175345_oelqa KR002J 2025-12-09T14:16:00.312Z 2025-12-17T15:32:05.529Z
8705074 8705074 20251208175124_fmlDG KR002J 2025-12-09T14:15:59.426Z 2025-12-17T15:32:04.635Z
8705050 8705050 20251208174732_Pjrqr KR002J 2025-12-09T14:15:57.528Z 2025-12-17T15:32:04.129Z
8705039 8705039 20251208174340_3D162 KR002J 2025-12-09T14:15:56.268Z 2025-12-17T15:32:03.912Z
8705033 8705033 20251208174308_mV2gS KR002J 2025-12-09T14:15:55.959Z 2025-12-17T15:32:03.866Z
8705026 8705026 20251208174104_t8WIK KR002J 2025-12-09T14:15:54.859Z 2025-12-17T15:32:03.204Z
8704940 8704940 20251208173127_bzLNt KR002J 2025-12-09T14:15:50.169Z 2025-12-17T15:32:02.624Z
8704782 8704782 20251208165711_VVEZt KR002J 2025-12-09T14:15:23.988Z 2025-12-17T15:32:01.040Z
8704670 8704670 20251208163022_yEYoM KR002J 2025-12-09T14:15:11.117Z 2025-12-17T15:31:59.497Z
8704642 8704642 20251208162325_6ZUk3 KR002J 2025-12-09T14:15:08.664Z 2025-12-17T15:31:58.897Z
8704593 8704593 20251208161232_wiabQ KR002J 2025-12-09T14:15:03.670Z 2025-12-17T15:31:58.342Z
8704578 8704578 20251208160716_paD1h KR002J 2025-12-09T14:15:01.948Z 2025-12-17T15:31:55.547Z
8704552 8704552 20251208160204_yJFTl KR002J 2025-12-09T14:14:48.266Z 2025-12-17T15:31:55.232Z
8704460 8704460 20251208154251_51f8k KR002J 2025-12-09T14:14:34.082Z 2025-12-17T15:31:54.655Z
8704403 8704403 20251208153201_3ZA5J KR002J 2025-12-09T14:14:27.348Z 2025-12-17T15:31:54.194Z
8704057 8704057 20251208144535_l2cML KR002J 2025-12-09T14:13:37.778Z 2025-12-17T15:31:50.971Z
8703686 8703686 20251208135951_SCUA3 KR002J 2025-12-09T14:12:33.027Z 2025-12-17T15:31:47.165Z
8703676 8703676 20251208135951_eGott KR002J 2025-12-09T14:12:32.679Z 2025-12-17T15:31:47.147Z
8703672 8703672 20251208135951_8oMqU KR002J 2025-12-09T14:12:32.569Z 2025-12-17T15:31:47.141Z
8703417 8703417 20251208132830_UY22S KR002J 2025-12-09T14:11:45.995Z 2025-12-17T15:31:43.866Z
8702983 8702983 20251208122059_Y2q5h KR002J 2025-12-09T14:10:23.146Z 2025-12-17T15:31:38.586Z
8701611 8701611 20251208100255_opWn3 KR002J 2025-12-09T14:05:39.299Z 2025-12-17T15:30:37.367Z
8679939 8679939 20251202211143_e9zZy KR002J 2025-12-04T14:10:47.581Z 2025-12-11T14:45:02.698Z
8679747 8679747 20251202204654_IR28D KR002J 2025-12-04T14:10:21.906Z 2025-12-11T14:44:56.346Z
8679744 8679744 20251202204519_Hy2XJ KR002J 2025-12-04T14:10:21.415Z 2025-12-11T14:44:56.284Z
8679565 8679565 20251202202137_4VGjt KR002J 2025-12-04T14:09:58.234Z 2025-12-11T14:44:51.284Z
8679519 8679519 20251202201925_iWOSD KR002J 2025-12-04T14:09:55.646Z 2025-12-11T14:44:50.519Z
8679490 8679490 20251202201618_6vyBb KR002J 2025-12-04T14:09:53.549Z 2025-12-11T14:44:50.021Z
8678399 8678399 20251202122418_n2BiO KR002J 2025-12-04T14:06:33.167Z 2025-12-11T14:43:37.095Z
8671818 8671818 20251201130228_wCj3b KR002J 2025-12-03T14:13:52.235Z 2025-12-10T14:37:22.152Z
8671025 8671025 20251201110448_2w3vr KR002J 2025-12-03T14:11:06.872Z 2025-12-10T14:37:05.837Z
8670748 8670748 20251201100645_gJUnc KR002J 2025-12-03T14:09:58.957Z 2025-12-10T14:36:45.011Z
8670606 8670606 20251201094029_hOwoh KR002J 2025-12-03T14:09:29.412Z 2025-12-10T14:36:40.591Z
8663640 8663640 20251130211331_lyfQD KR002J 2025-12-02T14:18:38.589Z 2025-12-09T14:57:38.790Z
8663620 8663620 20251130211050_g77yF KR002J 2025-12-02T14:18:36.595Z 2025-12-09T14:57:34.993Z
8663611 8663611 20251130210853_B43zY KR002J 2025-12-02T14:18:34.118Z 2025-12-09T14:57:34.770Z
8663458 8663458 20251130204818_SC295 KR002J 2025-12-02T14:18:19.502Z 2025-12-09T14:57:32.072Z
8663202 8663202 20251130202039_rRP0N KR002J 2025-12-02T14:17:40.591Z 2025-12-09T14:57:26.670Z
8663171 8663171 20251130201748_ljGlA KR002J 2025-12-02T14:17:34.544Z 2025-12-09T14:57:25.957Z
8650393 8650393 20251129200710_5UnKV KR002J 2025-12-01T14:16:00.321Z 2025-12-08T14:52:58.759Z
8650191 8650191 20251129193609_IsgkW KR002J 2025-12-01T14:15:22.085Z 2025-12-08T14:52:54.747Z
8649445 8649445 20251129172719_DUeIJ KR002J 2025-12-01T14:12:36.554Z 2025-12-08T14:52:11.542Z
8645052 8645052 20251128203157_S9I3L KR002J 2025-11-30T14:23:01.018Z 2025-12-07T14:57:03.035Z
8644979 8644979 20251128202023_Qulkr KR002J 2025-11-30T14:22:55.390Z 2025-12-07T14:57:01.690Z
8644800 8644800 20251128195852_7DrIC KR002J 2025-11-30T14:22:39.928Z 2025-12-07T14:56:42.864Z
8644331 8644331 20251128192027_llAF7 KR002J 2025-11-30T14:21:39.551Z 2025-12-07T14:56:19.496Z
8643816 8643816 20251128182845_daYCF KR002J 2025-11-30T14:20:42.603Z 2025-12-07T14:56:08.569Z
8643671 8643671 20251128181308_VYppI KR002J 2025-11-30T14:20:32.499Z 2025-12-07T14:56:05.985Z
8643622 8643622 20251128180917_Hfee4 KR002J 2025-11-30T14:20:22.652Z 2025-12-07T14:56:05.103Z
8642841 8642841 20251128165403_40yKp KR002J 2025-11-30T14:18:42.440Z 2025-12-07T14:55:17.455Z
8642566 8642566 20251128162403_UP7SE KR002J 2025-11-30T14:18:18.915Z 2025-12-07T14:55:10.841Z
8641678 8641678 20251128150659_2k8D8 KR002J 2025-11-30T14:16:40.330Z 2025-12-07T14:54:58.312Z
8640980 8640980 20251128130942_VsRh3 KR002J 2025-11-30T14:13:11.548Z 2025-12-07T14:54:05.270Z
8640907 8640907 20251128124308_fLDDD KR002J 2025-11-30T14:12:03.366Z 2025-12-07T14:53:39.787Z
8632518 8632518 20251127211644_lS2py KR002J 2025-11-29T14:17:45.186Z 2025-12-06T15:01:24.095Z
8632482 8632482 20251127211154_lzR99 KR002J 2025-11-29T14:17:42.935Z 2025-12-06T15:01:20.405Z
8632259 8632259 20251127204427_osrgo KR002J 2025-11-29T14:17:11.415Z 2025-12-06T15:01:07.012Z
8632146 8632146 20251127203539_Bn3Pb KR002J 2025-11-29T14:17:03.024Z 2025-12-06T15:00:54.507Z
8632072 8632072 20251127202903_yvOWe KR002J 2025-11-29T14:16:47.878Z 2025-12-06T15:00:51.020Z
8632062 8632062 20251127202756_czi2g KR002J 2025-11-29T14:16:46.935Z 2025-12-06T15:00:50.934Z
8631949 8631949 20251127201623_is8xd KR002J 2025-11-29T14:16:36.002Z 2025-12-06T15:00:47.615Z
8631828 8631828 20251127200424_vNlQe KR002J 2025-11-29T14:16:26.507Z 2025-12-06T15:00:43.516Z
8631795 8631795 20251127200113_3YOjs KR002J 2025-11-29T14:16:24.376Z 2025-12-06T15:00:42.208Z
8631688 8631688 20251127194433_cp1SB KR002J 2025-11-29T14:16:02.336Z 2025-12-06T15:00:35.682Z
8631655 8631655 20251127193857_8XHj4 KR002J 2025-11-29T14:15:55.386Z 2025-12-06T15:00:33.540Z
8631596 8631596 20251127192943_A9o25 KR002J 2025-11-29T14:15:48.365Z 2025-12-06T15:00:22.487Z
8631476 8631476 20251127191255_sEvhk KR002J 2025-11-29T14:15:26.811Z 2025-12-06T15:00:13.700Z
8631278 8631278 20251127184340_n7iZ6 KR002J 2025-11-29T14:15:03.683Z 2025-12-06T15:00:02.865Z
8631128 8631128 20251127182259_SlPEG KR002J 2025-11-29T14:14:37.883Z 2025-12-06T14:59:54.742Z

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