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,184 rows where station_code = "USL00X" 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
6949839 6949839 20250622083354_i2bNR USL00X 2025-06-23T12:28:35.016Z 2025-06-30T12:36:00.098Z
6923592 6923592 20250620104933_E5EP2 USL00X 2025-06-21T12:00:32.139Z 2025-06-29T12:36:08.939Z
6916834 6916834 20250619091938_27uwA USL00X 2025-06-20T12:00:11.705Z 2025-06-28T12:40:06.871Z
6916375 6916375 20250618064554_ainCk USL00X 2025-06-19T12:19:28.684Z 2025-06-26T12:36:48.471Z
6916290 6916290 20250618062637_SsMXP USL00X 2025-06-19T12:19:19.846Z 2025-06-26T12:36:47.700Z
6911843 6911843 20250618082520_EhA82 USL00X 2025-06-19T12:00:25.881Z 2025-06-27T12:39:11.379Z
6905034 6905034 20250617102435_QseOv USL00X 2025-06-18T12:04:46.932Z 2025-06-26T12:36:23.289Z
6889465 6889465 20250614091635_QAXli USL00X 2025-06-15T12:03:21.500Z 2025-06-23T13:00:15.536Z
6889461 6889461 20250614091426_uDikK USL00X 2025-06-15T12:03:19.812Z 2025-06-23T13:00:15.450Z
6881963 6881963 20250611090736_pi4rl USL00X 2025-06-12T12:02:44.145Z 2025-06-20T12:53:12.055Z
6874180 6874180 20250608082724_UX5AI USL00X 2025-06-09T12:04:20.898Z 2025-06-16T12:25:35.644Z
6870324 6870324 20250607093812_brnIe USL00X 2025-06-08T12:06:58.648Z 2025-06-15T12:27:24.092Z
6867002 6867002 20250606110920_yya42 USL00X 2025-06-07T12:08:00.823Z 2025-06-14T12:29:11.696Z
6819805 6819805 20250528095749_6GA54 USL00X 2025-05-29T12:18:04.189Z 2025-06-05T12:55:50.487Z
6819748 6819748 20250528092507_kC2tc USL00X 2025-05-29T12:17:56.916Z 2025-06-05T12:55:47.618Z
6819627 6819627 20250528081338_7ACfi USL00X 2025-05-29T12:17:31.842Z 2025-06-05T12:55:43.408Z
6819621 6819621 20250528080549_hqNGr USL00X 2025-05-29T12:17:29.743Z 2025-06-05T12:55:43.160Z
6815079 6815079 20250527080022_x4r1o USL00X 2025-05-28T12:19:35.473Z 2025-06-04T13:04:07.387Z
6805265 6805265 20250526103959_zECRa USL00X 2025-05-27T12:01:59.743Z 2025-06-04T12:58:06.544Z
6797546 6797546 20250525075725_8y3G9 USL00X 2025-05-26T12:00:20.347Z 2025-06-03T12:59:54.356Z
6791125 6791125 20250524110435_w7kjA USL00X 2025-05-25T12:06:53.466Z 2025-06-02T12:58:41.822Z
6789711 6789711 20250524082350_KH4Br USL00X 2025-05-25T12:02:39.591Z 2025-06-02T12:57:43.239Z
6783250 6783250 20250523103741_AdTgs USL00X 2025-05-24T12:05:46.345Z 2025-06-01T12:36:20.189Z
6782468 6782468 20250523085752_Hufa5 USL00X 2025-05-24T12:03:44.872Z 2025-06-01T12:36:13.664Z
6771564 6771564 20250522063310_qpZDC USL00X 2025-05-23T12:00:59.949Z 2025-05-31T13:09:12.115Z
6764320 6764320 20250521093252_Ruh7l USL00X 2025-05-22T12:04:34.708Z 2025-05-30T13:03:20.214Z
6764142 6764142 20250521090435_KtB1N USL00X 2025-05-22T12:03:59.984Z 2025-05-30T13:03:15.825Z
6763840 6763840 20250521081610_8S8S7 USL00X 2025-05-22T12:03:10.143Z 2025-05-30T13:03:03.102Z
6763594 6763594 20250521072516_6r481 USL00X 2025-05-22T12:02:25.264Z 2025-05-30T13:02:43.151Z
6755841 6755841 20250520093601_9yrll USL00X 2025-05-21T12:05:22.435Z 2025-05-29T13:03:02.843Z
6755760 6755760 20250520091837_uanXf USL00X 2025-05-21T12:05:05.946Z 2025-05-29T13:03:00.280Z
6743179 6743179 20250518100136_WTxKf USL00X 2025-05-19T12:03:38.957Z 2025-05-27T13:16:34.077Z
6743175 6743175 20250518100013_l5a7G USL00X 2025-05-19T12:03:37.971Z 2025-05-27T13:16:33.854Z
6743080 6743080 20250518090947_zc03Y USL00X 2025-05-19T12:03:09.655Z 2025-05-27T13:16:30.364Z
6733840 6733840 20250516103927_o0ZRh USL00X 2025-05-17T12:09:44.279Z 2025-05-24T12:40:25.711Z
6733718 6733718 20250516102310_Rupxq USL00X 2025-05-17T12:09:31.330Z 2025-05-24T12:40:24.962Z
6733170 6733170 20250516084347_Y5W83 USL00X 2025-05-17T12:07:57.910Z 2025-05-24T12:40:20.116Z
6732335 6732335 20250516042422_oF42r USL00X 2025-05-17T12:05:29.943Z 2025-05-24T12:40:11.733Z
6726262 6726262 20250515111619_b2XKh USL00X 2025-05-16T12:09:01.446Z 2025-05-23T12:36:36.709Z
6726177 6726177 20250515110609_e1DZu USL00X 2025-05-16T12:08:50.743Z 2025-05-23T12:36:36.197Z
6725992 6725992 20250515103546_kY0eL USL00X 2025-05-16T12:08:18.441Z 2025-05-23T12:36:32.933Z
6725424 6725424 20250515072354_oE2gJ USL00X 2025-05-16T12:06:46.812Z 2025-05-23T12:36:27.610Z
6708592 6708592 20250511103901_TBx05 USL00X 2025-05-12T12:10:45.957Z 2025-05-19T12:37:18.746Z
6708153 6708153 20250511084322_ns1XV USL00X 2025-05-12T12:09:48.137Z 2025-05-19T12:37:04.379Z
6701801 6701801 20250510104407_UUEdv USL00X 2025-05-11T12:12:55.481Z 2025-05-18T12:34:40.733Z
6701726 6701726 20250510103429_jUBcm USL00X 2025-05-11T12:12:48.483Z 2025-05-18T12:34:39.396Z
6701722 6701722 20250510103344_pcqJx USL00X 2025-05-11T12:12:48.173Z 2025-05-18T12:34:39.334Z
6701552 6701552 20250510100158_NMfzd USL00X 2025-05-11T12:12:28.360Z 2025-05-18T12:34:36.188Z
6701334 6701334 20250510090747_L3SFq USL00X 2025-05-11T12:12:02.831Z 2025-05-18T12:34:31.581Z
6693831 6693831 20250509100428_btGUF USL00X 2025-05-10T12:14:49.742Z 2025-05-17T12:36:23.138Z
6693801 6693801 20250509100206_A7prX USL00X 2025-05-10T12:14:40.804Z 2025-05-17T12:36:22.885Z
6687592 6687592 20250508092636_LJy2P USL00X 2025-05-09T12:14:40.973Z 2025-05-16T12:35:20.112Z
6687443 6687443 20250508082535_TdCqL USL00X 2025-05-09T12:14:16.402Z 2025-05-16T12:35:17.301Z
6680675 6680675 20250507110948_BJqeS USL00X 2025-05-08T12:19:41.056Z 2025-05-15T12:38:18.248Z
6680592 6680592 20250507110026_sUZDb USL00X 2025-05-08T12:19:37.766Z 2025-05-15T12:38:17.483Z
6680586 6680586 20250507105942_v3L33 USL00X 2025-05-08T12:19:37.633Z 2025-05-15T12:38:17.377Z
6680433 6680433 20250507102802_LLrEK USL00X 2025-05-08T12:19:28.678Z 2025-05-15T12:38:14.161Z
6680226 6680226 20250507092652_eHaFp USL00X 2025-05-08T12:18:54.873Z 2025-05-15T12:38:07.881Z
6679929 6679929 20250507071930_twKGp USL00X 2025-05-08T12:18:16.793Z 2025-05-15T12:37:59.431Z
6670999 6670999 20250506094607_tlVsr USL00X 2025-05-07T12:19:44.560Z 2025-05-14T12:41:51.282Z
6660451 6660451 20250505072259_ZLuTs USL00X 2025-05-06T12:20:11.013Z 2025-05-13T12:38:56.688Z
6648870 6648870 20250504103403_zabXt USL00X 2025-05-05T12:18:10.488Z 2025-05-12T12:35:25.912Z
6640516 6640516 20250503100411_WWI45 USL00X 2025-05-04T12:20:29.949Z 2025-05-11T12:37:31.047Z
6640141 6640141 20250503090317_glotH USL00X 2025-05-04T12:19:48.904Z 2025-05-11T12:37:28.269Z
6631650 6631650 20250502103720_nTvKb USL00X 2025-05-03T12:19:49.262Z 2025-05-10T12:37:40.052Z
6631334 6631334 20250502095223_Gmp3q USL00X 2025-05-03T12:19:11.383Z 2025-05-10T12:37:38.904Z
6630992 6630992 20250502082919_UOfEj USL00X 2025-05-03T12:18:27.904Z 2025-05-10T12:37:37.294Z
6624015 6624015 20250501111821_BjUcD USL00X 2025-05-02T12:20:36.024Z 2025-05-09T12:38:49.697Z
6623922 6623922 20250501104505_Kmgso USL00X 2025-05-02T12:20:29.816Z 2025-05-09T12:38:47.891Z
6623593 6623593 20250501083849_SxyHn USL00X 2025-05-02T12:19:42.349Z 2025-05-09T12:38:42.072Z
6623308 6623308 20250501064709_TRkzY USL00X 2025-05-02T12:19:22.873Z 2025-05-09T12:38:38.950Z
6615775 6615775 20250430100211_Cqf69 USL00X 2025-05-01T12:21:11.590Z 2025-05-08T12:35:22.257Z
6607432 6607432 20250430114653_F6rBy USL00X 2025-05-01T12:00:48.111Z 2025-05-09T12:37:20.104Z
6607430 6607430 20250430114448_wEwSN USL00X 2025-05-01T12:00:47.740Z 2025-05-09T12:37:19.968Z
6606999 6606999 20250429100550_Fi6gI USL00X 2025-04-30T12:24:06.086Z 2025-05-07T12:35:19.702Z
6606767 6606767 20250429090251_zXsei USL00X 2025-04-30T12:23:49.878Z 2025-05-07T12:35:18.204Z
6606692 6606692 20250429084152_XnAOI USL00X 2025-04-30T12:23:43.307Z 2025-05-07T12:35:17.911Z
6606509 6606509 20250429074936_Cn33L USL00X 2025-04-30T12:23:31.954Z 2025-05-07T12:35:17.136Z
6606177 6606177 20250429060258_c0i3c USL00X 2025-04-30T12:22:54.566Z 2025-05-07T12:35:15.344Z
6597024 6597024 20250428065328_CiBAP USL00X 2025-04-29T12:23:33.238Z 2025-05-06T12:37:02.218Z
6587468 6587468 20250428103804_dtVjB USL00X 2025-04-29T12:01:07.582Z 2025-05-07T12:34:26.375Z
6587315 6587315 20250428095830_oVpTs USL00X 2025-04-29T12:00:40.538Z 2025-05-07T12:34:25.122Z
6587211 6587211 20250428093700_S9z85 USL00X 2025-04-29T12:00:20.395Z 2025-05-07T12:34:22.863Z
6586843 6586843 20250427073113_ohRtF USL00X 2025-04-28T12:24:45.771Z 2025-05-05T12:31:35.576Z
6586768 6586768 20250427070823_B3s5U USL00X 2025-04-28T12:24:31.468Z 2025-05-05T12:31:35.326Z
6579363 6579363 20250426063405_qWpUH USL00X 2025-04-27T12:22:54.708Z 2025-05-04T12:36:48.057Z
6579271 6579271 20250426052515_DkJCw USL00X 2025-04-27T12:22:44.385Z 2025-05-04T12:36:47.234Z
6571068 6571068 20250426081511_6onJg USL00X 2025-04-27T12:00:13.818Z 2025-05-05T12:31:05.817Z
6563007 6563007 20250425110945_bLhHo USL00X 2025-04-26T12:04:26.239Z 2025-05-04T12:36:12.704Z
6562994 6562994 20250425110638_5MTru USL00X 2025-04-26T12:04:24.653Z 2025-05-04T12:36:12.541Z
6562727 6562727 20250425102249_l2KAO USL00X 2025-04-26T12:03:26.819Z 2025-05-04T12:36:09.228Z
6562377 6562377 20250425092149_UkyHc USL00X 2025-04-26T12:02:17.024Z 2025-05-04T12:36:05.804Z
6561843 6561843 20250425074719_CuAQG USL00X 2025-04-26T12:00:25.262Z 2025-05-04T12:36:00.970Z
6561590 6561590 20250424060640_6AC16 USL00X 2025-04-25T12:22:12.909Z 2025-05-02T12:35:05.347Z
6561587 6561587 20250424060256_Z06ho USL00X 2025-04-25T12:22:12.770Z 2025-05-02T12:35:05.343Z
6561390 6561390 20250424044306_6syhj USL00X 2025-04-25T12:21:49.918Z 2025-05-02T12:35:04.008Z
6555026 6555026 20250424113627_EVpuT USL00X 2025-04-25T12:05:23.567Z 2025-05-03T12:32:19.387Z
6554808 6554808 20250424105842_NXcEZ USL00X 2025-04-25T12:04:47.966Z 2025-05-03T12:32:18.209Z
6554765 6554765 20250424104958_m62lM USL00X 2025-04-25T12:04:39.011Z 2025-05-03T12:32:18.051Z
6553329 6553329 20250423055605_Tk5zq USL00X 2025-04-24T12:22:21.839Z 2025-05-01T12:38:49.712Z

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