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

5,553 rows where station_code = "IL0002" 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
8681403 8681403 20251203030519_BUSc2 IL0002 2025-12-04T14:14:39.360Z 2025-12-05T14:21:35.695Z
8681311 8681311 20251203025604_DvJkW IL0002 2025-12-04T14:14:27.624Z 2025-12-05T14:21:32.057Z
8681101 8681101 20251203022335_3L0xc IL0002 2025-12-04T14:13:50.964Z 2025-12-05T14:21:16.439Z
8681085 8681085 20251203022003_f3Izg IL0002 2025-12-04T14:13:48.052Z 2025-12-05T14:21:15.564Z
8681013 8681013 20251203021304_wy2T9 IL0002 2025-12-04T14:13:33.512Z 2025-12-05T14:21:11.184Z
8674571 8674571 20251202025113_23K8Q IL0002 2025-12-03T14:22:01.907Z 2025-12-05T14:27:56.291Z
8674139 8674139 20251202013227_OHkPy IL0002 2025-12-03T14:20:59.369Z 2025-12-05T14:27:30.202Z
8673968 8673968 20251202005257_iaJbu IL0002 2025-12-03T14:20:26.835Z 2025-12-05T14:27:24.200Z
8673398 8673398 20251201185510_2S4oO IL0002 2025-12-03T14:18:45.475Z 2025-12-05T14:26:36.313Z
8664583 8664583 20251201010032_BOD2h IL0002 2025-12-02T14:21:34.064Z 2025-12-05T14:35:09.263Z
8633417 8633417 20251127231634_VuwUO IL0002 2025-11-29T14:19:42.260Z 2025-12-05T14:57:37.078Z
8632129 8632129 20251127203350_QX4cD IL0002 2025-11-29T14:17:02.520Z 2025-12-05T14:56:16.172Z
8623686 8623686 20251127014351_sLn9p IL0002 2025-11-28T14:22:24.964Z 2025-12-05T15:04:09.403Z
8623435 8623435 20251127003703_6E3nP IL0002 2025-11-28T14:21:44.732Z 2025-12-05T15:03:53.443Z
8623279 8623279 20251126234120_YhVPx IL0002 2025-11-28T14:21:26.750Z 2025-12-05T15:03:41.569Z
8623190 8623190 20251126231631_LfzNE IL0002 2025-11-28T14:21:03.724Z 2025-12-05T15:03:37.799Z
8535764 8535764 20251120025624_Yv3Bx IL0002 2025-11-21T14:16:56.371Z 2025-11-28T14:57:00.991Z
8533982 8533982 20251119211802_3Tm4P IL0002 2025-11-21T14:12:43.481Z 2025-11-28T14:55:25.929Z
8522024 8522024 20251118231059_fy0Pp IL0002 2025-11-20T14:14:17.950Z 2025-11-27T15:11:53.504Z
8519597 8519597 20251118173727_5Uepv IL0002 2025-11-20T14:07:18.842Z 2025-11-27T15:11:27.978Z
8509481 8509481 20251118025116_iE1Hw IL0002 2025-11-19T14:19:47.970Z 2025-11-26T15:07:56.095Z
8508954 8508954 20251118015108_22JCG IL0002 2025-11-19T14:18:35.229Z 2025-11-26T15:07:53.096Z
8508279 8508279 20251118004809_1rQ5f IL0002 2025-11-19T14:17:18.355Z 2025-11-26T15:07:50.151Z
8508272 8508272 20251118004754_7igEy IL0002 2025-11-19T14:17:17.948Z 2025-11-26T15:07:50.095Z
8508270 8508270 20251118004659_7rD5I IL0002 2025-11-19T14:17:17.567Z 2025-11-26T15:07:50.086Z
8507473 8507473 20251117232458_x4wwB IL0002 2025-11-19T14:15:22.201Z 2025-11-26T15:07:46.679Z
8507287 8507287 20251117230450_ZWvDQ IL0002 2025-11-19T14:14:53.190Z 2025-11-26T15:07:45.607Z
8506825 8506825 20251117221903_yWJT2 IL0002 2025-11-19T14:13:43.610Z 2025-11-26T15:07:43.575Z
8505066 8505066 20251117194405_NBb7p IL0002 2025-11-19T14:09:27.968Z 2025-11-26T15:07:36.801Z
8504910 8504910 20251117193342_dC2Aq IL0002 2025-11-19T14:09:02.791Z 2025-11-26T15:07:34.879Z
8493705 8493705 20251117020026_IL2kt IL0002 2025-11-18T14:22:51.148Z 2025-11-25T15:09:21.638Z
8493460 8493460 20251117014409_DedUe IL0002 2025-11-18T14:22:19.670Z 2025-11-25T15:09:18.004Z
8492274 8492274 20251117001350_oyii5 IL0002 2025-11-18T14:19:29.130Z 2025-11-25T15:08:46.979Z
8491314 8491314 20251116221331_embKr IL0002 2025-11-18T14:17:03.373Z 2025-11-25T15:08:36.541Z
8467863 8467863 20251114213153_I8JdT IL0002 2025-11-16T14:15:51.102Z 2025-11-23T15:17:12.387Z
8467693 8467693 20251114204928_Njl57 IL0002 2025-11-16T14:15:16.250Z 2025-11-23T15:17:10.908Z
8456951 8456951 20251113193448_bsKFD IL0002 2025-11-15T14:12:29.967Z 2025-11-22T15:20:47.983Z
8333929 8333929 20251031010412_Ud92I IL0002 2025-11-02T14:23:51.224Z 2025-11-08T15:13:03.693Z
8333584 8333584 20251031002649_UzQBD IL0002 2025-11-02T14:22:54.154Z 2025-11-08T15:12:56.539Z
8332540 8332540 20251030221927_tqOp9 IL0002 2025-11-02T14:20:19.394Z 2025-11-08T15:12:39.487Z
8279919 8279919 20251027223509_oDMkm IL0002 2025-10-29T12:38:17.283Z 2025-11-05T15:20:51.373Z
8279754 8279754 20251027221206_zPMyO IL0002 2025-10-29T12:38:03.206Z 2025-11-05T15:20:48.917Z
8252818 8252818 20251027015222_Iv0oM IL0002 2025-10-28T12:16:14.815Z 2025-11-04T15:43:09.247Z
8252770 8252770 20251027014353_McAJb IL0002 2025-10-28T12:15:59.112Z 2025-11-04T15:42:57.840Z
8252457 8252457 20251027005339_dmkw2 IL0002 2025-10-28T12:15:13.376Z 2025-11-04T15:42:46.803Z
8251576 8251576 20251026215609_n1KzF IL0002 2025-10-28T12:12:03.909Z 2025-11-04T15:41:47.309Z
8240896 8240896 20251025015815_rMAMR IL0002 2025-10-27T12:32:13.056Z 2025-11-02T15:05:30.176Z
8239502 8239502 20251025003802_UJHmF IL0002 2025-10-27T12:30:21.887Z 2025-11-02T15:05:24.723Z
8238631 8238631 20251024234556_Wr27f IL0002 2025-10-27T12:28:57.265Z 2025-11-02T15:05:22.045Z
8238465 8238465 20251024233730_iUmxF IL0002 2025-10-27T12:28:28.003Z 2025-11-02T15:05:21.640Z
8238377 8238377 20251024233333_7Cbw0 IL0002 2025-10-27T12:28:18.868Z 2025-11-02T15:05:21.018Z
8236543 8236543 20251024203408_VZgC2 IL0002 2025-10-27T12:24:29.234Z 2025-11-02T15:05:12.248Z
8235462 8235462 20251026003311_CYknd IL0002 2025-10-27T12:17:52.611Z 2025-11-03T15:16:08.960Z
8235339 8235339 20251026002935_IAHDX IL0002 2025-10-27T12:17:27.819Z 2025-11-03T15:16:08.694Z
8232911 8232911 20251025220450_hU1Nh IL0002 2025-10-27T12:12:09.139Z 2025-11-03T15:15:53.895Z
8231843 8231843 20251025193519_oZFyW IL0002 2025-10-27T12:09:06.030Z 2025-11-03T15:15:48.086Z
8217833 8217833 20251024024604_4VpFK IL0002 2025-10-26T12:34:19.128Z 2025-11-01T13:10:46.341Z
8191178 8191178 20251022011804_9xq8t IL0002 2025-10-24T12:23:25.875Z 2025-10-30T13:13:10.502Z
8190873 8190873 20251022005116_axS0K IL0002 2025-10-24T12:22:44.901Z 2025-10-30T13:13:08.955Z
8190864 8190864 20251022005009_C3RNe IL0002 2025-10-24T12:22:43.738Z 2025-10-30T13:13:08.946Z
8189756 8189756 20251023011933_LEtJk IL0002 2025-10-24T12:09:35.095Z 2025-10-31T13:08:35.580Z
8189673 8189673 20251023001457_Ok2n6 IL0002 2025-10-24T12:09:08.076Z 2025-10-31T13:08:27.425Z
8189669 8189669 20251023001239_c93l2 IL0002 2025-10-24T12:09:07.381Z 2025-10-31T13:08:27.414Z
8189641 8189641 20251022234055_4wQbI IL0002 2025-10-24T12:09:01.654Z 2025-10-31T13:08:26.611Z
8189612 8189612 20251022231103_7ceXa IL0002 2025-10-24T12:08:55.937Z 2025-10-31T13:08:26.257Z
8189608 8189608 20251022230105_fB7eJ IL0002 2025-10-24T12:08:55.193Z 2025-10-31T13:08:25.932Z
8189606 8189606 20251022225949_XehHM IL0002 2025-10-24T12:08:54.774Z 2025-10-31T13:08:25.931Z
8189579 8189579 20251022221028_g0GXt IL0002 2025-10-24T12:08:35.263Z 2025-10-31T13:08:23.893Z
8189546 8189546 20251022211902_OE7fE IL0002 2025-10-24T12:08:24.509Z 2025-10-31T13:08:19.192Z
8180880 8180880 20251021235050_JxaCJ IL0002 2025-10-23T12:19:23.986Z 2025-10-30T13:13:03.831Z
8180699 8180699 20251021233539_6LLLI IL0002 2025-10-23T12:18:58.679Z 2025-10-30T13:13:02.846Z
8180635 8180635 20251021233019_AhzPY IL0002 2025-10-23T12:18:50.854Z 2025-10-30T13:13:02.505Z
8180399 8180399 20251021231018_aQJZK IL0002 2025-10-23T12:18:18.014Z 2025-10-30T13:13:00.145Z
8180318 8180318 20251021225654_90mqI IL0002 2025-10-23T12:18:10.025Z 2025-10-30T13:12:59.488Z
8179757 8179757 20251021220143_65fUZ IL0002 2025-10-23T12:17:02.041Z 2025-10-30T13:12:56.130Z
8178776 8178776 20251021200501_GsYU5 IL0002 2025-10-23T12:14:34.027Z 2025-10-30T13:12:48.647Z
8162983 8162983 20251021014132_4wvKh IL0002 2025-10-22T12:16:30.073Z 2025-10-29T13:07:15.582Z
8162276 8162276 20251020235157_aKUsm IL0002 2025-10-22T12:14:10.896Z 2025-10-29T13:07:07.833Z
8162067 8162067 20251020231309_Tt1k3 IL0002 2025-10-22T12:13:33.527Z 2025-10-29T13:07:06.641Z
8162019 8162019 20251020225526_0LqIw IL0002 2025-10-22T12:13:26.233Z 2025-10-29T13:07:06.279Z
8161350 8161350 20251020193623_HjbEL IL0002 2025-10-22T12:10:18.795Z 2025-10-29T13:06:59.424Z
8160937 8160937 20251020172501_7MCgJ IL0002 2025-10-22T12:08:18.104Z 2025-10-29T13:06:53.590Z
8156225 8156225 20251020003620_tnf38 IL0002 2025-10-21T12:15:10.026Z 2025-10-28T13:08:18.521Z
8156203 8156203 20251020003127_97dFX IL0002 2025-10-21T12:15:06.686Z 2025-10-28T13:08:17.968Z
8141808 8141808 20251018194814_afHSb IL0002 2025-10-20T12:08:46.365Z 2025-10-27T13:09:45.139Z
8078125 8078125 20251009232729_v8bR1 IL0002 2025-10-11T12:07:23.434Z 2025-10-18T12:59:56.332Z
8050447 8050447 20251003002912_nPf73 IL0002 2025-10-04T12:41:29.670Z 2025-10-11T12:40:22.231Z
8037952 8037952 20251001191747_gYdAR IL0002 2025-10-03T12:28:13.641Z 2025-10-10T12:39:21.011Z
8029020 8029020 20251001012746_59boX IL0002 2025-10-02T12:28:12.866Z 2025-10-09T12:39:12.130Z
8029018 8029018 20251001012118_Z316j IL0002 2025-10-02T12:28:12.276Z 2025-10-09T12:39:11.375Z
8017779 8017779 20250930010505_QBXZ3 IL0002 2025-10-01T12:27:01.702Z 2025-10-08T12:43:12.041Z
7905155 7905155 20250920230719_idUkw IL0002 2025-09-22T12:34:27.331Z 2025-09-29T13:05:19.003Z
7904967 7904967 20250920225032_ZsBb3 IL0002 2025-09-22T12:34:13.086Z 2025-09-29T13:05:17.933Z
7896284 7896284 20250920004645_z3ypg IL0002 2025-09-21T12:39:44.440Z 2025-09-28T12:54:48.983Z
7895769 7895769 20250920001131_fS0Jf IL0002 2025-09-21T12:39:18.463Z 2025-09-28T12:54:44.209Z
7895536 7895536 20250919235417_CB7X3 IL0002 2025-09-21T12:38:49.387Z 2025-09-28T12:54:41.662Z
7883879 7883879 20250920014449_HOTxF IL0002 2025-09-21T12:01:16.879Z 2025-09-29T13:02:39.505Z
7864070 7864070 20250916233136_TBgqX IL0002 2025-09-18T12:35:59.467Z 2025-09-24T13:17:45.777Z
7856558 7856558 20250917001958_bMwJK IL0002 2025-09-18T12:01:25.286Z 2025-09-25T13:10:30.473Z
7704402 7704402 20250830004658_Ij2AX IL0002 2025-08-31T12:24:38.190Z 2025-09-07T12:58:26.856Z

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