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

1,262 rows where station_code = "KR001L" 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
9257927 9257927 20260125170808_kR5el KR001L 2026-01-26T14:08:37.139Z 2026-01-29T14:37:53.454Z
9217478 9217478 20260116153941_iQFyI KR001L 2026-01-18T14:07:20.579Z 2026-01-25T14:57:19.254Z
9199700 9199700 20260113210443_BeFM2 KR001L 2026-01-15T14:12:05.244Z 2026-01-22T15:08:00.142Z
9199467 9199467 20260113200337_XxT8c KR001L 2026-01-15T14:11:00.572Z 2026-01-22T15:07:24.950Z
9193729 9193729 20260113174222_N6NYO KR001L 2026-01-14T14:03:03.618Z 2026-01-22T15:07:01.633Z
9193697 9193697 20260113173017_rJ3We KR001L 2026-01-14T14:02:52.460Z 2026-01-22T15:06:59.932Z
9193614 9193614 20260113164336_m3tzg KR001L 2026-01-14T14:02:30.192Z 2026-01-22T15:06:31.629Z
9193594 9193594 20260113163641_Lkpg4 KR001L 2026-01-14T14:02:26.168Z 2026-01-22T15:06:30.884Z
9187455 9187455 20260111171323_AWee5 KR001L 2026-01-13T14:07:23.581Z 2026-01-20T15:20:29.426Z
9170942 9170942 20260108175225_VWWEI KR001L 2026-01-10T14:04:17.696Z 2026-01-17T15:23:12.712Z
9170888 9170888 20260108172825_44x2A KR001L 2026-01-10T14:03:55.355Z 2026-01-17T15:23:09.467Z
9170816 9170816 20260108165928_CADkx KR001L 2026-01-10T14:03:33.184Z 2026-01-17T15:23:06.457Z
9170668 9170668 20260108154357_0yV0C KR001L 2026-01-10T14:02:25.911Z 2026-01-17T15:22:47.551Z
9170150 9170150 20260108145436_TsM4A KR001L 2026-01-09T14:15:55.856Z 2026-01-16T15:14:06.102Z
9120909 9120909 20251231200200_GeSSG KR001L 2026-01-02T14:04:57.283Z 2026-01-09T14:51:30.326Z
9108929 9108929 20251229195503_2k2J3 KR001L 2025-12-31T14:44:51.711Z 2026-01-06T15:22:07.053Z
9108845 9108845 20251229194433_Ag6dv KR001L 2025-12-31T14:44:38.849Z 2026-01-06T15:22:03.771Z
9108834 9108834 20251229194319_jATDo KR001L 2025-12-31T14:44:37.482Z 2026-01-06T15:22:03.276Z
9108714 9108714 20251229192451_hRDeW KR001L 2025-12-31T14:44:15.428Z 2026-01-06T15:21:45.689Z
9108429 9108429 20251229184845_Z2UIp KR001L 2025-12-31T14:43:32.104Z 2026-01-06T15:21:34.827Z
9071540 9071540 20251226185313_3mV3Q KR001L 2025-12-29T14:49:35.070Z 2026-01-03T15:42:59.599Z
9071086 9071086 20251226175139_8G3qM KR001L 2025-12-29T14:48:53.830Z 2026-01-03T15:42:28.142Z
9049948 9049948 20251226213011_3FB3U KR001L 2025-12-29T14:00:53.556Z 2026-01-04T15:23:10.614Z
9049881 9049881 20251226212118_cRdz6 KR001L 2025-12-29T14:00:26.879Z 2026-01-04T15:23:07.779Z
9015327 9015327 20251221212552_7FkkV KR001L 2025-12-27T14:54:14.449Z 2025-12-27T14:54:14.449Z
9015107 9015107 20251221210551_DXc3k KR001L 2025-12-27T14:53:57.853Z 2025-12-27T14:53:57.853Z
9015034 9015034 20251221205517_2tzyA KR001L 2025-12-27T14:53:41.465Z 2025-12-27T14:53:41.465Z
9014822 9014822 20251221202806_5vRGP KR001L 2025-12-27T14:53:22.309Z 2025-12-27T14:53:22.309Z
9014686 9014686 20251221200703_LGWF3 KR001L 2025-12-27T14:53:17.589Z 2025-12-27T14:53:17.589Z
9014642 9014642 20251221200229_Zduo7 KR001L 2025-12-27T14:53:16.405Z 2025-12-27T14:53:16.405Z
9014611 9014611 20251221195848_vud7k KR001L 2025-12-27T14:53:15.235Z 2025-12-27T14:53:15.235Z
9014576 9014576 20251221195531_6WvAY KR001L 2025-12-27T14:53:13.695Z 2025-12-27T14:53:13.695Z
9014485 9014485 20251221194734_8AFF4 KR001L 2025-12-27T14:53:09.917Z 2025-12-27T14:53:09.917Z
9013491 9013491 20251221181255_EufUY KR001L 2025-12-27T14:51:30.576Z 2025-12-27T14:51:30.576Z
9012873 9012873 20251221165437_5ov3D KR001L 2025-12-27T14:50:25.767Z 2025-12-27T14:50:25.767Z
9012409 9012409 20251221154404_IJnjz KR001L 2025-12-27T14:49:28.385Z 2025-12-27T14:49:28.385Z
9012140 9012140 20251221151857_pv982 KR001L 2025-12-27T14:49:14.891Z 2025-12-27T14:49:14.891Z
9004227 9004227 20251222160712_I0iyG KR001L 2025-12-27T14:30:31.353Z 2025-12-30T15:48:59.594Z
8992113 8992113 20251218182830_3gqrO KR001L 2025-12-26T14:50:28.474Z 2025-12-27T15:25:47.304Z
8991540 8991540 20251218165744_mkQhY KR001L 2025-12-26T14:49:01.491Z 2025-12-27T15:25:00.463Z
8991171 8991171 20251218160444_TlZzy KR001L 2025-12-26T14:48:09.007Z 2025-12-27T15:24:39.127Z
8766859 8766859 20251212182225_yIg1K KR001L 2025-12-14T14:56:04.093Z 2025-12-21T14:17:26.519Z
8766855 8766855 20251212182140_hcCTq KR001L 2025-12-14T14:56:02.779Z 2025-12-21T14:17:26.517Z
8766746 8766746 20251212180001_XY3dt KR001L 2025-12-14T14:55:51.643Z 2025-12-21T14:17:26.408Z
8766731 8766731 20251212175520_jSfxQ KR001L 2025-12-14T14:55:50.694Z 2025-12-21T14:17:26.383Z
8766589 8766589 20251212172637_vnsw3 KR001L 2025-12-14T14:54:38.526Z 2025-12-21T14:17:26.248Z
8766526 8766526 20251212171654_x5w2z KR001L 2025-12-14T14:53:53.808Z 2025-12-21T14:17:26.197Z
8766392 8766392 20251212165630_Fvf3R KR001L 2025-12-14T14:53:28.481Z 2025-12-21T14:17:26.096Z
8766329 8766329 20251212164816_0kzwR KR001L 2025-12-14T14:53:09.458Z 2025-12-21T14:17:26.055Z
8735169 8735169 20251211194214_4fh1s KR001L 2025-12-13T14:53:03.424Z 2025-12-20T14:25:08.922Z
8734996 8734996 20251211192534_4r1jP KR001L 2025-12-13T14:52:40.512Z 2025-12-20T14:25:05.524Z
8734710 8734710 20251211184735_a31zy KR001L 2025-12-13T14:52:00.170Z 2025-12-20T14:24:51.394Z
8734684 8734684 20251211184518_ce1Ya KR001L 2025-12-13T14:51:54.999Z 2025-12-20T14:24:50.582Z
8734639 8734639 20251211184017_azO0O KR001L 2025-12-13T14:51:41.389Z 2025-12-20T14:24:45.777Z
8734524 8734524 20251211182833_3fKta KR001L 2025-12-13T14:51:28.609Z 2025-12-20T14:24:41.607Z
8734381 8734381 20251211181000_gz27k KR001L 2025-12-13T14:51:00.385Z 2025-12-20T14:24:37.480Z
8734271 8734271 20251211180025_PynR0 KR001L 2025-12-13T14:50:51.257Z 2025-12-20T14:24:36.711Z
8734178 8734178 20251211175148_y1BYh KR001L 2025-12-13T14:50:27.884Z 2025-12-20T14:24:33.111Z
8734070 8734070 20251211174039_Mf2t7 KR001L 2025-12-13T14:50:06.232Z 2025-12-20T14:24:30.452Z
8734035 8734035 20251211173646_DgslN KR001L 2025-12-13T14:50:02.729Z 2025-12-20T14:24:30.238Z
8733566 8733566 20251211164612_3dZh5 KR001L 2025-12-13T14:48:49.664Z 2025-12-20T14:24:13.614Z
8733557 8733557 20251211164427_C5UiO KR001L 2025-12-13T14:48:48.962Z 2025-12-20T14:24:13.489Z
8733326 8733326 20251211161721_GkPtz KR001L 2025-12-13T14:48:15.829Z 2025-12-20T14:24:08.752Z
8733255 8733255 20251211160405_AA3cV KR001L 2025-12-13T14:48:08.383Z 2025-12-20T14:24:06.744Z
8705374 8705374 20251208185711_R4j3R KR001L 2025-12-09T14:16:29.055Z 2025-12-17T15:32:49.971Z
8705209 8705209 20251208181827_q0dpL KR001L 2025-12-09T14:16:12.647Z 2025-12-17T15:32:15.895Z
8705174 8705174 20251208181259_4ZJsp KR001L 2025-12-09T14:16:07.406Z 2025-12-17T15:32:13.546Z
8704999 8704999 20251208173713_Fzhfl KR001L 2025-12-09T14:15:53.187Z 2025-12-17T15:32:02.987Z
8704859 8704859 20251208171515_PXF6M KR001L 2025-12-09T14:15:41.795Z 2025-12-17T15:32:01.940Z
8650212 8650212 20251129193953_2y5rJ KR001L 2025-12-01T14:15:26.908Z 2025-12-08T14:52:55.596Z
8649454 8649454 20251129172927_0NiSL KR001L 2025-12-01T14:12:38.823Z 2025-12-08T14:52:13.522Z
8645022 8645022 20251128202910_WDhF6 KR001L 2025-11-30T14:22:58.988Z 2025-12-07T14:57:02.705Z
8643729 8643729 20251128181947_2Tm3K KR001L 2025-11-30T14:20:37.557Z 2025-12-07T14:56:07.240Z
8643173 8643173 20251128173041_S925x KR001L 2025-11-30T14:19:25.291Z 2025-12-07T14:55:56.750Z
8643169 8643169 20251128173002_srnC6 KR001L 2025-11-30T14:19:24.993Z 2025-12-07T14:55:56.652Z
8643089 8643089 20251128172033_HAxIu KR001L 2025-11-30T14:19:19.231Z 2025-12-07T14:55:38.683Z
8643079 8643079 20251128171932_HnQ2Y KR001L 2025-11-30T14:19:18.422Z 2025-12-07T14:55:37.195Z
8578410 8578410 20251122203455_XaL2y KR001L 2025-11-24T14:11:41.815Z 2025-12-01T15:19:35.031Z
8565202 8565202 20251121200246_zPWwK KR001L 2025-11-23T14:12:45.424Z 2025-11-30T15:04:47.518Z
8564832 8564832 20251121191913_lADDy KR001L 2025-11-23T14:11:47.802Z 2025-11-30T15:04:29.415Z
8564817 8564817 20251121191457_zzLqT KR001L 2025-11-23T14:11:45.623Z 2025-11-30T15:04:29.059Z
8564655 8564655 20251121185321_yAgcE KR001L 2025-11-23T14:11:22.207Z 2025-11-30T15:04:25.609Z
8564648 8564648 20251121185256_vKq2x KR001L 2025-11-23T14:11:18.819Z 2025-11-30T15:04:25.592Z
8564551 8564551 20251121183920_ue4Gu KR001L 2025-11-23T14:11:05.677Z 2025-11-30T15:04:23.882Z
8564277 8564277 20251121181540_3sXho KR001L 2025-11-23T14:10:30.641Z 2025-11-30T15:04:11.329Z
8564257 8564257 20251121181502_Wptod KR001L 2025-11-23T14:10:28.484Z 2025-11-30T15:04:11.047Z
8563910 8563910 20251121173926_CCce7 KR001L 2025-11-23T14:09:36.175Z 2025-11-30T15:03:53.952Z
8563800 8563800 20251121172330_nPzPw KR001L 2025-11-23T14:09:21.131Z 2025-11-30T15:03:46.686Z
8563667 8563667 20251121170427_5Hmmy KR001L 2025-11-23T14:08:55.738Z 2025-11-30T15:03:43.467Z
8548763 8548763 20251120211512_nSlvE KR001L 2025-11-22T14:17:35.579Z 2025-11-29T14:54:23.286Z
8548431 8548431 20251120205515_UBjqP KR001L 2025-11-22T14:16:53.380Z 2025-11-29T14:54:22.674Z
8548379 8548379 20251120205220_AGLiw KR001L 2025-11-22T14:16:49.689Z 2025-11-29T14:54:22.557Z
8547638 8547638 20251120200453_rUyIb KR001L 2025-11-22T14:15:24.764Z 2025-11-29T14:54:20.642Z
8547118 8547118 20251120192500_JIkso KR001L 2025-11-22T14:14:22.455Z 2025-11-29T14:54:18.621Z
8546340 8546340 20251120182212_268eW KR001L 2025-11-22T14:12:35.106Z 2025-11-29T14:54:12.960Z
8545851 8545851 20251120173541_0fowz KR001L 2025-11-22T14:11:26.749Z 2025-11-29T14:54:06.378Z
8545767 8545767 20251120172927_wahnT KR001L 2025-11-22T14:11:11.657Z 2025-11-29T14:54:06.241Z
8480318 8480318 20251115210049_XEi5e KR001L 2025-11-17T14:17:50.854Z 2025-11-24T15:04:51.743Z
8480049 8480049 20251115202705_3G1hk KR001L 2025-11-17T14:17:19.400Z 2025-11-24T15:04:50.005Z
8479833 8479833 20251115200052_lU82u KR001L 2025-11-17T14:16:58.863Z 2025-11-24T15:04:48.221Z

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