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,778 rows where station_code = "KR002B" 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
8689274 8689274 20251205145726_j1W3Q KR002B 2025-12-06T14:07:41.940Z 2025-12-06T14:07:41.940Z
8686947 8686947 20251203212135_zS9S8 KR002B 2025-12-05T14:13:14.519Z 2025-12-06T14:22:12.843Z
8686896 8686896 20251203211125_BCMKt KR002B 2025-12-05T14:13:10.089Z 2025-12-06T14:22:11.078Z
8679927 8679927 20251202211128_dzH0l KR002B 2025-12-04T14:10:47.090Z 2025-12-06T14:26:44.512Z
8659227 8659227 20251130095206_eaUbz KR002B 2025-12-02T14:03:03.172Z 2025-12-06T14:36:11.588Z
8650623 8650623 20251129205129_dLRKU KR002B 2025-12-01T14:16:44.117Z 2025-12-06T14:46:28.890Z
8650607 8650607 20251129205116_WkMtu KR002B 2025-12-01T14:16:37.056Z 2025-12-06T14:46:27.786Z
8650075 8650075 20251129191840_b3vI2 KR002B 2025-12-01T14:15:00.692Z 2025-12-06T14:45:47.354Z
8649591 8649591 20251129175315_xEJiy KR002B 2025-12-01T14:13:11.330Z 2025-12-06T14:45:33.646Z
8649374 8649374 20251129171614_P3yrF KR002B 2025-12-01T14:12:19.370Z 2025-12-06T14:45:03.891Z
8649141 8649141 20251129162202_zRR8b KR002B 2025-12-01T14:11:06.052Z 2025-12-06T14:44:49.791Z
8649012 8649012 20251129154502_pc42D KR002B 2025-12-01T14:10:27.469Z 2025-12-06T14:44:45.721Z
8645025 8645025 20251128202910_WDhF6 KR002B 2025-11-30T14:22:58.988Z 2025-12-06T14:54:50.086Z
8644758 8644758 20251128195308_wLQs2 KR002B 2025-11-30T14:22:23.074Z 2025-12-06T14:54:47.139Z
8644256 8644256 20251128191146_ohpmQ KR002B 2025-11-30T14:21:31.664Z 2025-12-06T14:54:39.824Z
8643984 8643984 20251128184711_FiLSF KR002B 2025-11-30T14:20:57.300Z 2025-12-06T14:54:36.449Z
8643733 8643733 20251128181947_2Tm3K KR002B 2025-11-30T14:20:37.558Z 2025-12-06T14:54:10.927Z
8643332 8643332 20251128174355_nhcnu KR002B 2025-11-30T14:19:54.220Z 2025-12-06T14:53:47.833Z
8643185 8643185 20251128173137_mKfS7 KR002B 2025-11-30T14:19:25.826Z 2025-12-06T14:53:42.847Z
8643178 8643178 20251128173041_S925x KR002B 2025-11-30T14:19:25.292Z 2025-12-06T14:53:42.512Z
8643171 8643171 20251128173002_srnC6 KR002B 2025-11-30T14:19:24.993Z 2025-12-06T14:53:42.401Z
8643043 8643043 20251128171527_7Xmyg KR002B 2025-11-30T14:19:15.953Z 2025-12-06T14:53:39.773Z
8642714 8642714 20251128164044_h2Agd KR002B 2025-11-30T14:18:30.823Z 2025-12-06T14:53:35.440Z
8642666 8642666 20251128163457_hA6t2 KR002B 2025-11-30T14:18:26.085Z 2025-12-06T14:53:34.670Z
8642444 8642444 20251128160517_65sfG KR002B 2025-11-30T14:17:55.411Z 2025-12-06T14:53:31.805Z
8642431 8642431 20251128160343_wd2U3 KR002B 2025-11-30T14:17:54.219Z 2025-12-06T14:53:31.575Z
8642401 8642401 20251128160047_o8WTp KR002B 2025-11-30T14:17:52.261Z 2025-12-06T14:53:31.172Z
8642287 8642287 20251128154737_kglXx KR002B 2025-11-30T14:17:44.299Z 2025-12-06T14:53:28.536Z
8642176 8642176 20251128153659_YjG4t KR002B 2025-11-30T14:17:38.633Z 2025-12-06T14:53:21.196Z
8641040 8641040 20251128132302_vMaBi KR002B 2025-11-30T14:13:43.237Z 2025-12-06T14:52:19.805Z
8632037 8632037 20251127202516_2eHZB KR002B 2025-11-29T14:16:45.164Z 2025-12-06T15:00:50.456Z
8621604 8621604 20251126154555_Z8KZd KR002B 2025-11-28T14:16:14.278Z 2025-12-05T15:02:45.803Z
8621589 8621589 20251126154410_6CNgp KR002B 2025-11-28T14:16:12.829Z 2025-12-05T15:02:45.700Z
8621414 8621414 20251126150832_eksiN KR002B 2025-11-28T14:15:40.534Z 2025-12-05T15:02:44.025Z
8620975 8620975 20251126140700_7Z4gD KR002B 2025-11-28T14:14:27.549Z 2025-12-05T15:02:39.290Z
8620468 8620468 20251126124006_rUGt2 KR002B 2025-11-28T14:12:50.249Z 2025-12-05T15:02:06.566Z
8620397 8620397 20251126122816_SJisL KR002B 2025-11-28T14:12:38.242Z 2025-12-05T15:01:59.219Z
8619988 8619988 20251126112859_aaQCT KR002B 2025-11-28T14:11:19.704Z 2025-12-05T15:01:19.267Z
8606797 8606797 20251125194313_4wZqu KR002B 2025-11-27T14:11:28.660Z 2025-12-04T15:06:50.674Z
8606749 8606749 20251125193707_FDrhv KR002B 2025-11-27T14:11:15.330Z 2025-12-04T15:06:49.728Z
8606274 8606274 20251125183029_5DOB5 KR002B 2025-11-27T14:09:42.587Z 2025-12-04T15:06:43.337Z
8606198 8606198 20251125181824_SvIqR KR002B 2025-11-27T14:09:26.441Z 2025-12-04T15:06:35.362Z
8578377 8578377 20251122203132_lKDRD KR002B 2025-11-24T14:11:37.959Z 2025-12-01T15:19:33.510Z
8577269 8577269 20251122174851_2J8CM KR002B 2025-11-24T14:08:09.996Z 2025-12-01T15:18:46.072Z
8576772 8576772 20251122160958_TukYk KR002B 2025-11-24T14:06:42.953Z 2025-12-01T15:18:39.899Z
8576735 8576735 20251122155714_dWSDD KR002B 2025-11-24T14:06:32.640Z 2025-12-01T15:18:39.561Z
8576303 8576303 20251122144615_PbcmK KR002B 2025-11-24T14:05:21.974Z 2025-12-01T15:18:35.117Z
8576242 8576242 20251122143946_wQpA9 KR002B 2025-11-24T14:05:15.059Z 2025-12-01T15:18:34.576Z
8575663 8575663 20251122131210_rX2Kw KR002B 2025-11-24T14:03:49.083Z 2025-12-01T15:18:29.534Z
8575599 8575599 20251122130048_SuTrW KR002B 2025-11-24T14:03:38.033Z 2025-12-01T15:18:28.504Z
8575391 8575391 20251122122742_22pKJ KR002B 2025-11-24T14:03:05.383Z 2025-12-01T15:18:20.001Z
8575345 8575345 20251122121519_Eq2nw KR002B 2025-11-24T14:02:56.753Z 2025-12-01T15:18:16.936Z
8575301 8575301 20251122120929_V5a24 KR002B 2025-11-24T14:02:43.835Z 2025-12-01T15:18:13.600Z
8570745 8570745 20251121114453_qmvgR KR002B 2025-11-23T14:34:07.188Z 2025-11-30T15:02:49.031Z
8565786 8565786 20251121211410_YvxX7 KR002B 2025-11-23T14:14:03.856Z 2025-11-30T15:05:08.765Z
8565321 8565321 20251121201919_hPyMj KR002B 2025-11-23T14:12:59.419Z 2025-11-30T15:04:54.457Z
8565186 8565186 20251121200131_Nynjy KR002B 2025-11-23T14:12:43.318Z 2025-11-30T15:04:44.925Z
8565053 8565053 20251121194249_wmSAC KR002B 2025-11-23T14:12:20.939Z 2025-11-30T15:04:39.797Z
8565008 8565008 20251121193746_UnoBX KR002B 2025-11-23T14:12:15.072Z 2025-11-30T15:04:39.057Z
8564834 8564834 20251121191913_lADDy KR002B 2025-11-23T14:11:47.802Z 2025-11-30T15:04:29.415Z
8564818 8564818 20251121191457_zzLqT KR002B 2025-11-23T14:11:45.623Z 2025-11-30T15:04:29.059Z
8564590 8564590 20251121184412_urTa8 KR002B 2025-11-23T14:11:11.275Z 2025-11-30T15:04:24.954Z
8564289 8564289 20251121181702_o0l7z KR002B 2025-11-23T14:10:31.465Z 2025-11-30T15:04:12.293Z
8564280 8564280 20251121181540_3sXho KR002B 2025-11-23T14:10:30.641Z 2025-11-30T15:04:11.330Z
8564259 8564259 20251121181502_Wptod KR002B 2025-11-23T14:10:28.484Z 2025-11-30T15:04:11.047Z
8564081 8564081 20251121175131_Qrabe KR002B 2025-11-23T14:10:00.457Z 2025-11-30T15:04:05.346Z
8563914 8563914 20251121173926_CCce7 KR002B 2025-11-23T14:09:36.175Z 2025-11-30T15:03:53.952Z
8563802 8563802 20251121172330_nPzPw KR002B 2025-11-23T14:09:21.131Z 2025-11-30T15:03:46.686Z
8563450 8563450 20251121162132_Gp0x4 KR002B 2025-11-23T14:08:20.490Z 2025-11-30T15:03:39.686Z
8563327 8563327 20251121154842_3ARtS KR002B 2025-11-23T14:08:00.172Z 2025-11-30T15:03:38.410Z
8563162 8563162 20251121152207_p24Pl KR002B 2025-11-23T14:07:30.050Z 2025-11-30T15:03:36.059Z
8563153 8563153 20251121152019_6q2wd KR002B 2025-11-23T14:07:28.319Z 2025-11-30T15:03:35.955Z
8562200 8562200 20251121134810_efI4U KR002B 2025-11-23T14:04:55.382Z 2025-11-30T15:03:24.346Z
8562142 8562142 20251121134026_z2xoB KR002B 2025-11-23T14:04:45.736Z 2025-11-30T15:03:23.764Z
8561549 8561549 20251121122647_UXuYT KR002B 2025-11-23T14:03:02.413Z 2025-11-30T15:02:58.702Z
8561149 8561149 20251121114453_v8yQv KR002B 2025-11-23T14:01:55.371Z 2025-11-30T15:02:49.036Z
8560995 8560995 20251121112958_RWd7w KR002B 2025-11-23T14:01:31.595Z 2025-11-30T15:02:42.539Z
8548521 8548521 20251120205941_3G2Fb KR002B 2025-11-22T14:17:07.375Z 2025-11-29T14:54:22.793Z
8548071 8548071 20251120203456_crxH3 KR002B 2025-11-22T14:16:15.568Z 2025-11-29T14:54:21.776Z
8547874 8547874 20251120201925_svCGb KR002B 2025-11-22T14:15:50.250Z 2025-11-29T14:54:21.185Z
8547435 8547435 20251120195035_j0pA2 KR002B 2025-11-22T14:15:08.341Z 2025-11-29T14:54:19.927Z
8547164 8547164 20251120192814_BLWJa KR002B 2025-11-22T14:14:30.143Z 2025-11-29T14:54:18.847Z
8547119 8547119 20251120192500_JIkso KR002B 2025-11-22T14:14:22.455Z 2025-11-29T14:54:18.621Z
8546864 8546864 20251120190223_CGZrT KR002B 2025-11-22T14:13:46.776Z 2025-11-29T14:54:17.910Z
8546472 8546472 20251120183312_ctYot KR002B 2025-11-22T14:12:49.115Z 2025-11-29T14:54:15.530Z
8546468 8546468 20251120183312_nCgGq KR002B 2025-11-22T14:12:48.883Z 2025-11-29T14:54:15.528Z
8545769 8545769 20251120172927_wahnT KR002B 2025-11-22T14:11:11.664Z 2025-11-29T14:54:06.241Z
8545550 8545550 20251120170431_ChPz3 KR002B 2025-11-22T14:10:49.053Z 2025-11-29T14:54:03.592Z
8545264 8545264 20251120163239_JqI3B KR002B 2025-11-22T14:10:04.658Z 2025-11-29T14:54:02.273Z
8545235 8545235 20251120162944_ALckF KR002B 2025-11-22T14:10:01.321Z 2025-11-29T14:54:02.099Z
8537288 8537288 20251119095500_fbBCU KR002B 2025-11-21T14:30:56.791Z 2025-11-27T15:13:33.841Z
8533975 8533975 20251119211621_esS7G KR002B 2025-11-21T14:12:41.848Z 2025-11-28T14:55:25.710Z
8533021 8533021 20251119173533_6TXLa KR002B 2025-11-21T14:09:31.018Z 2025-11-28T14:54:08.469Z
8532308 8532308 20251119155413_c26GA KR002B 2025-11-21T14:07:43.741Z 2025-11-28T14:53:55.351Z
8531545 8531545 20251119143850_yU1DY KR002B 2025-11-21T14:05:31.137Z 2025-11-28T14:53:36.444Z
8525271 8525271 20251118092914_EHhmQ KR002B 2025-11-20T14:35:55.142Z 2025-11-26T15:08:17.436Z
8520894 8520894 20251118201221_Xq22E KR002B 2025-11-20T14:11:11.768Z 2025-11-27T15:11:36.110Z
8500976 8500976 20251116100902_NXjKg KR002B 2025-11-18T14:46:48.128Z 2025-11-24T15:06:05.631Z
8500916 8500916 20251116100200_3EX4Y KR002B 2025-11-18T14:46:42.812Z 2025-11-24T15:06:03.051Z
8490845 8490845 20251116203911_8zgLp KR002B 2025-11-18T14:15:34.566Z 2025-11-25T15:08:28.527Z

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