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

127 rows where station_code = "UA0005" 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
9243199 9243199 20260121035803_BSPB4 UA0005 2026-01-22T14:20:54.736Z 2026-01-29T15:04:50.507Z
9242493 9242493 20260121020542_7BZ1N UA0005 2026-01-22T14:18:03.009Z 2026-01-29T15:04:01.587Z
9236088 9236088 20260120023328_TEULE UA0005 2026-01-21T14:21:24.423Z 2026-01-28T14:59:44.062Z
9234561 9234561 20260119222339_ySicA UA0005 2026-01-21T14:15:08.322Z 2026-01-28T14:57:54.056Z
9224034 9224034 20260118031219_SoD62 UA0005 2026-01-19T14:22:28.618Z 2026-01-26T15:02:48.547Z
9224026 9224026 20260118031042_YmcIF UA0005 2026-01-19T14:22:26.829Z 2026-01-26T15:02:48.252Z
9223965 9223965 20260118030255_nDWNO UA0005 2026-01-19T14:22:09.099Z 2026-01-26T15:02:46.310Z
9150710 9150710 20260105031643_koUaB UA0005 2026-01-06T14:11:07.973Z 2026-01-13T15:13:50.351Z
9149974 9149974 20260105002206_3Xuk2 UA0005 2026-01-06T14:08:00.921Z 2026-01-13T15:12:48.087Z
9149896 9149896 20260105000434_INA6j UA0005 2026-01-06T14:07:43.022Z 2026-01-13T15:12:44.903Z
9148151 9148151 20260103173251_2iwo2 UA0005 2026-01-05T14:30:19.363Z 2026-01-10T15:04:18.464Z
9146923 9146923 20260104044500_PE3xU UA0005 2026-01-05T14:23:16.939Z 2026-01-12T15:09:41.511Z
9146858 9146858 20260104043723_sCmqT UA0005 2026-01-05T14:22:59.643Z 2026-01-12T15:09:36.599Z
9146796 9146796 20260104042816_0JN2w UA0005 2026-01-05T14:22:51.078Z 2026-01-12T15:09:30.783Z
9146654 9146654 20260104041140_14t5b UA0005 2026-01-05T14:22:39.921Z 2026-01-12T15:09:03.705Z
9146609 9146609 20260104040726_Xn6ZD UA0005 2026-01-05T14:22:34.562Z 2026-01-12T15:09:00.125Z
9146131 9146131 20260104033703_z8Kpl UA0005 2026-01-05T14:21:48.275Z 2026-01-12T15:08:20.601Z
9144947 9144947 20260104025959_aGqnC UA0005 2026-01-05T14:19:45.791Z 2026-01-12T15:07:20.111Z
8793975 8793975 20251213041843_Ovpjp UA0005 2025-12-16T14:06:32.045Z 2025-12-23T14:16:59.247Z
8789203 8789203 20251213030756_0fich UA0005 2025-12-15T14:39:35.701Z 2025-12-15T14:40:58.644Z
8785248 8785248 20251213021308_3YpAT UA0005 2025-12-15T14:36:45.375Z 2025-12-21T14:17:36.073Z
8785090 8785090 20251213020905_ooHJV UA0005 2025-12-15T14:36:25.064Z 2025-12-21T14:17:35.957Z
7805311 7805311 20250911013609_m23H2 UA0005 2025-09-12T12:05:54.401Z 2025-09-19T12:56:54.608Z
7794866 7794866 20250909001242_5563H UA0005 2025-09-10T12:05:30.143Z 2025-09-17T12:56:24.083Z
7794632 7794632 20250908233342_yXqct UA0005 2025-09-10T12:04:53.027Z 2025-09-17T12:56:20.110Z
7794516 7794516 20250908230707_8ZVix UA0005 2025-09-10T12:04:27.453Z 2025-09-17T12:56:19.682Z
7790230 7790230 20250908010114_5PxOq UA0005 2025-09-09T12:06:10.482Z 2025-09-16T12:51:00.190Z
7783250 7783250 20250906220716_SxsVO UA0005 2025-09-08T12:05:20.328Z 2025-09-15T12:43:10.127Z
7778824 7778824 20250906000018_GtESW UA0005 2025-09-07T12:07:00.036Z 2025-09-14T12:49:02.373Z
7777593 7777593 20250905194340_pUyQx UA0005 2025-09-07T12:02:16.401Z 2025-09-14T12:48:49.516Z
7768550 7768550 20250904221905_5JYlo UA0005 2025-09-06T12:39:09.330Z 2025-09-13T12:55:37.289Z
7768368 7768368 20250904215616_PkSOo UA0005 2025-09-06T12:38:00.692Z 2025-09-13T12:55:32.502Z
7760653 7760653 20250903234952_EmGX3 UA0005 2025-09-05T12:13:48.658Z 2025-09-12T12:49:13.117Z
7749898 7749898 20250902223133_Xp6t3 UA0005 2025-09-04T12:11:54.468Z 2025-09-11T12:43:38.561Z
7748746 7748746 20250902175901_hY5Ip UA0005 2025-09-04T12:07:52.440Z 2025-09-11T12:43:28.503Z
7738802 7738802 20250901222256_PKxi8 UA0005 2025-09-03T12:13:51.202Z 2025-09-10T12:45:56.836Z
7710643 7710643 20250830193538_M5nXA UA0005 2025-09-01T12:08:28.929Z 2025-09-08T12:51:54.185Z
7702316 7702316 20250829220309_NkXHI UA0005 2025-08-31T12:19:47.507Z 2025-09-07T12:58:04.747Z
7679722 7679722 20250827182916_2uC6t UA0005 2025-08-29T12:11:41.046Z 2025-09-05T13:04:34.954Z
7582924 7582924 20250819202613_PhaHt UA0005 2025-08-21T12:18:45.389Z 2025-08-28T12:52:27.698Z
7582918 7582918 20250819202149_kZL3g UA0005 2025-08-21T12:18:44.620Z 2025-08-28T12:52:27.543Z
7574721 7574721 20250817233114_nmzot UA0005 2025-08-20T12:36:56.058Z 2025-08-25T12:52:12.860Z
7564764 7564764 20250818010220_Ha99I UA0005 2025-08-20T12:01:17.567Z 2025-08-27T13:13:00.171Z
7560970 7560970 20250816214552_xkr8E UA0005 2025-08-19T12:58:44.169Z 2025-08-24T12:48:50.812Z
7547034 7547034 20250815220749_43Mhg UA0005 2025-08-18T12:44:43.966Z 2025-08-23T12:49:53.663Z
7531528 7531528 20250816005333_bOhpP UA0005 2025-08-18T12:07:09.615Z 2025-08-24T12:47:33.786Z
7531425 7531425 20250816004519_1d5bb UA0005 2025-08-18T12:06:51.802Z 2025-08-24T12:47:32.800Z
7527425 7527425 20250814202951_7Af8Y UA0005 2025-08-17T12:47:39.324Z 2025-08-22T12:47:32.722Z
7527223 7527223 20250814201315_mHVaE UA0005 2025-08-17T12:47:17.837Z 2025-08-22T12:47:32.198Z
7527049 7527049 20250814195000_VCHrE UA0005 2025-08-17T12:47:09.793Z 2025-08-22T12:47:31.152Z
7517311 7517311 20250815005102_ug3Dw UA0005 2025-08-17T12:13:39.089Z 2025-08-23T12:48:34.231Z
7517091 7517091 20250815004350_AwfQn UA0005 2025-08-17T12:13:07.770Z 2025-08-23T12:48:33.948Z
7516327 7516327 20250815002246_jfQY7 UA0005 2025-08-17T12:11:28.501Z 2025-08-23T12:48:31.723Z
7515417 7515417 20250814234749_xli1O UA0005 2025-08-17T12:09:18.523Z 2025-08-23T12:48:28.355Z
7513401 7513401 20250814224205_TuEMx UA0005 2025-08-17T12:04:24.495Z 2025-08-23T12:48:16.282Z
7513027 7513027 20250814222825_BLyGL UA0005 2025-08-17T12:03:18.971Z 2025-08-23T12:48:12.957Z
7502862 7502862 20250813185824_HD4NA UA0005 2025-08-16T12:44:21.727Z 2025-08-21T12:48:23.805Z
7502828 7502828 20250813185244_SGIqw UA0005 2025-08-16T12:44:20.652Z 2025-08-21T12:48:23.740Z
7499141 7499141 20250814002439_LCP2F UA0005 2025-08-16T12:14:23.516Z 2025-08-22T12:46:44.293Z
7498347 7498347 20250813233716_2P4KM UA0005 2025-08-16T12:12:23.911Z 2025-08-22T12:46:43.066Z
7472938 7472938 20250812195249_jMVos UA0005 2025-08-14T12:33:05.117Z 2025-08-20T13:08:01.153Z
7472713 7472713 20250812192308_63hwc UA0005 2025-08-14T12:32:57.495Z 2025-08-20T13:07:59.926Z
7472658 7472658 20250812191256_L6G5m UA0005 2025-08-14T12:32:55.114Z 2025-08-20T13:07:59.578Z
7463415 7463415 20250813004059_dGXND UA0005 2025-08-14T12:13:57.441Z 2025-08-14T12:13:57.441Z
7461321 7461321 20250812235349_SyUAZ UA0005 2025-08-14T12:12:03.423Z 2025-08-21T12:47:28.272Z
7459614 7459614 20250812231131_H5XOr UA0005 2025-08-14T12:09:51.309Z 2025-08-21T12:47:25.128Z
7459202 7459202 20250812230115_ZyBwb UA0005 2025-08-14T12:09:27.414Z 2025-08-21T12:47:24.503Z
7459092 7459092 20250812225814_3xi5m UA0005 2025-08-14T12:09:23.516Z 2025-08-21T12:47:24.100Z
7458614 7458614 20250812224722_QpZ2C UA0005 2025-08-14T12:08:32.164Z 2025-08-21T12:47:23.115Z
7458589 7458589 20250812224648_183k2 UA0005 2025-08-14T12:08:31.073Z 2025-08-21T12:47:23.080Z
7457449 7457449 20250812222009_ySB4D UA0005 2025-08-14T12:07:29.085Z 2025-08-21T12:47:16.751Z
7457273 7457273 20250812221624_jNpaT UA0005 2025-08-14T12:07:21.560Z 2025-08-21T12:47:16.232Z
7455853 7455853 20250812214135_lQNqW UA0005 2025-08-14T12:05:42.319Z 2025-08-21T12:47:12.152Z
7454199 7454199 20250812210214_wY0YA UA0005 2025-08-14T12:03:15.188Z 2025-08-21T12:47:06.076Z
7453870 7453870 20250812205059_5bxII UA0005 2025-08-14T12:02:36.985Z 2025-08-21T12:47:04.429Z
7453694 7453694 20250812204302_r9ByO UA0005 2025-08-14T12:02:14.604Z 2025-08-21T12:47:03.709Z
7453673 7453673 20250812204221_7VbqI UA0005 2025-08-14T12:02:08.865Z 2025-08-21T12:47:03.664Z
7453662 7453662 20250812204151_EYr3B UA0005 2025-08-14T12:02:07.574Z 2025-08-21T12:47:03.646Z
7453151 7453151 20250812201624_49Ta6 UA0005 2025-08-14T12:00:51.837Z 2025-08-21T12:47:02.379Z
7447959 7447959 20250812003142_UNxbS UA0005 2025-08-13T12:13:46.155Z 2025-08-20T13:06:00.915Z
7447906 7447906 20250812002901_facMT UA0005 2025-08-13T12:13:30.775Z 2025-08-20T13:06:00.851Z
7447323 7447323 20250812000834_lT40E UA0005 2025-08-13T12:12:36.597Z 2025-08-20T13:05:59.261Z
7447192 7447192 20250812000131_Gqudy UA0005 2025-08-13T12:12:21.697Z 2025-08-20T13:05:58.844Z
7446650 7446650 20250811233321_PYpTS UA0005 2025-08-13T12:11:21.411Z 2025-08-20T13:05:57.332Z
7445194 7445194 20250811223001_dS4Jz UA0005 2025-08-13T12:08:35.581Z 2025-08-20T13:05:53.421Z
7442929 7442929 20250811203403_A93rQ UA0005 2025-08-13T12:02:54.739Z 2025-08-20T13:05:46.547Z
7442793 7442793 20250811202507_ZFxtN UA0005 2025-08-13T12:02:26.748Z 2025-08-20T13:05:46.028Z
7442360 7442360 20250811193757_I8GCk UA0005 2025-08-13T12:00:51.255Z 2025-08-20T13:05:44.155Z
7442220 7442220 20250811191123_v52r2 UA0005 2025-08-13T12:00:23.536Z 2025-08-20T13:05:43.479Z
7406114 7406114 20250808010113_KA3YD UA0005 2025-08-09T12:11:29.856Z 2025-08-16T13:20:29.044Z
7405913 7405913 20250808004021_URQtI UA0005 2025-08-09T12:10:50.857Z 2025-08-16T13:20:26.478Z
7405534 7405534 20250807235839_syXrN UA0005 2025-08-09T12:09:46.793Z 2025-08-16T13:20:19.997Z
7405515 7405515 20250807235646_wi3R2 UA0005 2025-08-09T12:09:44.517Z 2025-08-16T13:20:19.315Z
7405268 7405268 20250807232144_QA1O6 UA0005 2025-08-09T12:08:54.555Z 2025-08-16T13:20:16.433Z
7394355 7394355 20250807005142_YCy16 UA0005 2025-08-08T12:12:28.532Z 2025-08-15T13:36:54.382Z
7393671 7393671 20250806233647_FFrx9 UA0005 2025-08-08T12:10:23.824Z 2025-08-15T13:36:18.330Z
7388441 7388441 20250806003423_TkJAM UA0005 2025-08-07T12:25:33.282Z 2025-08-14T12:58:19.297Z
7387615 7387615 20250806000555_S2wPu UA0005 2025-08-07T12:24:20.424Z 2025-08-14T12:58:06.725Z
7384698 7384698 20250805205813_Rn9PH UA0005 2025-08-07T12:21:33.130Z 2025-08-14T12:57:27.855Z
7376110 7376110 20250805004755_yE2oQ UA0005 2025-08-07T12:11:18.337Z 2025-08-13T12:58:24.400Z

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