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

555 rows where station_code = "UK004L" 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
8535408 8535408 20251120020212_txz5O UK004L 2025-11-21T14:15:58.885Z 2025-11-28T14:56:39.475Z
8535294 8535294 20251120014653_3nfqS UK004L 2025-11-21T14:15:47.374Z 2025-11-28T14:56:28.820Z
8534911 8534911 20251120004409_C3Awk UK004L 2025-11-21T14:14:50.549Z 2025-11-28T14:56:08.417Z
8534704 8534704 20251120000659_BhkPT UK004L 2025-11-21T14:14:24.277Z 2025-11-28T14:55:57.934Z
8534426 8534426 20251119231859_qMLR2 UK004L 2025-11-21T14:13:50.881Z 2025-11-28T14:55:46.430Z
8320818 8320818 20251030031407_2GtGc UK004L 2025-11-01T12:26:53.045Z 2025-11-07T15:14:48.379Z
8319149 8319149 20251030015229_76A7d UK004L 2025-11-01T12:24:09.474Z 2025-11-07T15:13:35.952Z
8314075 8314075 20251030003702_Z1JkV UK004L 2025-10-31T12:38:17.726Z 2025-11-07T15:13:17.004Z
8313547 8313547 20251030001152_4bucm UK004L 2025-10-31T12:38:03.641Z 2025-11-07T15:12:41.150Z
8313539 8313539 20251030001137_LPbfA UK004L 2025-10-31T12:38:03.521Z 2025-11-07T15:12:40.865Z
8313510 8313510 20251030001002_hVOIo UK004L 2025-10-31T12:38:02.404Z 2025-11-07T15:12:39.905Z
8259813 8259813 20251026030143_3bjhy UK004L 2025-10-28T12:33:01.619Z 2025-11-03T15:16:27.520Z
8256825 8256825 20251026013906_XG4ds UK004L 2025-10-28T12:30:03.112Z 2025-11-03T15:16:16.958Z
8255254 8255254 20251026005038_nHYWr UK004L 2025-10-28T12:28:13.181Z 2025-11-03T15:16:09.932Z
8255029 8255029 20251026004306_oHKhW UK004L 2025-10-28T12:27:50.370Z 2025-11-03T15:16:09.561Z
8254868 8254868 20251026003506_X4yB9 UK004L 2025-10-28T12:27:39.724Z 2025-11-03T15:16:09.125Z
8235492 8235492 20251026003345_O9LZP UK004L 2025-10-27T12:17:57.100Z 2025-11-03T15:16:08.994Z
7796378 7796378 20250909034521_Lq32E UK004L 2025-09-10T12:09:34.337Z 2025-09-17T12:56:53.212Z
7796352 7796352 20250909034235_ZlvXl UK004L 2025-09-10T12:09:31.962Z 2025-09-17T12:56:52.832Z
7796316 7796316 20250909033425_3v2Ax UK004L 2025-09-10T12:09:28.094Z 2025-09-17T12:56:52.577Z
7764543 7764543 20250904035740_eeIAc UK004L 2025-09-05T12:23:44.068Z 2025-09-12T12:51:35.101Z
7764476 7764476 20250904034940_YoGsR UK004L 2025-09-05T12:23:36.717Z 2025-09-12T12:51:34.374Z
7764172 7764172 20250904031217_QvEXs UK004L 2025-09-05T12:22:55.582Z 2025-09-12T12:51:24.865Z
7743720 7743720 20250902034441_6hRik UK004L 2025-09-03T12:24:15.343Z 2025-09-10T12:47:36.593Z
7743640 7743640 20250902033924_VuBq1 UK004L 2025-09-03T12:24:11.250Z 2025-09-10T12:47:36.157Z
7737855 7737855 20250901205536_dABtb UK004L 2025-09-03T12:10:45.449Z 2025-09-10T12:45:34.452Z
7731328 7731328 20250901033059_xaP3u UK004L 2025-09-02T12:28:45.527Z 2025-09-09T12:48:48.411Z
7731223 7731223 20250901032356_kqMWZ UK004L 2025-09-02T12:28:38.770Z 2025-09-09T12:48:48.090Z
7707265 7707265 20250830031802_yL8BR UK004L 2025-08-31T12:29:26.375Z 2025-09-07T12:58:53.781Z
7703200 7703200 20250829231735_CP4hh UK004L 2025-08-31T12:21:59.800Z 2025-09-07T12:58:10.578Z
7701177 7701177 20250829201531_fbcGO UK004L 2025-08-31T12:16:57.583Z 2025-09-07T12:57:42.481Z
7701170 7701170 20250829201530_hgh2j UK004L 2025-08-31T12:16:57.305Z 2025-09-07T12:57:42.469Z
7610355 7610355 20250821223148_6KmqL UK004L 2025-08-23T12:20:44.847Z 2025-08-30T12:59:20.897Z
7562895 7562895 20250816231733_2Mfmz UK004L 2025-08-19T13:02:31.805Z 2025-08-24T12:49:01.041Z
7561100 7561100 20250816215216_vGqos UK004L 2025-08-19T12:58:52.792Z 2025-08-24T12:48:51.605Z
7560994 7560994 20250816214722_bYV0k UK004L 2025-08-19T12:58:45.657Z 2025-08-24T12:48:50.861Z
7536893 7536893 20250814224613_7ofI2 UK004L 2025-08-18T12:24:10.195Z 2025-08-23T12:48:16.431Z
7529198 7529198 20250814214803_ySJUH UK004L 2025-08-17T12:49:49.881Z 2025-08-22T12:47:35.333Z
7528602 7528602 20250814212856_Ma51W UK004L 2025-08-17T12:49:34.112Z 2025-08-22T12:47:34.562Z
7516548 7516548 20250815002900_SlZrd UK004L 2025-08-17T12:12:04.106Z 2025-08-23T12:48:32.624Z
7516105 7516105 20250815001357_R3jrg UK004L 2025-08-17T12:10:55.099Z 2025-08-23T12:48:30.575Z
7514952 7514952 20250814233114_1Wrxi UK004L 2025-08-17T12:08:12.143Z 2025-08-23T12:48:26.950Z
7514531 7514531 20250814231734_q8pZ9 UK004L 2025-08-17T12:07:12.108Z 2025-08-23T12:48:26.376Z
7514391 7514391 20250814231213_AIfc2 UK004L 2025-08-17T12:06:58.213Z 2025-08-23T12:48:26.263Z
7514334 7514334 20250814231047_Tlf0J UK004L 2025-08-17T12:06:55.127Z 2025-08-23T12:48:26.223Z
7514192 7514192 20250814230547_o2Bgk UK004L 2025-08-17T12:06:28.614Z 2025-08-23T12:48:24.479Z
7514141 7514141 20250814230412_KpXY8 UK004L 2025-08-17T12:06:23.993Z 2025-08-23T12:48:24.261Z
7514081 7514081 20250814230233_tCgAq UK004L 2025-08-17T12:06:09.168Z 2025-08-23T12:48:24.192Z
7513716 7513716 20250814225212_IMyOe UK004L 2025-08-17T12:05:13.079Z 2025-08-23T12:48:16.629Z
7513413 7513413 20250814224227_oTmBZ UK004L 2025-08-17T12:04:25.202Z 2025-08-23T12:48:16.286Z
7513119 7513119 20250814223223_sw0nC UK004L 2025-08-17T12:03:38.374Z 2025-08-23T12:48:13.800Z
7281708 7281708 20250730223134_0Zy5g UK004L 2025-08-01T12:08:50.065Z 2025-08-08T12:56:20.791Z
7097502 7097502 20250716222506_QIGYs UK004L 2025-07-18T12:06:23.282Z 2025-07-25T12:02:59.075Z
7067669 7067669 20250710002435_3Xs5q UK004L 2025-07-11T12:13:31.557Z 2025-07-18T12:38:10.067Z
7063667 7063667 20250709005210_3yf6T UK004L 2025-07-10T12:09:50.349Z 2025-07-17T12:41:38.123Z
7034556 7034556 20250703225931_n5rr8 UK004L 2025-07-05T12:21:54.966Z 2025-07-12T13:01:03.436Z
7029198 7029198 20250702234707_91pgs UK004L 2025-07-04T12:15:00.246Z 2025-07-10T12:26:02.043Z
7028896 7028896 20250702233132_BPquJ UK004L 2025-07-04T12:14:24.663Z 2025-07-10T12:26:01.375Z
7025446 7025446 20250703004321_4xoXh UK004L 2025-07-04T12:01:57.480Z 2025-07-12T12:55:51.541Z
7002653 7002653 20250630004333_vnZef UK004L 2025-07-01T12:08:50.553Z 2025-07-08T12:50:48.596Z
7001850 7001850 20250629235517_OBTY6 UK004L 2025-07-01T12:06:10.127Z 2025-07-08T12:50:06.670Z
6848035 6848035 20250601232812_7Cjg7 UK004L 2025-06-03T12:10:00.146Z 2025-06-10T12:29:01.837Z
6829687 6829687 20250530012824_ximJK UK004L 2025-05-31T12:19:04.790Z 2025-06-07T12:36:39.163Z
6829622 6829622 20250530011341_zIm2D UK004L 2025-05-31T12:18:56.823Z 2025-06-07T12:36:38.018Z
6829564 6829564 20250530010155_Ep2WT UK004L 2025-05-31T12:18:48.854Z 2025-06-07T12:36:35.913Z
6829508 6829508 20250530005656_VNcYS UK004L 2025-05-31T12:18:38.979Z 2025-06-07T12:36:34.304Z
6829295 6829295 20250530002903_bGh2u UK004L 2025-05-31T12:18:06.058Z 2025-06-07T12:36:31.587Z
6809770 6809770 20250526010953_BsOT3 UK004L 2025-05-27T12:17:22.594Z 2025-06-03T13:03:37.558Z
6809687 6809687 20250526010042_Lgy62 UK004L 2025-05-27T12:17:09.893Z 2025-06-03T13:03:27.686Z
6809654 6809654 20250526005843_Py2dI UK004L 2025-05-27T12:17:07.801Z 2025-06-03T13:03:26.401Z
6809544 6809544 20250526004112_Iw7GT UK004L 2025-05-27T12:16:52.916Z 2025-06-03T13:03:18.424Z
6804180 6804180 20250525020316_4aQQm UK004L 2025-05-26T12:21:44.181Z 2025-06-02T13:03:28.624Z
6786825 6786825 20250522230317_mTIqG UK004L 2025-05-24T12:19:34.882Z 2025-05-31T13:13:52.637Z
6786518 6786518 20250522214719_m6sS8 UK004L 2025-05-24T12:18:52.967Z 2025-05-31T13:13:34.384Z
6737799 6737799 20250515222407_Rk8ZO UK004L 2025-05-17T12:22:38.872Z 2025-05-23T12:37:04.096Z
6731375 6731375 20250516004647_oA8qw UK004L 2025-05-17T12:02:29.674Z 2025-05-24T12:40:01.630Z
6731305 6731305 20250516004045_41RsA UK004L 2025-05-17T12:02:21.726Z 2025-05-24T12:40:00.737Z
6699086 6699086 20250510002406_Ny3i5 UK004L 2025-05-11T12:07:08.526Z 2025-05-18T12:33:47.619Z
6698560 6698560 20250509231001_QeUJu UK004L 2025-05-11T12:05:56.083Z 2025-05-18T12:33:40.145Z
6692158 6692158 20250509015410_GYWyz UK004L 2025-05-10T12:10:57.756Z 2025-05-17T12:35:55.274Z
6692033 6692033 20250509014639_KMbYE UK004L 2025-05-10T12:10:44.185Z 2025-05-17T12:35:54.072Z
6692016 6692016 20250509014514_sXX0a UK004L 2025-05-10T12:10:43.169Z 2025-05-17T12:35:53.975Z
6647461 6647461 20250504025643_EkS4g UK004L 2025-05-05T12:15:11.080Z 2025-05-12T12:35:11.196Z
6646830 6646830 20250504015055_CK8YN UK004L 2025-05-05T12:14:13.971Z 2025-05-12T12:35:06.256Z
6646145 6646145 20250504004035_DF4pt UK004L 2025-05-05T12:13:01.271Z 2025-05-12T12:34:59.051Z
6629566 6629566 20250502012700_K4vdu UK004L 2025-05-03T12:15:36.619Z 2025-05-10T12:37:28.264Z
6629555 6629555 20250502012700_2c06o UK004L 2025-05-03T12:15:36.411Z 2025-05-10T12:37:28.250Z
6621063 6621063 20250501010212_zrZzL UK004L 2025-05-02T12:15:34.392Z 2025-05-09T12:38:17.828Z
6620898 6620898 20250501005224_dgnr2 UK004L 2025-05-02T12:15:20.479Z 2025-05-09T12:38:16.537Z
6545834 6545834 20250422030311_Dd7xv UK004L 2025-04-23T12:21:30.291Z 2025-04-30T12:41:37.064Z
6545322 6545322 20250422023418_Y9P53 UK004L 2025-04-23T12:21:20.534Z 2025-04-30T12:41:34.977Z
6544731 6544731 20250422020611_k2djg UK004L 2025-04-23T12:20:43.259Z 2025-04-30T12:41:33.094Z
6520242 6520242 20250417024637_oLHqA UK004L 2025-04-18T12:10:24.898Z 2025-04-25T12:33:44.418Z
6519932 6519932 20250417014113_qjZiK UK004L 2025-04-18T12:09:41.194Z 2025-04-25T12:33:40.790Z
6519373 6519373 20250416235642_h1tJD UK004L 2025-04-18T12:08:27.339Z 2025-04-25T12:33:33.944Z
6519263 6519263 20250416233241_wdfhF UK004L 2025-04-18T12:08:19.861Z 2025-04-25T12:33:33.587Z
6502033 6502033 20250411034007_5oX0X UK004L 2025-04-12T12:04:07.081Z 2025-04-19T12:25:05.711Z
6501518 6501518 20250411022201_xD0WJ UK004L 2025-04-12T12:02:28.048Z 2025-04-19T12:24:53.927Z
6476268 6476268 20250406024614_mgzll UK004L 2025-04-08T12:18:50.436Z 2025-04-14T12:30:15.103Z
6476134 6476134 20250406023913_kV3R1 UK004L 2025-04-08T12:18:32.968Z 2025-04-14T12:30:12.483Z

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