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

655 rows where station_code = "IL0008" 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
5807154 5807154 20241215184057_I3T7X IL0008 2024-12-17T14:10:48.502Z 2024-12-23T14:41:46.411Z
5804436 5804436 20241216030303_wBsd3 IL0008 2024-12-17T14:01:35.566Z 2024-12-24T14:35:38.921Z
5804388 5804388 20241216022438_PinCD IL0008 2024-12-17T14:01:25.254Z 2024-12-24T14:35:37.325Z
5804275 5804275 20241216000543_iFAOH IL0008 2024-12-17T14:00:55.645Z 2024-12-24T14:35:30.727Z
5804237 5804237 20241215230702_8RXe4 IL0008 2024-12-17T14:00:44.004Z 2024-12-24T14:35:28.746Z
5796800 5796800 20241215020358_OOHjd IL0008 2024-12-16T14:01:27.429Z 2024-12-23T14:41:32.965Z
5796796 5796796 20241215014027_WMwsP IL0008 2024-12-16T14:01:26.486Z 2024-12-23T14:41:32.668Z
5786538 5786538 20241214013311_R515K IL0008 2024-12-15T14:03:33.965Z 2024-12-22T14:23:27.224Z
5786492 5786492 20241214012803_T5sse IL0008 2024-12-15T14:03:31.969Z 2024-12-22T14:23:26.084Z
5786456 5786456 20241214012506_cP1MV IL0008 2024-12-15T14:03:29.482Z 2024-12-22T14:23:24.151Z
5786276 5786276 20241214010642_pnMD8 IL0008 2024-12-15T14:03:15.265Z 2024-12-22T14:23:12.994Z
5786087 5786087 20241214004043_QR6uy IL0008 2024-12-15T14:03:04.545Z 2024-12-22T14:23:03.834Z
5785946 5785946 20241214002408_s6cZQ IL0008 2024-12-15T14:02:55.944Z 2024-12-22T14:22:59.971Z
5758450 5758450 20241211004713_kPHHX IL0008 2024-12-12T14:01:10.428Z 2024-12-19T14:37:06.476Z
5758197 5758197 20241209215110_2iUZa IL0008 2024-12-11T14:24:03.641Z 2024-12-17T14:33:57.964Z
5757933 5757933 20241209204356_672KU IL0008 2024-12-11T14:23:49.596Z 2024-12-17T14:33:53.982Z
5757285 5757285 20241209170259_YrG9z IL0008 2024-12-11T14:22:35.421Z 2024-12-17T14:33:35.876Z
5750974 5750974 20241210030814_1G6ja IL0008 2024-12-11T14:04:40.441Z 2024-12-18T14:35:33.259Z
5750730 5750730 20241210022217_jXe8y IL0008 2024-12-11T14:03:33.613Z 2024-12-18T14:35:24.789Z
5740231 5740231 20241209031223_3ImYR IL0008 2024-12-10T14:04:21.786Z 2024-12-17T14:31:26.783Z
5739936 5739936 20241209022025_92rDJ IL0008 2024-12-10T14:03:14.034Z 2024-12-17T14:31:20.854Z
5739677 5739677 20241209010708_hRS8a IL0008 2024-12-10T14:02:17.578Z 2024-12-17T14:31:12.683Z
5739620 5739620 20241209005127_iN8i6 IL0008 2024-12-10T14:02:02.520Z 2024-12-17T14:31:11.429Z
5739429 5739429 20241208235243_P97nV IL0008 2024-12-10T14:01:18.922Z 2024-12-17T14:31:05.727Z
5739400 5739400 20241208234449_JSw3w IL0008 2024-12-10T14:01:07.358Z 2024-12-17T14:31:04.732Z
5739291 5739291 20241208232031_FE1nn IL0008 2024-12-10T14:00:34.229Z 2024-12-17T14:31:02.045Z
5739230 5739230 20241208225602_VFIAW IL0008 2024-12-10T14:00:20.274Z 2024-12-17T14:30:58.662Z
5704227 5704227 20241204235942_gP4KG IL0008 2024-12-06T14:29:05.882Z 2024-12-13T14:42:05.996Z
5703943 5703943 20241204220137_wtqFQ IL0008 2024-12-06T14:28:49.596Z 2024-12-13T14:41:59.058Z
5703634 5703634 20241204204536_GYv02 IL0008 2024-12-06T14:28:30.847Z 2024-12-13T14:41:53.742Z
5692166 5692166 20241205031341_yS2J2 IL0008 2024-12-06T14:04:00.450Z 2024-12-14T14:45:40.584Z
5692147 5692147 20241205030727_Sn2j2 IL0008 2024-12-06T14:03:53.977Z 2024-12-14T14:45:40.354Z
5692109 5692109 20241205025337_SOYMv IL0008 2024-12-06T14:03:45.340Z 2024-12-14T14:45:39.865Z
5691616 5691616 20241205003533_IXuaZ IL0008 2024-12-06T14:00:42.424Z 2024-12-14T14:45:31.624Z
5691573 5691573 20241205002214_gNK3H IL0008 2024-12-06T14:00:27.546Z 2024-12-14T14:45:31.064Z
5680618 5680618 20241204025404_TG3QW IL0008 2024-12-05T14:04:50.812Z 2024-12-13T14:40:01.770Z
5667218 5667218 20241201234057_NxX2h IL0008 2024-12-03T14:22:49.736Z 2024-12-10T14:32:41.127Z
5666842 5666842 20241201222523_f3mZK IL0008 2024-12-03T14:22:36.614Z 2024-12-10T14:32:37.024Z
5666648 5666648 20241201214545_grHJN IL0008 2024-12-03T14:22:29.365Z 2024-12-10T14:32:35.845Z
5666330 5666330 20241201201548_25EYT IL0008 2024-12-03T14:22:11.796Z 2024-12-10T14:32:32.143Z
5658557 5658557 20241202014925_4hthS IL0008 2024-12-03T14:01:58.866Z 2024-12-11T14:30:54.393Z
5658533 5658533 20241202014648_MOi1f IL0008 2024-12-03T14:01:52.057Z 2024-12-11T14:30:54.105Z
5657857 5657857 20241201005740_X9aYQ IL0008 2024-12-02T14:23:59.344Z 2024-12-09T14:35:14.473Z
5657238 5657238 20241130233222_1coJL IL0008 2024-12-02T14:23:36.242Z 2024-12-09T14:35:09.728Z
5656542 5656542 20241130214540_r8Z6L IL0008 2024-12-02T14:23:06.193Z 2024-12-09T14:35:04.422Z
5656521 5656521 20241130214111_3s15s IL0008 2024-12-02T14:23:05.195Z 2024-12-09T14:35:04.191Z
5656386 5656386 20241130211308_2ZOpo IL0008 2024-12-02T14:22:57.287Z 2024-12-09T14:35:03.174Z
5647029 5647029 20241201014545_YL5ee IL0008 2024-12-02T14:00:48.788Z 2024-12-10T14:31:31.496Z
5599051 5599051 20241123232116_qYdNs IL0008 2024-11-25T14:16:37.667Z 2024-12-02T14:29:21.103Z
5591468 5591468 20241122231737_nCEXM IL0008 2024-11-24T14:19:54.303Z 2024-12-01T14:25:25.441Z
5590897 5590897 20241122203422_JmAdw IL0008 2024-11-24T14:19:07.553Z 2024-12-01T14:25:24.333Z
5581389 5581389 20241122015941_o7E88 IL0008 2024-11-23T14:20:21.591Z 2024-11-30T14:29:00.401Z
5580806 5580806 20241122011345_i2KqN IL0008 2024-11-23T14:19:42.123Z 2024-11-30T14:28:59.666Z
5580205 5580205 20241122001731_xIBkd IL0008 2024-11-23T14:19:11.196Z 2024-11-30T14:28:58.932Z
5580158 5580158 20241122000754_vEGIO IL0008 2024-11-23T14:19:08.322Z 2024-11-30T14:28:58.865Z
5579758 5579758 20241121231443_e22JI IL0008 2024-11-23T14:18:48.888Z 2024-11-30T14:28:58.181Z
5571930 5571930 20241121010845_AONID IL0008 2024-11-22T14:17:47.509Z 2024-11-29T14:26:46.044Z
5571760 5571760 20241121004127_PMrlH IL0008 2024-11-22T14:17:37.994Z 2024-11-29T14:26:44.810Z
5571537 5571537 20241121000148_loUtB IL0008 2024-11-22T14:17:14.562Z 2024-11-29T14:26:44.053Z
5571458 5571458 20241120234945_bwQke IL0008 2024-11-22T14:17:08.099Z 2024-11-29T14:26:43.922Z
5570950 5570950 20241120214139_wXg7J IL0008 2024-11-22T14:16:13.827Z 2024-11-29T14:26:42.027Z
5570150 5570150 20241120185223_ew3mZ IL0008 2024-11-22T14:14:55.960Z 2024-11-29T14:26:38.478Z
5564535 5564535 20241120030723_o8OOa IL0008 2024-11-21T14:17:47.156Z 2024-11-28T14:29:16.335Z
5564366 5564366 20241120025001_2mj1k IL0008 2024-11-21T14:17:30.843Z 2024-11-28T14:29:16.114Z
5543481 5543481 20241115013913_TNmiA IL0008 2024-11-16T14:06:28.782Z 2024-11-23T14:26:19.130Z
5543327 5543327 20241115001405_cO1EV IL0008 2024-11-16T14:06:05.835Z 2024-11-23T14:26:18.473Z
5537979 5537979 20241113014659_hjO9B IL0008 2024-11-14T14:12:40.992Z 2024-11-21T14:26:18.237Z
5537527 5537527 20241112233045_n3P2m IL0008 2024-11-14T14:12:03.240Z 2024-11-21T14:26:14.010Z
5528630 5528630 20241111220026_QdG3R IL0008 2024-11-13T14:11:11.767Z 2024-11-20T14:25:32.998Z
5516137 5516137 20241109235820_slApE IL0008 2024-11-11T14:12:19.035Z 2024-11-18T14:26:29.682Z
5515876 5515876 20241109230133_L3OrW IL0008 2024-11-11T14:11:40.668Z 2024-11-18T14:26:28.293Z
5515526 5515526 20241109214708_YN129 IL0008 2024-11-11T14:11:10.803Z 2024-11-18T14:26:26.567Z
5510091 5510091 20241109014214_9vm1O IL0008 2024-11-10T14:14:34.630Z 2024-11-17T14:23:52.887Z
5509789 5509789 20241109003526_KGyOd IL0008 2024-11-10T14:14:01.099Z 2024-11-17T14:23:49.200Z
5508955 5508955 20241108205957_zAlgD IL0008 2024-11-10T14:12:09.399Z 2024-11-17T14:23:37.935Z
5508843 5508843 20241108195811_j2uw0 IL0008 2024-11-10T14:11:55.875Z 2024-11-17T14:23:34.591Z
5503979 5503979 20241108003147_fJ3c5 IL0008 2024-11-09T14:13:56.153Z 2024-11-16T14:28:14.569Z
5503712 5503712 20241107233444_2vD7k IL0008 2024-11-09T14:13:39.581Z 2024-11-16T14:28:11.704Z
5503313 5503313 20241107213355_wFjOK IL0008 2024-11-09T14:12:47.453Z 2024-11-16T14:28:05.829Z
5496437 5496437 20241107002625_Dh1n1 IL0008 2024-11-08T14:12:09.785Z 2024-11-15T14:24:57.780Z
5495762 5495762 20241106212614_SDvUB IL0008 2024-11-08T14:10:48.190Z 2024-11-15T14:24:52.948Z
5491139 5491139 20241106020624_VT2Ji IL0008 2024-11-07T14:15:22.412Z 2024-11-14T14:23:24.082Z
5490812 5490812 20241106004544_hj2DK IL0008 2024-11-07T14:14:57.313Z 2024-11-14T14:23:22.494Z
5490643 5490643 20241105235136_8rAxz IL0008 2024-11-07T14:14:22.497Z 2024-11-14T14:23:21.120Z
5490608 5490608 20241105233715_5AOP8 IL0008 2024-11-07T14:14:17.284Z 2024-11-14T14:23:20.933Z
5484334 5484334 20241105023548_G7cFx IL0008 2024-11-06T14:16:49.168Z 2024-11-13T14:27:37.760Z
5483526 5483526 20241105005224_31Gmu IL0008 2024-11-06T14:15:26.784Z 2024-11-13T14:27:36.366Z
5483465 5483465 20241105004402_uR59l IL0008 2024-11-06T14:15:22.818Z 2024-11-13T14:27:36.309Z
5482426 5482426 20241104221111_fm3kz IL0008 2024-11-06T14:13:10.099Z 2024-11-13T14:27:34.551Z
5482307 5482307 20241104214707_RR58u IL0008 2024-11-06T14:12:55.034Z 2024-11-13T14:27:34.320Z
5442183 5442183 20241030004943_s0ip3 IL0008 2024-11-01T12:19:32.377Z 2024-11-07T14:26:45.319Z
5440328 5440328 20241030215752_iWimp IL0008 2024-11-01T12:15:23.299Z 2024-11-08T14:23:08.963Z
5420055 5420055 20241028015257_Yg2G2 IL0008 2024-10-30T12:18:17.451Z 2024-11-05T14:27:14.412Z
5403295 5403295 20241026213729_IdScw IL0008 2024-10-29T12:09:20.178Z 2024-11-04T14:28:48.282Z
5386863 5386863 20241025013509_NwOaq IL0008 2024-10-27T12:20:36.839Z 2024-11-02T12:28:31.671Z
5386521 5386521 20241025005523_qI4HG IL0008 2024-10-27T12:20:09.197Z 2024-11-02T12:28:31.323Z
5386024 5386024 20241024235422_Yi8eA IL0008 2024-10-27T12:19:46.308Z 2024-11-02T12:28:30.588Z
5385945 5385945 20241024234555_I0ey3 IL0008 2024-10-27T12:19:38.675Z 2024-11-02T12:28:30.504Z
5385384 5385384 20241024223516_gGhEg IL0008 2024-10-27T12:18:49.666Z 2024-11-02T12:28:29.691Z
5385317 5385317 20241024222324_hF1XC IL0008 2024-10-27T12:18:44.233Z 2024-11-02T12:28:29.543Z

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