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

3,814 rows where station_code = "US001U" 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
9609935 9609935 20260405111804_uEO83 US001U 2026-04-06T12:04:50.818Z 2026-04-06T12:04:50.818Z
9609826 9609826 20260405102331_nF7gy US001U 2026-04-06T12:04:09.709Z 2026-04-06T12:04:09.709Z
9609340 9609340 20260405050101_GF948 US001U 2026-04-06T12:01:19.413Z 2026-04-06T12:01:19.413Z
9593436 9593436 20260329104203_pRJ4K US001U 2026-03-30T12:03:57.755Z 2026-04-06T12:35:18.767Z
9590509 9590509 20260328094639_kLyCe US001U 2026-03-29T12:02:50.008Z 2026-04-06T12:38:13.659Z
9590507 9590507 20260328094243_7tT2b US001U 2026-03-29T12:02:49.713Z 2026-04-06T12:38:13.537Z
9590436 9590436 20260328091321_bN9zO US001U 2026-03-29T12:02:39.255Z 2026-04-06T12:38:09.727Z
9590402 9590402 20260328085518_Cbuwe US001U 2026-03-29T12:02:34.516Z 2026-04-06T12:38:06.128Z
9590327 9590327 20260328081602_LYe2K US001U 2026-03-29T12:02:25.582Z 2026-04-06T12:38:01.473Z
9590284 9590284 20260328080232_Mm0I9 US001U 2026-03-29T12:02:21.996Z 2026-04-06T12:37:59.651Z
9590122 9590122 20260328063838_mt2nd US001U 2026-03-29T12:02:02.822Z 2026-04-06T12:37:51.754Z
9589666 9589666 20260328035759_TuRBv US001U 2026-03-29T12:01:33.146Z 2026-04-06T12:37:31.160Z
9589243 9589243 20260328030107_yrJx7 US001U 2026-03-29T12:00:58.735Z 2026-04-06T12:37:09.713Z
9582582 9582582 20260326083241_fGZJd US001U 2026-03-27T12:06:15.328Z 2026-04-04T12:40:12.178Z
9582541 9582541 20260326082107_4SVG9 US001U 2026-03-27T12:06:06.449Z 2026-04-04T12:40:08.079Z
9582516 9582516 20260326081108_OhRx9 US001U 2026-03-27T12:06:01.288Z 2026-04-04T12:40:05.963Z
9577223 9577223 20260325041925_sf4gt US001U 2026-03-26T12:04:28.007Z 2026-04-03T12:36:52.321Z
9562791 9562791 20260323031438_46P71 US001U 2026-03-24T12:04:03.046Z 2026-03-31T12:26:26.012Z
9545597 9545597 20260321105053_hKhXz US001U 2026-03-22T12:09:49.490Z 2026-03-29T12:19:41.701Z
9544553 9544553 20260321085306_zomQ3 US001U 2026-03-22T12:07:08.855Z 2026-03-29T12:19:31.025Z
9543871 9543871 20260321060659_WOKcD US001U 2026-03-22T12:05:00.257Z 2026-03-29T12:19:13.458Z
9543253 9543253 20260321031618_Yatlq US001U 2026-03-22T12:03:10.597Z 2026-03-29T12:19:05.149Z
9537508 9537508 20260320114251_DsLUG US001U 2026-03-21T12:15:56.902Z 2026-03-28T12:35:26.762Z
9537428 9537428 20260320113722_pvsdU US001U 2026-03-21T12:15:45.924Z 2026-03-28T12:35:25.985Z
9536885 9536885 20260320104213_7Nzia US001U 2026-03-21T12:14:37.245Z 2026-03-28T12:35:18.355Z
9535451 9535451 20260320073933_2zgGe US001U 2026-03-21T12:10:51.033Z 2026-03-28T12:34:40.647Z
9535330 9535330 20260320070947_OTuBF US001U 2026-03-21T12:10:24.584Z 2026-03-28T12:34:33.061Z
9523967 9523967 20260319110950_qaROR US001U 2026-03-20T12:12:19.285Z 2026-03-27T12:41:47.713Z
9523368 9523368 20260319095322_zURBs US001U 2026-03-20T12:11:17.155Z 2026-03-27T12:41:28.172Z
9521392 9521392 20260319041106_3ZkUA US001U 2026-03-20T12:07:56.214Z 2026-03-27T12:40:54.411Z
9520169 9520169 20260319025834_MHR63 US001U 2026-03-20T12:05:52.687Z 2026-03-27T12:40:39.951Z
9513993 9513993 20260318103224_zbNDz US001U 2026-03-19T12:16:37.355Z 2026-03-26T12:38:13.161Z
9513823 9513823 20260318100642_26Tbd US001U 2026-03-19T12:16:17.000Z 2026-03-26T12:38:07.982Z
9513607 9513607 20260318093928_7OYWv US001U 2026-03-19T12:15:46.263Z 2026-03-26T12:37:56.848Z
9513587 9513587 20260318093623_JRdds US001U 2026-03-19T12:15:42.854Z 2026-03-26T12:37:56.627Z
9512547 9512547 20260318070156_2fIH0 US001U 2026-03-19T12:12:53.672Z 2026-03-26T12:37:46.535Z
9512497 9512497 20260318063747_q4o4h US001U 2026-03-19T12:12:44.122Z 2026-03-26T12:37:45.993Z
9496269 9496269 20260316110627_xBf8T US001U 2026-03-17T12:09:23.304Z 2026-03-24T12:41:18.950Z
9496075 9496075 20260316102405_gwnGJ US001U 2026-03-17T12:09:00.445Z 2026-03-24T12:41:18.231Z
9496002 9496002 20260316100246_YLj5D US001U 2026-03-17T12:08:45.751Z 2026-03-24T12:41:17.819Z
9495802 9495802 20260316091745_tie4I US001U 2026-03-17T12:08:16.181Z 2026-03-24T12:41:16.741Z
9495494 9495494 20260316080717_q3T7E US001U 2026-03-17T12:07:26.503Z 2026-03-24T12:41:15.044Z
9495336 9495336 20260316064356_rBuy2 US001U 2026-03-17T12:06:54.649Z 2026-03-24T12:41:12.992Z
9495255 9495255 20260316052124_ww5SD US001U 2026-03-17T12:06:36.873Z 2026-03-24T12:41:07.942Z
9494820 9494820 20260316030924_wmD3R US001U 2026-03-17T12:05:06.506Z 2026-03-24T12:40:50.427Z
9448382 9448382 20260309103626_Qf4Gf US001U 2026-03-10T12:09:42.562Z 2026-03-17T12:42:18.052Z
9447818 9447818 20260309085901_Zq209 US001U 2026-03-10T12:07:56.748Z 2026-03-17T12:41:57.057Z
9446933 9446933 20260309033722_kHPo7 US001U 2026-03-10T12:04:31.279Z 2026-03-17T12:41:45.005Z
9446744 9446744 20260309024837_nFFEk US001U 2026-03-10T12:03:39.804Z 2026-03-17T12:41:42.113Z
9443663 9443663 20260308110007_lZy8m US001U 2026-03-09T12:08:36.011Z 2026-03-16T12:44:06.661Z
9443557 9443557 20260308104500_wqiN7 US001U 2026-03-09T12:08:16.331Z 2026-03-16T12:44:05.630Z
9442968 9442968 20260308080050_op3OQ US001U 2026-03-09T12:06:14.399Z 2026-03-16T12:43:59.213Z
9442869 9442869 20260308070604_bFWlP US001U 2026-03-09T12:05:51.440Z 2026-03-16T12:43:58.111Z
9442743 9442743 20260308053650_sgKoC US001U 2026-03-09T12:05:20.431Z 2026-03-16T12:43:56.201Z
9442497 9442497 20260308035752_Hu10F US001U 2026-03-09T12:04:17.707Z 2026-03-16T12:43:52.450Z
9442249 9442249 20260308024312_yk4w0 US001U 2026-03-09T12:03:16.476Z 2026-03-16T12:43:47.703Z
9437688 9437688 20260307061109_IKThb US001U 2026-03-08T12:05:00.476Z 2026-03-15T12:41:24.767Z
9437655 9437655 20260307055124_Dyfg5 US001U 2026-03-08T12:04:52.878Z 2026-03-15T12:41:24.493Z
9437650 9437650 20260307054840_Mz3fs US001U 2026-03-08T12:04:51.901Z 2026-03-15T12:41:24.352Z
9437560 9437560 20260307043531_L1reN US001U 2026-03-08T12:04:30.491Z 2026-03-15T12:41:16.209Z
9437316 9437316 20260307030809_DwMzv US001U 2026-03-08T12:03:32.133Z 2026-03-15T12:41:06.125Z
9423662 9423662 20260304114154_PMQLU US001U 2026-03-05T14:05:44.030Z 2026-03-12T12:33:01.171Z
9423485 9423485 20260304102927_976dQ US001U 2026-03-05T14:05:04.416Z 2026-03-12T12:32:57.962Z
9423448 9423448 20260304101737_9Qfvv US001U 2026-03-05T14:04:52.014Z 2026-03-12T12:32:56.862Z
9423352 9423352 20260304093032_nnPty US001U 2026-03-05T14:04:35.986Z 2026-03-12T12:32:55.079Z
9412218 9412218 20260301014908_Ykx7c US001U 2026-03-02T14:00:50.190Z 2026-03-09T12:39:24.757Z
9404404 9404404 20260227120959_Ho2Gf US001U 2026-02-28T14:10:44.711Z 2026-03-07T14:48:48.192Z
9404232 9404232 20260227114859_aY2qW US001U 2026-02-28T14:10:19.143Z 2026-03-07T14:48:40.842Z
9404228 9404228 20260227114850_t35du US001U 2026-02-28T14:10:18.596Z 2026-03-07T14:48:40.773Z
9404169 9404169 20260227114355_kq0rO US001U 2026-02-28T14:10:10.978Z 2026-03-07T14:48:38.274Z
9404042 9404042 20260227112338_kKhIv US001U 2026-02-28T14:09:51.763Z 2026-03-07T14:48:27.079Z
9403969 9403969 20260227111055_fzt5J US001U 2026-02-28T14:09:37.207Z 2026-03-07T14:48:22.155Z
9403028 9403028 20260227070955_V7eYI US001U 2026-02-28T14:06:58.133Z 2026-03-07T14:47:23.937Z
9402992 9402992 20260227062047_1P26v US001U 2026-02-28T14:06:48.408Z 2026-03-07T14:47:20.580Z
9400117 9400117 20260226122734_cdnB6 US001U 2026-02-27T14:09:35.343Z 2026-03-06T14:44:44.401Z
9400029 9400029 20260226115124_Yj3j0 US001U 2026-02-27T14:09:20.996Z 2026-03-06T14:44:41.748Z
9399955 9399955 20260226112405_0a4U3 US001U 2026-02-27T14:09:09.377Z 2026-03-06T14:44:39.496Z
9399937 9399937 20260226111954_nozAQ US001U 2026-02-27T14:09:05.751Z 2026-03-06T14:44:38.985Z
9399534 9399534 20260226081834_qgC3P US001U 2026-02-27T14:08:04.903Z 2026-03-06T14:44:22.215Z
9399532 9399532 20260226081809_ovQ0U US001U 2026-02-27T14:08:04.560Z 2026-03-06T14:44:22.145Z
9383158 9383158 20260218111108_N01Gy US001U 2026-02-24T14:36:25.275Z 2026-02-27T14:34:53.249Z
9383156 9383156 20260218103134_bGcne US001U 2026-02-24T14:36:22.545Z 2026-02-27T14:34:49.562Z
9383154 9383154 20260218091717_UdLcZ US001U 2026-02-24T14:36:07.858Z 2026-02-27T14:34:36.322Z
9383152 9383152 20260218053012_vAQki US001U 2026-02-24T14:36:00.490Z 2026-02-27T14:34:17.386Z
9378204 9378204 20260222123128_8YmHu US001U 2026-02-24T14:17:38.266Z 2026-02-24T14:17:38.266Z
9378016 9378016 20260222105836_t2egZ US001U 2026-02-24T14:16:46.616Z 2026-02-24T14:16:46.616Z
9377959 9377959 20260222051950_IpMPS US001U 2026-02-24T14:15:30.757Z 2026-02-24T14:15:30.757Z
9375075 9375075 20260223103719_0GgGa US001U 2026-02-24T14:07:56.627Z 2026-03-03T14:31:40.605Z
9374496 9374496 20260223083735_i2wxK US001U 2026-02-24T14:06:09.927Z 2026-03-03T14:31:31.134Z
9373362 9373362 20260223025344_UH52s US001U 2026-02-24T14:02:44.605Z 2026-03-03T14:31:01.966Z
9324525 9324525 20260214115239_NpyAZ US001U 2026-02-15T14:11:08.235Z 2026-02-23T14:47:00.544Z
9324401 9324401 20260214111626_3X6RU US001U 2026-02-15T14:10:24.658Z 2026-02-23T14:46:58.492Z
9324399 9324399 20260214111622_1A28e US001U 2026-02-15T14:10:23.824Z 2026-02-23T14:46:58.438Z
9324337 9324337 20260214105423_8Ahq6 US001U 2026-02-15T14:10:02.326Z 2026-02-23T14:46:57.122Z
9324326 9324326 20260214104733_FR5vT US001U 2026-02-15T14:09:58.663Z 2026-02-23T14:46:56.952Z
9324304 9324304 20260214103908_Nsw7W US001U 2026-02-15T14:09:53.364Z 2026-02-23T14:46:56.596Z
9324225 9324225 20260214100606_7Eb0x US001U 2026-02-15T14:09:26.880Z 2026-02-23T14:46:54.812Z
9323964 9323964 20260214072814_AgCHz US001U 2026-02-15T14:08:00.437Z 2026-02-23T14:46:50.088Z
9323957 9323957 20260214072217_G4gra US001U 2026-02-15T14:07:57.760Z 2026-02-23T14:46:49.896Z
9323805 9323805 20260214060930_aJ739 US001U 2026-02-15T14:07:16.167Z 2026-02-23T14:46:46.991Z

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