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

9,358 rows where station_code = "IE0004" 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
9608688 9608688 20260404004459_3XJ50 IE0004 2026-04-05T12:11:18.037Z 2026-04-06T12:20:30.849Z
9608272 9608272 20260403212845_daQXC IE0004 2026-04-05T12:09:52.658Z 2026-04-06T12:20:03.079Z
9604919 9604919 20260402015950_iX3f2 IE0004 2026-04-03T12:12:11.548Z 2026-04-06T12:26:32.283Z
9602680 9602680 20260402023311_eOymr IE0004 2026-04-03T12:00:12.120Z 2026-04-06T12:21:01.686Z
9595195 9595195 20260330030209_v6KLB IE0004 2026-03-31T12:00:46.580Z 2026-04-06T12:29:47.929Z
9595073 9595073 20260330021434_l32IR IE0004 2026-03-31T12:00:23.873Z 2026-04-06T12:29:39.314Z
9592136 9592136 20260328005627_YfDIl IE0004 2026-03-29T12:07:12.838Z 2026-04-05T12:35:38.440Z
9591934 9591934 20260327231700_YQPAv IE0004 2026-03-29T12:07:00.133Z 2026-04-05T12:35:21.496Z
9591866 9591866 20260327225400_2vrCG IE0004 2026-03-29T12:06:53.303Z 2026-04-05T12:35:18.137Z
9591769 9591769 20260327205226_tWLHj IE0004 2026-03-29T12:06:43.226Z 2026-04-05T12:35:12.795Z
9590067 9590067 20260328044527_5XNmL IE0004 2026-03-29T12:01:56.802Z 2026-04-06T12:37:49.185Z
9589940 9589940 20260328042259_1Wwp8 IE0004 2026-03-29T12:01:46.597Z 2026-04-06T12:37:39.011Z
9589856 9589856 20260328041138_4fAME IE0004 2026-03-29T12:01:40.510Z 2026-04-06T12:37:36.356Z
9589804 9589804 20260328040906_KIy3m IE0004 2026-03-29T12:01:39.059Z 2026-04-06T12:37:35.507Z
9589671 9589671 20260328035906_SO7di IE0004 2026-03-29T12:01:33.578Z 2026-04-06T12:37:31.405Z
9589476 9589476 20260328033503_BxrgB IE0004 2026-03-29T12:01:19.606Z 2026-04-06T12:37:25.492Z
9589139 9589139 20260328023159_KrNB7 IE0004 2026-03-29T12:00:45.590Z 2026-04-06T12:37:02.860Z
9588766 9588766 20260328011057_Dangg IE0004 2026-03-29T12:00:12.742Z 2026-04-06T12:36:50.541Z
9584616 9584616 20260325211036_O86y1 IE0004 2026-03-27T12:15:50.316Z 2026-04-03T12:39:24.368Z
9581541 9581541 20260326033021_6ux4t IE0004 2026-03-27T12:03:24.212Z 2026-04-04T12:39:10.480Z
9581355 9581355 20260326025923_L7LT6 IE0004 2026-03-27T12:02:50.560Z 2026-04-04T12:38:54.081Z
9580726 9580726 20260326012243_wMQrC IE0004 2026-03-27T12:01:15.818Z 2026-04-04T12:38:21.681Z
9580669 9580669 20260326011457_wfDbY IE0004 2026-03-27T12:01:08.057Z 2026-04-04T12:38:20.329Z
9580614 9580614 20260326010942_vgC8N IE0004 2026-03-27T12:00:58.009Z 2026-04-04T12:38:18.440Z
9580611 9580611 20260326010820_lfmlc IE0004 2026-03-27T12:00:57.262Z 2026-04-04T12:38:18.168Z
9577319 9577319 20260325045414_pLOGD IE0004 2026-03-26T12:04:46.503Z 2026-04-03T12:36:56.615Z
9577282 9577282 20260325043731_2ukP2 IE0004 2026-03-26T12:04:39.564Z 2026-04-03T12:36:54.924Z
9577280 9577280 20260325043528_ui4zg IE0004 2026-03-26T12:04:39.042Z 2026-04-03T12:36:54.765Z
9577259 9577259 20260325042945_62HbP IE0004 2026-03-26T12:04:34.352Z 2026-04-03T12:36:53.671Z
9457780 9457780 20260311053257_8FR2I IE0004 2026-03-12T12:04:34.884Z 2026-03-19T12:44:52.048Z
9457552 9457552 20260311041523_q22wp IE0004 2026-03-12T12:04:03.089Z 2026-03-19T12:44:47.056Z
9457300 9457300 20260311032551_UpsQH IE0004 2026-03-12T12:03:30.923Z 2026-03-19T12:44:37.001Z
9442711 9442711 20260308051853_bqK7H IE0004 2026-03-09T12:05:11.877Z 2026-03-16T12:43:55.435Z
9442661 9442661 20260308044511_IuC2R IE0004 2026-03-09T12:04:55.116Z 2026-03-16T12:43:54.623Z
9442431 9442431 20260308033439_A7lHi IE0004 2026-03-09T12:04:00.261Z 2026-03-16T12:43:51.402Z
9442343 9442343 20260308030940_jysAb IE0004 2026-03-09T12:03:36.668Z 2026-03-16T12:43:50.065Z
9441153 9441153 20260306201108_u33Dd IE0004 2026-03-08T12:20:38.025Z 2026-03-14T12:40:45.817Z
9441127 9441127 20260306200138_u6d76 IE0004 2026-03-08T12:20:33.494Z 2026-03-14T12:40:45.200Z
9437531 9437531 20260307043001_xNBuo IE0004 2026-03-08T12:04:25.553Z 2026-03-15T12:41:08.863Z
9437517 9437517 20260307042555_iCiH7 IE0004 2026-03-08T12:04:21.485Z 2026-03-15T12:41:08.607Z
9437498 9437498 20260307040939_p3ukP IE0004 2026-03-08T12:04:15.028Z 2026-03-15T12:41:08.344Z
9437119 9437119 20260307015907_WQxnN IE0004 2026-03-08T12:02:40.233Z 2026-03-15T12:41:02.378Z
9437006 9437006 20260307011259_XcG4P IE0004 2026-03-08T12:02:13.401Z 2026-03-15T12:41:00.749Z
9436957 9436957 20260307005228_lG82T IE0004 2026-03-08T12:02:01.115Z 2026-03-15T12:41:00.028Z
9436635 9436635 20260306230555_vehS3 IE0004 2026-03-08T12:00:30.043Z 2026-03-15T12:40:55.666Z
9432402 9432402 20260306055152_6M33S IE0004 2026-03-07T14:04:37.161Z 2026-03-14T12:39:29.858Z
9432375 9432375 20260306053117_TkFYu IE0004 2026-03-07T14:04:30.040Z 2026-03-14T12:39:29.301Z
9432371 9432371 20260306052840_C0WDp IE0004 2026-03-07T14:04:29.014Z 2026-03-14T12:39:29.240Z
9432310 9432310 20260306042616_U10X6 IE0004 2026-03-07T14:04:13.681Z 2026-03-14T12:39:28.383Z
9432136 9432136 20260306034043_CrAs2 IE0004 2026-03-07T14:03:35.251Z 2026-03-14T12:39:25.673Z
9432121 9432121 20260306033407_H2BA3 IE0004 2026-03-07T14:03:29.011Z 2026-03-14T12:39:25.416Z
9409698 9409698 20260228042314_RvxUS IE0004 2026-03-01T14:02:03.885Z 2026-03-08T12:41:28.003Z
9409688 9409688 20260228041945_n3ZgN IE0004 2026-03-01T14:02:00.650Z 2026-03-08T12:41:27.411Z
9409680 9409680 20260228041725_x87QT IE0004 2026-03-01T14:02:00.112Z 2026-03-08T12:41:27.164Z
9409671 9409671 20260228041125_FPORL IE0004 2026-03-01T14:01:58.899Z 2026-03-08T12:41:26.752Z
9409644 9409644 20260228040827_jfEy5 IE0004 2026-03-01T14:01:56.801Z 2026-03-08T12:41:25.867Z
9409036 9409036 20260228004731_Mgfc9 IE0004 2026-03-01T14:00:32.415Z 2026-03-08T12:40:52.749Z
9340457 9340457 20260217001345_ROpL3 IE0004 2026-02-18T14:24:56.063Z 2026-02-25T14:42:54.502Z
9340359 9340359 20260216235519_8eeHB IE0004 2026-02-18T14:24:43.260Z 2026-02-25T14:42:53.616Z
9340272 9340272 20260216233529_lzv25 IE0004 2026-02-18T14:24:28.581Z 2026-02-25T14:42:52.861Z
9340174 9340174 20260216231124_VmeqZ IE0004 2026-02-18T14:24:12.224Z 2026-02-25T14:42:51.597Z
9340088 9340088 20260216225348_bgZTY IE0004 2026-02-18T14:24:00.214Z 2026-02-25T14:42:50.993Z
9340073 9340073 20260216224904_KDRan IE0004 2026-02-18T14:23:57.004Z 2026-02-25T14:42:50.302Z
9340001 9340001 20260216223012_dShl2 IE0004 2026-02-18T14:23:44.969Z 2026-02-25T14:42:49.648Z
9339922 9339922 20260216220137_ZPx2b IE0004 2026-02-18T14:23:29.888Z 2026-02-25T14:42:48.338Z
9339806 9339806 20260216211105_623oL IE0004 2026-02-18T14:23:04.986Z 2026-02-25T14:42:46.670Z
9339769 9339769 20260216210830_FZZCP IE0004 2026-02-18T14:23:00.946Z 2026-02-25T14:42:46.422Z
9339686 9339686 20260216202835_mCl8h IE0004 2026-02-18T14:22:26.207Z 2026-02-25T14:42:44.567Z
9339612 9339612 20260216195022_8Fqnx IE0004 2026-02-18T14:21:48.319Z 2026-02-25T14:42:42.962Z
9339508 9339508 20260216191905_dsGzx IE0004 2026-02-18T14:21:15.806Z 2026-02-25T14:42:40.980Z
9336918 9336918 20260217044417_mV2Se IE0004 2026-02-18T14:05:51.791Z 2026-02-26T14:39:22.729Z
9336694 9336694 20260217042046_ygElf IE0004 2026-02-18T14:05:10.396Z 2026-02-26T14:39:20.597Z
9336657 9336657 20260217041933_NaHth IE0004 2026-02-18T14:05:07.726Z 2026-02-26T14:39:20.463Z
9336545 9336545 20260217040139_3Ksso IE0004 2026-02-18T14:04:41.640Z 2026-02-26T14:39:19.329Z
9336464 9336464 20260217035253_jnrXm IE0004 2026-02-18T14:04:27.537Z 2026-02-26T14:39:18.745Z
9336455 9336455 20260217035251_aU8Zp IE0004 2026-02-18T14:04:26.883Z 2026-02-26T14:39:18.699Z
9336400 9336400 20260217034929_X2BdO IE0004 2026-02-18T14:04:20.867Z 2026-02-26T14:39:18.410Z
9336290 9336290 20260217033834_nvdB0 IE0004 2026-02-18T14:04:00.596Z 2026-02-26T14:39:17.434Z
9336147 9336147 20260217031652_M9AUi IE0004 2026-02-18T14:03:30.751Z 2026-02-26T14:39:16.224Z
9336071 9336071 20260217030734_o2hpR IE0004 2026-02-18T14:03:16.212Z 2026-02-26T14:39:14.939Z
9336010 9336010 20260217025838_uNMqE IE0004 2026-02-18T14:03:01.608Z 2026-02-26T14:39:05.290Z
9335980 9335980 20260217025802_gNmmh IE0004 2026-02-18T14:02:57.470Z 2026-02-26T14:39:01.519Z
9335953 9335953 20260217025558_TA4pG IE0004 2026-02-18T14:02:52.288Z 2026-02-26T14:39:00.184Z
9335947 9335947 20260217025414_x2Hqq IE0004 2026-02-18T14:02:50.144Z 2026-02-26T14:38:59.799Z
9335912 9335912 20260217025003_z0573 IE0004 2026-02-18T14:02:41.567Z 2026-02-26T14:38:59.503Z
9335837 9335837 20260217024239_Q21yF IE0004 2026-02-18T14:02:28.706Z 2026-02-26T14:38:58.869Z
9335713 9335713 20260217023206_Spp0a IE0004 2026-02-18T14:02:06.756Z 2026-02-26T14:38:58.116Z
9335572 9335572 20260217020958_WdIp7 IE0004 2026-02-18T14:01:33.652Z 2026-02-26T14:38:56.183Z
9335486 9335486 20260217015109_n0f8T IE0004 2026-02-18T14:01:13.655Z 2026-02-26T14:38:55.119Z
9335286 9335286 20260217011931_EWhTz IE0004 2026-02-18T14:00:38.315Z 2026-02-26T14:38:52.762Z
9334821 9334821 20260215231230_9SLmx IE0004 2026-02-17T14:25:24.494Z 2026-02-24T14:43:18.167Z
9334340 9334340 20260215213303_5zsUk IE0004 2026-02-17T14:23:56.095Z 2026-02-24T14:43:07.764Z
9333891 9333891 20260215184851_gZ3fj IE0004 2026-02-17T14:22:11.559Z 2026-02-24T14:42:52.130Z
9331409 9331409 20260216051513_vNQw1 IE0004 2026-02-17T14:06:28.764Z 2026-02-25T14:41:56.359Z
9331259 9331259 20260216043732_EE7bw IE0004 2026-02-17T14:05:42.625Z 2026-02-25T14:41:51.661Z
9331250 9331250 20260216043559_qfV1P IE0004 2026-02-17T14:05:39.092Z 2026-02-25T14:41:50.947Z
9331238 9331238 20260216043013_OFj0m IE0004 2026-02-17T14:05:34.276Z 2026-02-25T14:41:45.010Z
9330928 9330928 20260216031640_2j0Mj IE0004 2026-02-17T14:03:45.376Z 2026-02-25T14:41:35.411Z
9330897 9330897 20260216030346_kWDob IE0004 2026-02-17T14:03:31.439Z 2026-02-25T14:41:33.580Z
9330883 9330883 20260216030222_9j3lS IE0004 2026-02-17T14:03:27.277Z 2026-02-25T14:41:33.416Z

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