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

5,755 rows where station_code = "SK0003" 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
7777927 7777927 20250905210037_D0Edf SK0003 2025-09-07T12:03:35.967Z 2025-09-14T12:48:53.356Z
7777472 7777472 20250905191048_V82VU SK0003 2025-09-07T12:01:46.905Z 2025-09-14T12:48:48.344Z
7772734 7772734 20250905023333_l2gMX SK0003 2025-09-06T13:15:09.193Z 2025-09-13T12:57:41.205Z
7772614 7772614 20250905023028_3Km5V SK0003 2025-09-06T13:14:58.843Z 2025-09-13T12:57:40.435Z
7772214 7772214 20250905021423_Fgvin SK0003 2025-09-06T13:13:39.022Z 2025-09-13T12:57:30.167Z
7772095 7772095 20250905020932_0Mhpq SK0003 2025-09-06T13:13:16.221Z 2025-09-13T12:57:27.322Z
7771931 7771931 20250905020235_3R1bv SK0003 2025-09-06T13:12:42.605Z 2025-09-13T12:57:21.875Z
7771425 7771425 20250905013949_5bs2e SK0003 2025-09-06T13:11:12.612Z 2025-09-13T12:57:06.933Z
7771292 7771292 20250905013424_PZHE5 SK0003 2025-09-06T13:10:44.539Z 2025-09-13T12:57:03.582Z
7770332 7770332 20250905004328_zI2kc SK0003 2025-09-06T13:03:24.471Z 2025-09-13T12:56:39.632Z
7770219 7770219 20250905003836_g5Rrr SK0003 2025-09-06T13:01:43.398Z 2025-09-13T12:56:35.726Z
7769676 7769676 20250905000546_80Wqp SK0003 2025-09-06T12:56:35.782Z 2025-09-13T12:56:23.204Z
7768953 7768953 20250904230928_Z622Z SK0003 2025-09-06T12:45:07.679Z 2025-09-13T12:56:07.601Z
7768950 7768950 20250904230928_X7mIV SK0003 2025-09-06T12:45:03.030Z 2025-09-13T12:56:07.590Z
7768935 7768935 20250904230729_o5HE0 SK0003 2025-09-06T12:44:37.622Z 2025-09-13T12:56:06.440Z
7768545 7768545 20250904221851_JVttX SK0003 2025-09-06T12:39:08.315Z 2025-09-13T12:55:37.266Z
7768298 7768298 20250904215018_IT3S1 SK0003 2025-09-06T12:37:35.764Z 2025-09-13T12:55:30.318Z
7767996 7767996 20250904211147_3k5Ju SK0003 2025-09-06T12:33:11.669Z 2025-09-13T12:55:23.079Z
7767908 7767908 20250904210028_j4Xe8 SK0003 2025-09-06T12:32:02.930Z 2025-09-13T12:55:17.738Z
7767892 7767892 20250904205735_7cWNT SK0003 2025-09-06T12:31:34.230Z 2025-09-13T12:55:17.495Z
7767456 7767456 20250904201154_3LQ0r SK0003 2025-09-06T12:27:57.836Z 2025-09-13T12:54:57.225Z
7767360 7767360 20250904195947_NKPl7 SK0003 2025-09-06T12:26:26.184Z 2025-09-13T12:54:53.645Z
7767247 7767247 20250904194501_7CG3y SK0003 2025-09-06T12:24:09.897Z 2025-09-13T12:54:46.079Z
7767226 7767226 20250904193902_rUr4t SK0003 2025-09-06T12:23:51.565Z 2025-09-13T12:54:45.316Z
7763977 7763977 20250904025821_VnQNZ SK0003 2025-09-05T12:22:40.524Z 2025-09-12T12:51:16.616Z
7763758 7763758 20250904024528_8jwf7 SK0003 2025-09-05T12:22:00.944Z 2025-09-12T12:51:05.110Z
7763699 7763699 20250904024136_P2l4N SK0003 2025-09-05T12:21:56.079Z 2025-09-12T12:51:03.778Z
7763690 7763690 20250904024102_4fmti SK0003 2025-09-05T12:21:55.449Z 2025-09-12T12:51:03.616Z
7763529 7763529 20250904023332_w3UWj SK0003 2025-09-05T12:21:26.018Z 2025-09-12T12:50:51.079Z
7763525 7763525 20250904023244_wRZVa SK0003 2025-09-05T12:21:24.509Z 2025-09-12T12:50:50.922Z
7762925 7762925 20250904015925_plEmu SK0003 2025-09-05T12:20:07.802Z 2025-09-12T12:50:26.693Z
7762618 7762618 20250904014256_f2ZiJ SK0003 2025-09-05T12:19:21.796Z 2025-09-12T12:50:09.937Z
7762503 7762503 20250904013639_ausiB SK0003 2025-09-05T12:18:52.528Z 2025-09-12T12:49:59.200Z
7762271 7762271 20250904012211_JWiYH SK0003 2025-09-05T12:18:13.995Z 2025-09-12T12:49:52.513Z
7762229 7762229 20250904012058_pdrSl SK0003 2025-09-05T12:18:06.856Z 2025-09-12T12:49:50.071Z
7762013 7762013 20250904010900_7Rq5R SK0003 2025-09-05T12:17:41.661Z 2025-09-12T12:49:35.257Z
7761983 7761983 20250904010720_3nzT2 SK0003 2025-09-05T12:17:28.777Z 2025-09-12T12:49:32.954Z
7761867 7761867 20250904010044_D2Rhl SK0003 2025-09-05T12:17:12.099Z 2025-09-12T12:49:30.395Z
7761809 7761809 20250904005802_RvoLN SK0003 2025-09-05T12:17:05.063Z 2025-09-12T12:49:26.387Z
7761225 7761225 20250904002245_dEtuV SK0003 2025-09-05T12:15:26.093Z 2025-09-12T12:49:19.052Z
7761100 7761100 20250904001611_840oQ SK0003 2025-09-05T12:15:07.451Z 2025-09-12T12:49:17.690Z
7761085 7761085 20250904001522_KMEkg SK0003 2025-09-05T12:15:05.051Z 2025-09-12T12:49:17.507Z
7760716 7760716 20250903235546_jP6L1 SK0003 2025-09-05T12:13:59.445Z 2025-09-12T12:49:13.793Z
7760699 7760699 20250903235238_FYPGd SK0003 2025-09-05T12:13:54.918Z 2025-09-12T12:49:13.581Z
7760661 7760661 20250903235050_By6KR SK0003 2025-09-05T12:13:50.265Z 2025-09-12T12:49:13.245Z
7760584 7760584 20250903234656_J3O6G SK0003 2025-09-05T12:13:39.500Z 2025-09-12T12:49:12.440Z
7760515 7760515 20250903234047_Nd8Mm SK0003 2025-09-05T12:13:25.767Z 2025-09-12T12:49:11.760Z
7760240 7760240 20250903232128_wAmo6 SK0003 2025-09-05T12:12:35.723Z 2025-09-12T12:49:08.717Z
7759989 7759989 20250903230117_cVPxt SK0003 2025-09-05T12:11:39.715Z 2025-09-12T12:49:05.471Z
7759964 7759964 20250903225903_Pvyi5 SK0003 2025-09-05T12:11:34.927Z 2025-09-12T12:49:05.140Z
7759848 7759848 20250903224810_akQHD SK0003 2025-09-05T12:11:10.444Z 2025-09-12T12:49:03.674Z
7759639 7759639 20250903222611_VxOqI SK0003 2025-09-05T12:10:29.548Z 2025-09-12T12:49:01.031Z
7759328 7759328 20250903214809_wZxea SK0003 2025-09-05T12:09:23.077Z 2025-09-12T12:48:54.267Z
7759289 7759289 20250903214443_F9xvA SK0003 2025-09-05T12:09:19.015Z 2025-09-12T12:48:53.841Z
7758972 7758972 20250903210341_A6s2L SK0003 2025-09-05T12:08:10.881Z 2025-09-12T12:48:37.848Z
7758837 7758837 20250903204805_qw82N SK0003 2025-09-05T12:07:35.998Z 2025-09-12T12:48:32.726Z
7758816 7758816 20250903204627_d72dT SK0003 2025-09-05T12:07:32.591Z 2025-09-12T12:48:28.012Z
7758734 7758734 20250903203624_p2XMd SK0003 2025-09-05T12:07:11.020Z 2025-09-12T12:48:24.956Z
7758430 7758430 20250903194503_t6beM SK0003 2025-09-05T12:05:53.541Z 2025-09-12T12:47:56.030Z
7758423 7758423 20250903194447_BjDzP SK0003 2025-09-05T12:05:52.560Z 2025-09-12T12:47:53.556Z
7758298 7758298 20250903191848_rJVXF SK0003 2025-09-05T12:05:15.951Z 2025-09-12T12:47:45.619Z
7758282 7758282 20250903191229_Wm0tZ SK0003 2025-09-05T12:05:12.551Z 2025-09-12T12:47:44.866Z
7758257 7758257 20250903190221_JRuaZ SK0003 2025-09-05T12:05:06.551Z 2025-09-12T12:47:43.775Z
7758249 7758249 20250903190138_T5XaD SK0003 2025-09-05T12:05:04.993Z 2025-09-12T12:47:43.619Z
7754034 7754034 20250902012918_6hLYv SK0003 2025-09-04T12:27:31.473Z 2025-09-10T12:46:55.367Z
7742991 7742991 20250902025343_m3ekt SK0003 2025-09-03T12:23:17.508Z 2025-09-10T12:47:32.021Z
7742970 7742970 20250902025206_JGelc SK0003 2025-09-03T12:23:15.681Z 2025-09-10T12:47:31.483Z
7742808 7742808 20250902024526_EmmsQ SK0003 2025-09-03T12:22:52.744Z 2025-09-10T12:47:27.783Z
7742585 7742585 20250902023426_PXbAC SK0003 2025-09-03T12:22:33.984Z 2025-09-10T12:47:24.859Z
7742551 7742551 20250902023044_PrcCj SK0003 2025-09-03T12:22:31.303Z 2025-09-10T12:47:23.818Z
7742512 7742512 20250902022732_AiXtX SK0003 2025-09-03T12:22:28.207Z 2025-09-10T12:47:22.791Z
7742304 7742304 20250902021244_OxW8K SK0003 2025-09-03T12:21:53.383Z 2025-09-10T12:47:13.437Z
7741937 7741937 20250902015238_eEe2o SK0003 2025-09-03T12:21:07.191Z 2025-09-10T12:47:04.186Z
7741826 7741826 20250902014824_XGBqM SK0003 2025-09-03T12:20:59.849Z 2025-09-10T12:47:02.404Z
7741717 7741717 20250902014324_9fjFI SK0003 2025-09-03T12:20:51.992Z 2025-09-10T12:47:01.613Z
7741483 7741483 20250902012918_Hz2fR SK0003 2025-09-03T12:20:19.851Z 2025-09-03T12:37:10.263Z
7741379 7741379 20250902012229_1PP1T SK0003 2025-09-03T12:20:08.985Z 2025-09-10T12:46:54.123Z
7741051 7741051 20250902010408_GJZ3b SK0003 2025-09-03T12:19:27.025Z 2025-09-10T12:46:45.153Z
7741046 7741046 20250902010401_cFDbE SK0003 2025-09-03T12:19:26.567Z 2025-09-10T12:46:44.828Z
7740851 7740851 20250902005021_EGMkM SK0003 2025-09-03T12:19:09.219Z 2025-09-10T12:46:39.597Z
7740809 7740809 20250902004701_bwUxT SK0003 2025-09-03T12:18:54.740Z 2025-09-10T12:46:38.955Z
7740615 7740615 20250902003233_vpey6 SK0003 2025-09-03T12:18:31.193Z 2025-09-10T12:46:34.965Z
7740574 7740574 20250902002923_habaA SK0003 2025-09-03T12:18:27.934Z 2025-09-10T12:46:34.669Z
7740314 7740314 20250902000812_Xl4o1 SK0003 2025-09-03T12:17:47.748Z 2025-09-10T12:46:25.511Z
7740298 7740298 20250902000631_0S3EK SK0003 2025-09-03T12:17:46.226Z 2025-09-10T12:46:25.417Z
7740142 7740142 20250901235737_F4yUf SK0003 2025-09-03T12:17:23.088Z 2025-09-10T12:46:24.055Z
7739805 7739805 20250901233939_9erJq SK0003 2025-09-03T12:16:39.641Z 2025-09-10T12:46:21.285Z
7739585 7739585 20250901232524_Mwddy SK0003 2025-09-03T12:16:02.816Z 2025-09-10T12:46:15.756Z
7739503 7739503 20250901232055_Am8Uh SK0003 2025-09-03T12:15:49.618Z 2025-09-10T12:46:12.672Z
7739500 7739500 20250901232050_aEBIi SK0003 2025-09-03T12:15:49.335Z 2025-09-10T12:46:12.357Z
7739024 7739024 20250901224431_X2XOX SK0003 2025-09-03T12:14:33.144Z 2025-09-10T12:46:03.335Z
7738485 7738485 20250901215350_sE6CP SK0003 2025-09-03T12:12:39.571Z 2025-09-10T12:45:48.776Z
7738482 7738482 20250901215346_wJ7f2 SK0003 2025-09-03T12:12:39.237Z 2025-09-10T12:45:48.755Z
7737960 7737960 20250901210335_d3vd8 SK0003 2025-09-03T12:11:08.829Z 2025-09-10T12:45:35.653Z
7737926 7737926 20250901210233_HNYpG SK0003 2025-09-03T12:11:05.061Z 2025-09-10T12:45:35.408Z
7737559 7737559 20250901201501_YSVmM SK0003 2025-09-03T12:09:47.575Z 2025-09-10T12:45:27.225Z
7737418 7737418 20250901195838_aGIbz SK0003 2025-09-03T12:09:12.719Z 2025-09-10T12:45:24.547Z
7737242 7737242 20250901192512_wOBb2 SK0003 2025-09-03T12:08:34.507Z 2025-09-10T12:45:18.189Z
7737206 7737206 20250901192129_D024q SK0003 2025-09-03T12:08:29.146Z 2025-09-10T12:45:17.467Z
7737183 7737183 20250901191314_Y7djg SK0003 2025-09-03T12:08:17.204Z 2025-09-10T12:45:16.673Z

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