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

450 rows where station_code = "US002Z" 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
9622704 9622704 20260407020429_6r5OM US002Z 2026-04-08T12:21:38.948Z 2026-04-09T12:34:41.550Z
9616907 9616907 20260407073211_gQ5YP US002Z 2026-04-08T12:00:57.340Z 2026-04-09T12:28:33.464Z
9593430 9593430 20260329103835_W2eQD US002Z 2026-03-30T12:03:56.478Z 2026-04-07T12:27:09.925Z
9593089 9593089 20260329054644_Bb2GT US002Z 2026-03-30T12:02:54.534Z 2026-04-07T12:27:01.392Z
9523216 9523216 20260319093816_lz3RF US002Z 2026-03-20T12:11:05.749Z 2026-03-27T12:41:26.730Z
9522877 9522877 20260319090335_OKsfa US002Z 2026-03-20T12:10:28.747Z 2026-03-27T12:41:22.453Z
9522170 9522170 20260319063438_nkZ2U US002Z 2026-03-20T12:09:13.306Z 2026-03-27T12:41:14.645Z
9514128 9514128 20260318104909_sqiDI US002Z 2026-03-19T12:16:50.945Z 2026-03-26T12:38:14.138Z
9504200 9504200 20260317105544_2GzN6 US002Z 2026-03-18T12:07:26.091Z 2026-03-25T12:42:20.222Z
9478371 9478371 20260314091149_ytL4T US002Z 2026-03-15T12:10:55.118Z 2026-03-22T12:42:09.831Z
9465812 9465812 20260312105909_7jauv US002Z 2026-03-13T12:10:46.000Z 2026-03-20T12:37:05.992Z
9464930 9464930 20260312081525_gRFQx US002Z 2026-03-13T12:08:39.633Z 2026-03-20T12:36:58.309Z
9464902 9464902 20260312080851_J1QIn US002Z 2026-03-13T12:08:33.838Z 2026-03-20T12:36:57.211Z
9464596 9464596 20260312063013_c5WJn US002Z 2026-03-13T12:07:46.476Z 2026-03-20T12:36:48.353Z
9404303 9404303 20260227115624_yUgKV US002Z 2026-02-28T14:10:30.672Z 2026-03-07T14:48:44.002Z
9384633 9384633 20260224120133_crXdS US002Z 2026-02-25T14:06:26.322Z 2026-03-04T14:18:12.655Z
9384560 9384560 20260224115037_LX6vo US002Z 2026-02-25T14:06:12.869Z 2026-03-04T14:18:11.420Z
9384090 9384090 20260224101312_l2xhX US002Z 2026-02-25T14:04:34.531Z 2026-03-04T14:18:01.236Z
9383907 9383907 20260224092513_jzI8c US002Z 2026-02-25T14:03:46.049Z 2026-03-04T14:17:57.478Z
9383880 9383880 20260224091414_IkJp7 US002Z 2026-02-25T14:03:37.435Z 2026-03-04T14:17:56.895Z
9383733 9383733 20260224082038_vKdO3 US002Z 2026-02-25T14:02:58.297Z 2026-03-04T14:17:53.921Z
9374372 9374372 20260223080859_febyd US002Z 2026-02-24T14:05:49.509Z 2026-03-03T14:31:28.843Z
9367188 9367188 20260222113830_MU1s4 US002Z 2026-02-23T14:09:42.470Z 2026-02-24T14:17:02.535Z
9366608 9366608 20260222100802_aB5Up US002Z 2026-02-23T14:08:06.135Z 2026-02-24T14:16:28.888Z
9366047 9366047 20260222082622_1nbXM US002Z 2026-02-23T14:06:11.180Z 2026-02-24T14:15:57.627Z
9365961 9365961 20260222074343_xhu1u US002Z 2026-02-23T14:05:46.981Z 2026-02-24T14:15:49.415Z
9331892 9331892 20260216091221_5iLjg US002Z 2026-02-17T14:08:54.605Z 2026-02-25T14:42:03.490Z
9331858 9331858 20260216085037_hMr3C US002Z 2026-02-17T14:08:44.370Z 2026-02-25T14:42:02.938Z
9331741 9331741 20260216075836_pvDzj US002Z 2026-02-17T14:08:07.793Z 2026-02-25T14:42:01.340Z
9327515 9327515 20260215062500_qpcIR US002Z 2026-02-16T14:04:47.784Z 2026-02-24T14:41:56.186Z
9317813 9317813 20260212110112_b2Mdo US002Z 2026-02-13T14:07:27.950Z 2026-02-21T14:37:03.898Z
9317649 9317649 20260212102137_syo35 US002Z 2026-02-13T14:06:23.368Z 2026-02-21T14:37:01.847Z
9317032 9317032 20260212061923_FcwCw US002Z 2026-02-13T14:02:18.751Z 2026-02-21T14:36:49.126Z
9307579 9307579 20260209064612_JyRf4 US002Z 2026-02-10T14:03:08.885Z 2026-02-18T14:58:44.677Z
9307355 9307355 20260209050809_GN2lZ US002Z 2026-02-10T14:01:48.228Z 2026-02-18T14:58:23.169Z
9307317 9307317 20260209045213_dKhyR US002Z 2026-02-10T14:01:34.042Z 2026-02-18T14:58:20.315Z
9299277 9299277 20260207092001_xgYZE US002Z 2026-02-08T14:04:30.148Z 2026-02-16T14:56:18.763Z
9299045 9299045 20260207074611_owgaO US002Z 2026-02-08T14:03:13.601Z 2026-02-16T14:55:58.152Z
9299006 9299006 20260207070817_GMFKh US002Z 2026-02-08T14:02:58.203Z 2026-02-16T14:55:54.988Z
9298847 9298847 20260207052650_MKIWJ US002Z 2026-02-08T14:02:00.511Z 2026-02-16T14:55:41.997Z
9296273 9296273 20260206114810_IcJdB US002Z 2026-02-07T14:07:48.570Z 2026-02-15T14:57:32.182Z
9295912 9295912 20260206105237_D8Trz US002Z 2026-02-07T14:06:20.392Z 2026-02-15T14:57:04.881Z
9295749 9295749 20260206102934_QUJ8p US002Z 2026-02-07T14:05:36.028Z 2026-02-15T14:56:51.351Z
9295194 9295194 20260206084211_mvOHD US002Z 2026-02-07T14:02:56.088Z 2026-02-15T14:56:11.783Z
9294810 9294810 20260206040906_kQHO0 US002Z 2026-02-07T14:00:18.632Z 2026-02-15T14:55:38.794Z
9294808 9294808 20260206040905_aSeyD US002Z 2026-02-07T14:00:17.447Z 2026-02-15T14:55:38.555Z
9292664 9292664 20260205104055_Z3j10 US002Z 2026-02-06T14:06:09.809Z 2026-02-14T15:03:21.507Z
9292424 9292424 20260205094903_VGDtE US002Z 2026-02-06T14:04:52.703Z 2026-02-14T15:02:55.898Z
9285463 9285463 20260201120951_IdwPG US002Z 2026-02-02T14:03:09.427Z 2026-02-10T14:52:35.604Z
9282673 9282673 20260131113917_dqbWh US002Z 2026-02-01T14:04:47.671Z 2026-02-09T14:50:27.674Z
9282113 9282113 20260131092917_Xjsem US002Z 2026-02-01T14:02:12.690Z 2026-02-09T14:49:36.988Z
9281959 9281959 20260131080828_rWc9W US002Z 2026-02-01T14:01:20.049Z 2026-02-09T14:49:20.659Z
9274464 9274464 20260129115435_6sSMh US002Z 2026-01-30T14:04:23.365Z 2026-02-07T14:50:06.809Z
9267935 9267935 20260127065957_e3az4 US002Z 2026-01-28T14:23:56.586Z 2026-02-04T14:50:14.413Z
9267550 9267550 20260127030254_60GIc US002Z 2026-01-28T14:22:12.369Z 2026-02-04T14:49:27.668Z
9263918 9263918 20260127104220_gU99d US002Z 2026-01-28T14:03:31.759Z 2026-02-05T14:45:01.994Z
9263547 9263547 20260127090829_qrLQb US002Z 2026-01-28T14:01:20.240Z 2026-02-05T14:44:25.462Z
9231657 9231657 20260119091615_HOb10 US002Z 2026-01-20T14:33:48.056Z 2026-01-27T15:06:43.077Z
9231569 9231569 20260119085006_V3fkJ US002Z 2026-01-20T14:33:23.903Z 2026-01-27T15:06:36.703Z
9231382 9231382 20260119074345_lDKTJ US002Z 2026-01-20T14:32:34.545Z 2026-01-27T15:06:27.080Z
9231327 9231327 20260119072309_22bF3 US002Z 2026-01-20T14:32:22.692Z 2026-01-27T15:06:23.999Z
9225627 9225627 20260118102754_4Hvg3 US002Z 2026-01-19T14:29:37.259Z 2026-01-26T15:04:40.276Z
9225185 9225185 20260118082838_52ER3 US002Z 2026-01-19T14:27:55.057Z 2026-01-26T15:04:07.454Z
9225015 9225015 20260118071507_LX081 US002Z 2026-01-19T14:27:16.978Z 2026-01-26T15:03:58.664Z
9224826 9224826 20260118061014_mrCc6 US002Z 2026-01-19T14:26:18.245Z 2026-01-26T15:03:50.460Z
9224719 9224719 20260118054950_laHIq US002Z 2026-01-19T14:25:42.325Z 2026-01-26T15:03:46.607Z
9224087 9224087 20260118032119_6Ms7l US002Z 2026-01-19T14:22:46.619Z 2026-01-26T15:02:50.704Z
9219795 9219795 20260118111929_FpDV0 US002Z 2026-01-19T14:00:52.486Z 2026-01-27T14:58:31.523Z
9219750 9219750 20260118111306_156af US002Z 2026-01-19T14:00:31.587Z 2026-01-27T14:58:29.103Z
9215309 9215309 20260116095331_XlRda US002Z 2026-01-17T14:25:09.195Z 2026-01-24T15:14:40.882Z
9214202 9214202 20260116055353_sztj5 US002Z 2026-01-17T14:20:34.861Z 2026-01-24T15:13:22.440Z
9210098 9210098 20260115120642_SlV16 US002Z 2026-01-16T14:18:41.804Z 2026-01-22T15:05:47.841Z
9209569 9209569 20260115101201_48MbB US002Z 2026-01-16T14:16:46.378Z 2026-01-22T15:05:30.264Z
9208666 9208666 20260115062202_1ciJ2 US002Z 2026-01-16T14:13:35.616Z 2026-01-22T15:04:36.833Z
9208597 9208597 20260115060546_KxVdf US002Z 2026-01-16T14:13:17.106Z 2026-01-22T15:04:34.664Z
9205179 9205179 20260114105240_FVmub US002Z 2026-01-15T14:30:02.707Z 2026-01-22T15:11:10.026Z
9204863 9204863 20260114092241_27mtk US002Z 2026-01-15T14:28:58.855Z 2026-01-22T15:11:04.527Z
9204657 9204657 20260114075709_IoytJ US002Z 2026-01-15T14:28:03.157Z 2026-01-22T15:11:00.642Z
9190272 9190272 20260112083329_9WZYu US002Z 2026-01-13T14:21:34.174Z 2026-01-20T15:24:14.330Z
9183438 9183438 20260111093035_TaQ9v US002Z 2026-01-12T14:17:48.591Z 2026-01-19T15:19:39.415Z
9156446 9156446 20260104105822_cyu4S US002Z 2026-01-06T14:39:38.541Z 2026-01-12T15:12:10.975Z
9156426 9156426 20260104104524_QoNfn US002Z 2026-01-06T14:39:35.329Z 2026-01-12T15:12:09.854Z
9132911 9132911 20260103112215_WDYId US002Z 2026-01-04T14:18:59.326Z 2026-01-10T15:02:13.421Z
9132880 9132880 20260103111054_Vmd0t US002Z 2026-01-04T14:18:45.621Z 2026-01-10T15:02:11.638Z
9128446 9128446 20260102114145_ZwHW0 US002Z 2026-01-03T14:15:29.127Z 2026-01-09T14:50:50.291Z
9128368 9128368 20260102094059_WI6is US002Z 2026-01-03T14:14:50.543Z 2026-01-09T14:50:45.234Z
9122714 9122714 20260101120426_yFBw2 US002Z 2026-01-02T14:14:38.451Z 2026-01-09T14:53:49.979Z
9122667 9122667 20260101112940_dfdIA US002Z 2026-01-02T14:14:22.571Z 2026-01-09T14:53:40.870Z
9122621 9122621 20260101105849_lXZfC US002Z 2026-01-02T14:14:07.037Z 2026-01-09T14:53:38.124Z
9117303 9117303 20251231102346_mdrD5 US002Z 2026-01-01T14:31:01.361Z 2026-01-08T15:12:48.410Z
9054856 9054856 20251227025554_qPj2S US002Z 2025-12-29T14:16:30.447Z 2026-01-04T15:27:34.353Z
9019442 9019442 20251220095232_CyhFM US002Z 2025-12-27T15:04:23.110Z 2025-12-29T15:24:33.809Z
9019253 9019253 20251220092507_vy7F2 US002Z 2025-12-27T15:03:45.112Z 2025-12-29T15:24:31.007Z
9016542 9016542 20251220041053_nWZA8 US002Z 2025-12-27T14:59:48.057Z 2025-12-27T14:59:48.057Z
8979312 8979312 20251219111923_yPVFU US002Z 2025-12-26T14:18:08.856Z 2025-12-28T15:18:26.859Z
8979161 8979161 20251219104713_0fx7H US002Z 2025-12-26T14:17:39.393Z 2025-12-28T15:17:54.555Z
8979113 8979113 20251219104236_xM2Ij US002Z 2025-12-26T14:17:27.598Z 2025-12-28T15:17:48.337Z
8978583 8978583 20251219080006_34hhE US002Z 2025-12-26T14:15:43.847Z 2025-12-28T15:17:41.210Z
8927170 8927170 20251215034424_Zh0Ia US002Z 2025-12-24T14:06:51.119Z 2025-12-24T15:09:29.990Z
8926791 8926791 20251215032643_ehQo2 US002Z 2025-12-24T14:05:13.367Z 2025-12-24T15:09:29.566Z

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