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,103 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
8683942 8683942 20251204094050_Mh41d US001U 2025-12-05T14:01:13.315Z 2025-12-06T14:18:00.375Z
8683878 8683878 20251204091017_i202K US001U 2025-12-05T14:00:59.054Z 2025-12-06T14:18:00.358Z
8674719 8674719 20251202031059_dpqE6 US001U 2025-12-03T14:22:14.715Z 2025-12-06T14:34:16.538Z
8674054 8674054 20251202012234_wx2Wg US001U 2025-12-03T14:20:51.984Z 2025-12-06T14:33:47.515Z
8671646 8671646 20251201124528_f1q4C US001U 2025-12-03T14:13:15.083Z 2025-12-06T14:31:14.678Z
8671464 8671464 20251201122200_uWkpB US001U 2025-12-03T14:12:41.798Z 2025-12-06T14:31:07.750Z
8671436 8671436 20251201121907_56Q0J US001U 2025-12-03T14:12:28.671Z 2025-12-06T14:31:06.687Z
8671418 8671418 20251201121526_ZG02b US001U 2025-12-03T14:12:25.988Z 2025-12-06T14:31:04.953Z
8671318 8671318 20251201120011_5kvRC US001U 2025-12-03T14:12:09.170Z 2025-12-06T14:30:54.744Z
8671262 8671262 20251201114936_6YNd2 US001U 2025-12-03T14:11:57.382Z 2025-12-06T14:30:49.830Z
8670768 8670768 20251201100854_c6CsK US001U 2025-12-03T14:10:02.059Z 2025-12-06T14:30:21.104Z
8670537 8670537 20251201091932_vSjF3 US001U 2025-12-03T14:09:09.027Z 2025-12-06T14:30:08.476Z
8667432 8667432 20251130011850_bhq7i US001U 2025-12-02T14:38:08.428Z 2025-12-06T14:47:39.092Z
8659916 8659916 20251130113007_7ujdB US001U 2025-12-02T14:05:49.052Z 2025-12-06T14:36:47.144Z
8659075 8659075 20251130092923_FGU8p US001U 2025-12-02T14:02:27.876Z 2025-12-06T14:36:05.538Z
8658852 8658852 20251130083645_CoINm US001U 2025-12-02T14:01:13.064Z 2025-12-06T14:35:43.482Z
8658820 8658820 20251130082649_29i4y US001U 2025-12-02T14:01:00.750Z 2025-12-06T14:35:42.190Z
8626296 8626296 20251126084655_R6h5Y US001U 2025-11-28T14:38:36.455Z 2025-12-04T15:12:11.309Z
8626221 8626221 20251126081838_GsyrV US001U 2025-11-28T14:38:12.665Z 2025-12-04T15:12:01.340Z
8626203 8626203 20251126081211_3iCP4 US001U 2025-11-28T14:38:09.348Z 2025-12-04T15:12:00.059Z
8626112 8626112 20251126073753_ts93G US001U 2025-11-28T14:37:42.403Z 2025-12-04T15:11:52.743Z
8626103 8626103 20251126073601_iTIHZ US001U 2025-11-28T14:37:40.958Z 2025-12-04T15:11:52.591Z
8626086 8626086 20251126072929_gDklc US001U 2025-11-28T14:37:38.916Z 2025-12-04T15:11:52.156Z
8625998 8625998 20251126065551_EQadT US001U 2025-11-28T14:37:30.358Z 2025-12-04T15:11:49.712Z
8625990 8625990 20251126065251_ftSY2 US001U 2025-11-28T14:37:28.970Z 2025-12-04T15:11:49.470Z
8625981 8625981 20251126064928_F22gd US001U 2025-11-28T14:37:28.338Z 2025-12-04T15:11:49.139Z
8625963 8625963 20251126064608_sk26p US001U 2025-11-28T14:37:27.696Z 2025-12-04T15:11:45.344Z
8625913 8625913 20251126062427_f9lf9 US001U 2025-11-28T14:37:23.665Z 2025-12-04T15:11:42.899Z
8625840 8625840 20251126055421_bR8UZ US001U 2025-11-28T14:37:15.658Z 2025-12-04T15:11:38.598Z
8625828 8625828 20251126054418_RLJvk US001U 2025-11-28T14:37:12.347Z 2025-12-04T15:11:36.586Z
8625786 8625786 20251126051914_wO2Fh US001U 2025-11-28T14:36:30.869Z 2025-12-04T15:11:32.461Z
8625736 8625736 20251126044151_vkyCk US001U 2025-11-28T14:36:17.021Z 2025-12-04T15:11:25.319Z
8625679 8625679 20251126041415_xLBaP US001U 2025-11-28T14:36:05.942Z 2025-12-04T15:10:44.733Z
8625633 8625633 20251126034753_QSXb3 US001U 2025-11-28T14:35:27.101Z 2025-12-04T15:10:11.482Z
8625590 8625590 20251126032512_yZD6p US001U 2025-11-28T14:35:17.431Z 2025-12-04T15:09:49.566Z
8620141 8620141 20251126115419_Ix3Vd US001U 2025-11-28T14:11:53.057Z 2025-12-05T15:01:31.982Z
8619907 8619907 20251126111410_P8Clh US001U 2025-11-28T14:10:57.704Z 2025-12-05T15:01:11.466Z
8619905 8619905 20251126111405_ZMbpX US001U 2025-11-28T14:10:57.274Z 2025-12-05T15:01:11.407Z
8619643 8619643 20251126104003_sMFqR US001U 2025-11-28T14:09:50.519Z 2025-12-05T15:01:03.769Z
8619512 8619512 20251126102035_OkOps US001U 2025-11-28T14:09:15.700Z 2025-12-05T15:01:00.617Z
8619461 8619461 20251126101326_Lf1ck US001U 2025-11-28T14:08:57.327Z 2025-12-05T15:00:59.219Z
8619284 8619284 20251126094239_KxpWI US001U 2025-11-28T14:08:14.852Z 2025-12-05T15:00:55.510Z
8619228 8619228 20251126093210_23F72 US001U 2025-11-28T14:07:55.395Z 2025-12-05T15:00:53.872Z
8593778 8593778 20251125124957_2sOfS US001U 2025-11-26T14:03:21.771Z 2025-12-04T15:05:24.163Z
8593713 8593713 20251125123213_TwodY US001U 2025-11-26T14:03:13.577Z 2025-12-04T15:05:23.082Z
8593669 8593669 20251125122053_tWJLz US001U 2025-11-26T14:03:01.468Z 2025-12-04T15:05:22.236Z
8593663 8593663 20251125121918_BBKmQ US001U 2025-11-26T14:03:00.185Z 2025-12-04T15:05:22.159Z
8593588 8593588 20251125120259_UU2Gz US001U 2025-11-26T14:02:45.556Z 2025-12-04T15:05:20.583Z
8593262 8593262 20251125105503_BHxZy US001U 2025-11-26T14:01:35.759Z 2025-12-04T15:05:14.763Z
8589165 8589165 20251124011051_Dg2Gk US001U 2025-11-25T14:19:21.708Z 2025-12-02T15:12:10.399Z
8584571 8584571 20251123124206_Sy7qP US001U 2025-11-25T14:06:49.451Z 2025-12-02T15:09:50.483Z
8584441 8584441 20251123121347_mfBTa US001U 2025-11-25T14:06:21.849Z 2025-12-02T15:09:48.718Z
8584259 8584259 20251123112931_8R9Oc US001U 2025-11-25T14:05:46.690Z 2025-12-02T15:09:47.375Z
8583843 8583843 20251123095533_EGoBK US001U 2025-11-25T14:04:12.533Z 2025-12-02T15:09:43.163Z
8583024 8583024 20251123094420_wMUIt US001U 2025-11-24T14:34:45.842Z 2025-12-01T15:22:30.948Z
8583001 8583001 20251123093334_9jU9F US001U 2025-11-24T14:34:42.456Z 2025-12-01T15:22:30.640Z
8582778 8582778 20251123082859_VHCG2 US001U 2025-11-24T14:34:30.355Z 2025-12-01T15:22:27.859Z
8582580 8582580 20251123071003_1hFC9 US001U 2025-11-24T14:34:14.821Z 2025-12-01T15:22:25.536Z
8582576 8582576 20251123070947_oVRDg US001U 2025-11-24T14:34:10.275Z 2025-12-01T15:22:25.480Z
8582493 8582493 20251123063358_S54CM US001U 2025-11-24T14:33:44.059Z 2025-12-01T15:22:24.505Z
8582442 8582442 20251123062032_UaZNo US001U 2025-11-24T14:33:37.538Z 2025-12-01T15:22:23.985Z
8582390 8582390 20251123055800_W13P1 US001U 2025-11-24T14:33:33.174Z 2025-12-01T15:22:23.056Z
8582363 8582363 20251123055346_B5lnm US001U 2025-11-24T14:33:31.672Z 2025-12-01T15:22:22.750Z
8582255 8582255 20251123050242_W5SUm US001U 2025-11-24T14:33:26.042Z 2025-12-01T15:22:20.428Z
8582229 8582229 20251123044852_Zhy7H US001U 2025-11-24T14:33:23.935Z 2025-12-01T15:22:19.403Z
8582102 8582102 20251123040843_7g7XN US001U 2025-11-24T14:33:17.039Z 2025-12-01T15:22:16.235Z
8582093 8582093 20251123040444_NhzP3 US001U 2025-11-24T14:33:16.519Z 2025-12-01T15:22:16.023Z
8582054 8582054 20251123035518_oaZVr US001U 2025-11-24T14:33:13.836Z 2025-12-01T15:22:15.027Z
8582032 8582032 20251123034833_oD7O1 US001U 2025-11-24T14:33:12.489Z 2025-12-01T15:22:14.494Z
8582018 8582018 20251123033949_R3kLZ US001U 2025-11-24T14:33:05.789Z 2025-12-01T15:22:13.977Z
8581959 8581959 20251123031953_KKDKB US001U 2025-11-24T14:32:49.887Z 2025-12-01T15:22:04.342Z
8581783 8581783 20251123022132_b33PS US001U 2025-11-24T14:32:37.984Z 2025-12-01T15:21:36.697Z
8581779 8581779 20251123021928_mZEJT US001U 2025-11-24T14:32:37.506Z 2025-12-01T15:21:34.311Z
8581220 8581220 20251122100432_kfDF1 US001U 2025-11-24T14:29:40.242Z 2025-11-30T15:07:26.094Z
8580851 8580851 20251122081317_jvBE6 US001U 2025-11-24T14:28:59.896Z 2025-11-30T15:07:12.485Z
8580802 8580802 20251122074628_T2Rej US001U 2025-11-24T14:28:56.057Z 2025-11-30T15:07:11.677Z
8574714 8574714 20251122102859_h2xV4 US001U 2025-11-24T14:00:45.072Z 2025-12-01T15:17:24.380Z
8574604 8574604 20251122100839_NywJH US001U 2025-11-24T14:00:14.619Z 2025-12-01T15:17:15.043Z
8574457 8574457 20251122065049_Qh2pJ US001U 2025-11-23T14:43:36.162Z 2025-11-30T15:07:09.438Z
8574340 8574340 20251122055331_y0D5O US001U 2025-11-23T14:43:07.220Z 2025-11-30T15:07:05.067Z
8573974 8573974 20251122045258_U1B0e US001U 2025-11-23T14:42:09.841Z 2025-11-30T15:06:54.260Z
8573943 8573943 20251122044618_kxThD US001U 2025-11-23T14:42:08.172Z 2025-11-30T15:06:51.553Z
8573225 8573225 20251122024358_PEGOV US001U 2025-11-23T14:41:01.169Z 2025-11-30T15:06:12.581Z
8573188 8573188 20251122024157_HaN8F US001U 2025-11-23T14:40:59.349Z 2025-11-30T15:06:11.993Z
8572923 8572923 20251122020301_USZQD US001U 2025-11-23T14:40:07.786Z 2025-11-23T14:40:07.786Z
8572626 8572626 20251122012041_EIr92 US001U 2025-11-23T14:39:35.348Z 2025-11-30T15:05:53.349Z
8570665 8570665 20251121100920_Tr2NX US001U 2025-11-23T14:33:58.315Z 2025-11-29T14:55:13.232Z
8570635 8570635 20251121100405_TuTDs US001U 2025-11-23T14:33:56.214Z 2025-11-29T14:55:08.469Z
8570633 8570633 20251121100323_OH5Os US001U 2025-11-23T14:33:55.888Z 2025-11-29T14:55:08.322Z
8560615 8560615 20251121102537_sy7f1 US001U 2025-11-23T14:00:19.449Z 2025-11-30T15:02:33.700Z
8552294 8552294 20251120035736_EYgVv US001U 2025-11-22T14:32:17.107Z 2025-11-28T14:57:30.274Z
8525347 8525347 20251118103711_N2bUW US001U 2025-11-20T14:36:52.599Z 2025-11-26T15:08:25.937Z
8501605 8501605 20251116112507_RpmZo US001U 2025-11-18T14:47:31.363Z 2025-11-24T15:06:45.504Z
8501553 8501553 20251116112301_4ioyG US001U 2025-11-18T14:47:29.691Z 2025-11-24T15:06:42.892Z
8501383 8501383 20251116105328_SQSK3 US001U 2025-11-18T14:47:22.269Z 2025-11-24T15:06:30.324Z
8501158 8501158 20251116103200_hoTcR US001U 2025-11-18T14:47:15.147Z 2025-11-24T15:06:22.731Z
8501022 8501022 20251116101244_bKhNG US001U 2025-11-18T14:47:09.707Z 2025-11-24T15:06:09.871Z
8500743 8500743 20251116094211_izG2p US001U 2025-11-18T14:46:30.927Z 2025-11-24T15:05:56.895Z
8500244 8500244 20251116082155_evvBD US001U 2025-11-18T14:45:46.080Z 2025-11-24T15:05:37.101Z
8500210 8500210 20251116080918_WVr89 US001U 2025-11-18T14:45:38.456Z 2025-11-24T15:05:35.987Z

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