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

>10,000 rows count all where station_code = "USL00K" 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
8671849 8671849 20251201130657_2ji0d USL00K 2025-12-03T14:13:59.786Z 2025-12-06T14:31:22.733Z
8671714 8671714 20251201125225_RtBjA USL00K 2025-12-03T14:13:25.778Z 2025-12-06T14:31:17.216Z
8670894 8670894 20251201103949_YSgsT USL00K 2025-12-03T14:10:38.885Z 2025-12-06T14:30:28.819Z
8670842 8670842 20251201103110_IMeea USL00K 2025-12-03T14:10:31.254Z 2025-12-06T14:30:27.029Z
8670839 8670839 20251201102711_9Lk62 USL00K 2025-12-03T14:10:30.295Z 2025-12-06T14:30:26.696Z
8670830 8670830 20251201102356_IhFSc USL00K 2025-12-03T14:10:27.203Z 2025-12-06T14:30:26.152Z
8670586 8670586 20251201093325_7B2Zr USL00K 2025-12-03T14:09:24.586Z 2025-12-06T14:30:10.343Z
8670572 8670572 20251201092943_iECGk USL00K 2025-12-03T14:09:17.389Z 2025-12-06T14:30:09.901Z
8668177 8668177 20251130063110_0MxAB USL00K 2025-12-02T14:42:08.523Z 2025-12-06T14:50:25.648Z
8660503 8660503 20251130130043_6TGSS USL00K 2025-12-02T14:08:09.646Z 2025-12-06T14:37:17.850Z
8660246 8660246 20251130121222_ZOaZA USL00K 2025-12-02T14:07:01.636Z 2025-12-06T14:36:57.876Z
8660165 8660165 20251130120130_rj2GU USL00K 2025-12-02T14:06:47.118Z 2025-12-06T14:36:54.146Z
8660101 8660101 20251130115547_T3Kkh USL00K 2025-12-02T14:06:30.255Z 2025-12-06T14:36:52.740Z
8660073 8660073 20251130115226_eoyZV USL00K 2025-12-02T14:06:26.199Z 2025-12-06T14:36:52.017Z
8659847 8659847 20251130112147_JXqbv USL00K 2025-12-02T14:05:35.828Z 2025-12-06T14:36:44.435Z
8659783 8659783 20251130111501_n532O USL00K 2025-12-02T14:05:17.903Z 2025-12-06T14:36:41.953Z
8659688 8659688 20251130110502_m41bq USL00K 2025-12-02T14:04:55.149Z 2025-12-06T14:36:37.326Z
8659556 8659556 20251130104725_67ln6 USL00K 2025-12-02T14:04:27.929Z 2025-12-06T14:36:23.400Z
8659395 8659395 20251130101946_ttwZS USL00K 2025-12-02T14:03:47.970Z 2025-12-06T14:36:17.242Z
8659357 8659357 20251130101424_8JArf USL00K 2025-12-02T14:03:36.682Z 2025-12-06T14:36:15.911Z
8659257 8659257 20251130095915_lyBnJ USL00K 2025-12-02T14:03:16.429Z 2025-12-06T14:36:12.393Z
8659132 8659132 20251130093754_PW3XH USL00K 2025-12-02T14:02:42.946Z 2025-12-06T14:36:08.384Z
8659043 8659043 20251130092128_7U5ws USL00K 2025-12-02T14:02:21.248Z 2025-12-06T14:36:03.934Z
8659039 8659039 20251130092027_pTNQx USL00K 2025-12-02T14:02:19.891Z 2025-12-06T14:36:03.654Z
8658972 8658972 20251130090820_5N2fl USL00K 2025-12-02T14:01:57.361Z 2025-12-06T14:36:00.811Z
8658814 8658814 20251130081725_yXcra USL00K 2025-12-02T14:00:58.440Z 2025-12-06T14:35:42.026Z
8658758 8658758 20251130075236_efB5n USL00K 2025-12-02T14:00:39.066Z 2025-12-06T14:35:39.112Z
8648442 8648442 20251129075624_2Ddsq USL00K 2025-11-30T14:30:10.552Z 2025-12-06T14:57:43.718Z
8648347 8648347 20251129073252_VtCmN USL00K 2025-11-30T14:30:05.215Z 2025-12-06T14:57:33.007Z
8648340 8648340 20251129073218_8X7Y8 USL00K 2025-11-30T14:30:04.789Z 2025-12-06T14:57:32.386Z
8648255 8648255 20251129071353_Yb3vN USL00K 2025-11-30T14:29:59.855Z 2025-12-06T14:57:27.493Z
8648207 8648207 20251129065725_Fuzxb USL00K 2025-11-30T14:29:57.424Z 2025-12-06T14:57:19.510Z
8647779 8647779 20251129052749_UQMKS USL00K 2025-11-30T14:28:53.293Z 2025-12-06T14:56:47.513Z
8646724 8646724 20251129024321_KQQIK USL00K 2025-11-30T14:26:42.753Z 2025-12-06T14:56:24.031Z
8646552 8646552 20251129022031_lKsSN USL00K 2025-11-30T14:26:09.112Z 2025-12-06T14:56:14.358Z
8640166 8640166 20251129130122_bTkPS USL00K 2025-11-30T14:07:25.809Z 2025-12-06T14:44:00.158Z
8640111 8640111 20251129125203_eeT2T USL00K 2025-11-30T14:07:11.173Z 2025-12-06T14:43:59.190Z
8640101 8640101 20251129124958_Xe2wA USL00K 2025-11-30T14:07:08.815Z 2025-12-06T14:43:58.958Z
8640063 8640063 20251129124344_K542c USL00K 2025-11-30T14:07:00.767Z 2025-12-06T14:43:58.235Z
8639972 8639972 20251129123516_OrJyk USL00K 2025-11-30T14:06:47.160Z 2025-12-06T14:43:56.550Z
8639957 8639957 20251129122953_2l9UA USL00K 2025-11-30T14:06:44.390Z 2025-12-06T14:43:56.179Z
8639843 8639843 20251129121425_cniH6 USL00K 2025-11-30T14:06:15.235Z 2025-12-06T14:43:52.277Z
8639690 8639690 20251129114412_cO3tt USL00K 2025-11-30T14:05:46.424Z 2025-12-06T14:43:48.440Z
8639670 8639670 20251129114003_2DavB USL00K 2025-11-30T14:05:43.726Z 2025-12-06T14:43:47.753Z
8639490 8639490 20251129111215_aE9UO USL00K 2025-11-30T14:05:08.332Z 2025-12-06T14:43:42.791Z
8638875 8638875 20251129095713_2gB33 USL00K 2025-11-30T14:02:40.565Z 2025-12-06T14:43:04.599Z
8638639 8638639 20251129091652_S39c3 USL00K 2025-11-30T14:01:45.879Z 2025-12-06T14:42:57.168Z
8638598 8638598 20251129091253_Yv6Kw USL00K 2025-11-30T14:01:36.311Z 2025-12-06T14:42:56.285Z
8638393 8638393 20251129083659_P0VDH USL00K 2025-11-30T14:00:47.012Z 2025-12-06T14:42:49.968Z
8637972 8637972 20251128074444_8GFyy USL00K 2025-11-29T14:28:21.205Z 2025-12-06T15:04:06.307Z
8637940 8637940 20251128073545_j2EIg USL00K 2025-11-29T14:28:18.562Z 2025-12-06T15:04:05.907Z
8637387 8637387 20251128053509_j2by3 USL00K 2025-11-29T14:27:11.509Z 2025-12-06T15:03:59.512Z
8628543 8628543 20251128125533_0lwhP USL00K 2025-11-29T14:06:34.878Z 2025-12-06T14:51:58.992Z
8627746 8627746 20251128113439_BQB0Z USL00K 2025-11-29T14:04:26.072Z 2025-12-06T14:51:24.594Z
8627332 8627332 20251128105057_YQxfs USL00K 2025-11-29T14:03:21.146Z 2025-12-06T14:51:16.486Z
8627224 8627224 20251128103944_iW6tG USL00K 2025-11-29T14:03:06.672Z 2025-12-06T14:51:14.993Z
8626980 8626980 20251128100748_b3Fmq USL00K 2025-11-29T14:02:12.427Z 2025-12-06T14:51:10.578Z
8626832 8626832 20251128094343_2d26f USL00K 2025-11-29T14:01:36.758Z 2025-12-06T14:50:45.970Z
8626789 8626789 20251128093455_poAbR USL00K 2025-11-29T14:01:30.872Z 2025-12-06T14:50:42.283Z
8626325 8626325 20251126085509_GD5rq USL00K 2025-11-28T14:38:48.939Z 2025-12-04T15:12:15.991Z
8626143 8626143 20251126075326_Hj2uR USL00K 2025-11-28T14:37:49.604Z 2025-12-04T15:11:53.696Z
8626142 8626142 20251126075152_dYbLp USL00K 2025-11-28T14:37:48.224Z 2025-12-04T15:11:53.586Z
8625935 8625935 20251126063940_5yG48 USL00K 2025-11-28T14:37:25.694Z 2025-12-04T15:11:44.011Z
8625885 8625885 20251126061333_i026W USL00K 2025-11-28T14:37:20.334Z 2025-12-04T15:11:41.214Z
8625875 8625875 20251126060744_6pEqG USL00K 2025-11-28T14:37:19.522Z 2025-12-04T15:11:40.696Z
8625821 8625821 20251126054147_CC3GY USL00K 2025-11-28T14:37:11.572Z 2025-12-04T15:11:36.059Z
8625227 8625227 20251127084133_9Y0S2 USL00K 2025-11-28T14:26:28.017Z 2025-12-05T15:05:48.041Z
8625087 8625087 20251127075926_SMfc8 USL00K 2025-11-28T14:26:13.776Z 2025-12-05T15:05:41.790Z
8625064 8625064 20251127075352_1ovbo USL00K 2025-11-28T14:26:11.890Z 2025-12-05T15:05:41.298Z
8624784 8624784 20251127063111_3k33O USL00K 2025-11-28T14:25:29.523Z 2025-12-05T15:05:28.317Z
8624657 8624657 20251127054739_43hN5 USL00K 2025-11-28T14:25:15.903Z 2025-12-05T15:05:19.668Z
8624571 8624571 20251127052901_hiPMz USL00K 2025-11-28T14:25:09.746Z 2025-12-05T15:05:15.302Z
8624565 8624565 20251127052431_1O32H USL00K 2025-11-28T14:25:09.201Z 2025-12-05T15:05:14.078Z
8623935 8623935 20251127023036_meMjX USL00K 2025-11-28T14:23:09.475Z 2025-12-05T15:04:26.761Z
8620275 8620275 20251126120755_WgNxs USL00K 2025-11-28T14:12:12.048Z 2025-12-05T15:01:43.207Z
8619950 8619950 20251126112154_ivK4h USL00K 2025-11-28T14:11:05.098Z 2025-12-05T15:01:12.589Z
8619694 8619694 20251126104748_Yg9j0 USL00K 2025-11-28T14:10:00.105Z 2025-12-05T15:01:04.835Z
8619683 8619683 20251126104601_UMCW8 USL00K 2025-11-28T14:09:57.550Z 2025-12-05T15:01:04.544Z
8619649 8619649 20251126104108_76vWp USL00K 2025-11-28T14:09:51.732Z 2025-12-05T15:01:04.003Z
8619472 8619472 20251126101452_ZlX6Q USL00K 2025-11-28T14:09:01.246Z 2025-12-05T15:00:59.564Z
8619196 8619196 20251126092505_sA66a USL00K 2025-11-28T14:07:45.575Z 2025-12-05T15:00:52.997Z
8619134 8619134 20251126091616_3YrWe USL00K 2025-11-28T14:07:34.896Z 2025-12-05T15:00:50.118Z
8619119 8619119 20251126091403_IMxLY USL00K 2025-11-28T14:07:30.994Z 2025-12-05T15:00:49.589Z
8617778 8617778 20251127103332_8BeHR USL00K 2025-11-28T14:02:22.766Z 2025-12-06T14:58:23.381Z
8617493 8617493 20251127094445_hsnon USL00K 2025-11-28T14:01:00.391Z 2025-12-06T14:58:07.887Z
8617398 8617398 20251127092006_MxsL3 USL00K 2025-11-28T14:00:43.424Z 2025-12-06T14:57:58.314Z
8604233 8604233 20251125090819_B9eKl USL00K 2025-11-26T14:28:43.732Z 2025-12-02T15:09:40.423Z
8604200 8604200 20251125085811_wo0oJ USL00K 2025-11-26T14:28:40.667Z 2025-12-02T15:09:40.176Z
8603935 8603935 20251125072619_1ZgdZ USL00K 2025-11-26T14:28:24.819Z 2025-12-02T15:09:38.516Z
8603624 8603624 20251125062011_WTc3r USL00K 2025-11-26T14:27:37.575Z 2025-12-02T15:09:36.537Z
8602236 8602236 20251125044504_0VEEr USL00K 2025-11-26T14:25:28.209Z 2025-12-02T15:09:30.127Z
8601984 8601984 20251125043054_NvsTt USL00K 2025-11-26T14:25:15.228Z 2025-12-02T15:09:29.050Z
8601972 8601972 20251125042914_z4cjq USL00K 2025-11-26T14:25:14.632Z 2025-12-02T15:09:29.026Z
8601611 8601611 20251125040308_X8olE USL00K 2025-11-26T14:24:31.397Z 2025-12-02T15:09:16.675Z
8600837 8600837 20251125031907_MJ9V6 USL00K 2025-11-26T14:23:01.733Z 2025-12-02T15:08:51.233Z
8600455 8600455 20251125030106_dY2EE USL00K 2025-11-26T14:22:42.293Z 2025-12-02T15:08:45.530Z
8600095 8600095 20251125024320_0Xicv USL00K 2025-11-26T14:22:02.572Z 2025-12-02T15:08:34.598Z
8599792 8599792 20251125022337_ZuDjp USL00K 2025-11-26T14:21:29.534Z 2025-12-02T15:08:32.133Z
8599617 8599617 20251125021245_gyZ7C USL00K 2025-11-26T14:21:19.659Z 2025-12-02T15:08:30.601Z
8599107 8599107 20251125014747_aSoDT USL00K 2025-11-26T14:20:32.695Z 2025-12-02T15:08:20.072Z

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