participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
1,029 rows where station_code = "US004J" sorted by created_at descending
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 |
---|---|---|---|---|---|
5505439 | 5505439 | 20241108051809_5Xw2q | US004J | 2024-11-09T14:16:17.660Z | 2024-11-09T14:16:28.784Z |
5505034 | 5505034 | 20241108033851_gvoNf | US004J | 2024-11-09T14:15:37.446Z | 2024-11-09T14:16:28.684Z |
5504723 | 5504723 | 20241108024548_IQxz5 | US004J | 2024-11-09T14:15:06.558Z | 2024-11-09T14:16:28.609Z |
5504307 | 5504307 | 20241108013151_GoKWJ | US004J | 2024-11-09T14:14:24.291Z | 2024-11-09T14:16:28.501Z |
5504098 | 5504098 | 20241108005311_FDbm1 | US004J | 2024-11-09T14:14:04.333Z | 2024-11-09T14:16:28.448Z |
5498608 | 5498608 | 20241108092034_lc1NC | US004J | 2024-11-09T14:01:55.180Z | 2024-11-09T14:01:55.180Z |
5498116 | 5498116 | 20241108070159_sNq64 | US004J | 2024-11-09T14:00:33.302Z | 2024-11-09T14:00:33.302Z |
5498030 | 5498030 | 20241108062757_J78do | US004J | 2024-11-09T14:00:13.261Z | 2024-11-09T14:00:13.261Z |
5497939 | 5497939 | 20241107061351_3zHy3 | US004J | 2024-11-08T14:14:31.361Z | 2024-11-09T14:18:53.873Z |
5497904 | 5497904 | 20241107055802_G0vqa | US004J | 2024-11-08T14:14:29.995Z | 2024-11-09T14:18:53.467Z |
5497890 | 5497890 | 20241107055105_XVIzj | US004J | 2024-11-08T14:14:29.116Z | 2024-11-09T14:18:53.274Z |
5497716 | 5497716 | 20241107044226_dKnGq | US004J | 2024-11-08T14:14:15.555Z | 2024-11-09T14:18:50.981Z |
5496038 | 5496038 | 20241106224442_LqntB | US004J | 2024-11-08T14:11:25.745Z | 2024-11-09T14:18:14.968Z |
5492886 | 5492886 | 20241107101434_go7Q3 | US004J | 2024-11-08T14:02:23.955Z | 2024-11-09T14:16:27.478Z |
5492830 | 5492830 | 20241107100123_8PlhA | US004J | 2024-11-08T14:02:10.585Z | 2024-11-09T14:16:27.463Z |
5492821 | 5492821 | 20241107095956_bjzME | US004J | 2024-11-08T14:02:09.551Z | 2024-11-09T14:16:27.461Z |
5492817 | 5492817 | 20241107095858_No2l8 | US004J | 2024-11-08T14:02:08.862Z | 2024-11-09T14:16:27.460Z |
5492805 | 5492805 | 20241107095745_fplMX | US004J | 2024-11-08T14:02:07.760Z | 2024-11-09T14:16:27.458Z |
5492724 | 5492724 | 20241107094123_tjkUP | US004J | 2024-11-08T14:01:58.230Z | 2024-11-09T14:16:27.437Z |
5492720 | 5492720 | 20241107094047_ljInF | US004J | 2024-11-08T14:01:57.831Z | 2024-11-09T14:16:27.436Z |
5492697 | 5492697 | 20241107093303_kC1Kw | US004J | 2024-11-08T14:01:54.941Z | 2024-11-09T14:16:27.430Z |
5492672 | 5492672 | 20241107093006_lXl9w | US004J | 2024-11-08T14:01:52.293Z | 2024-11-09T14:16:27.426Z |
5492516 | 5492516 | 20241107084711_BJGA2 | US004J | 2024-11-08T14:01:19.853Z | 2024-11-09T14:16:27.390Z |
5492370 | 5492370 | 20241107081731_6wYc7 | US004J | 2024-11-08T14:00:53.551Z | 2024-11-09T14:16:27.356Z |
5492314 | 5492314 | 20241107080713_NAWjC | US004J | 2024-11-08T14:00:45.668Z | 2024-11-09T14:16:27.342Z |
5492297 | 5492297 | 20241107080303_ztNBk | US004J | 2024-11-08T14:00:43.647Z | 2024-11-09T14:16:27.338Z |
5491872 | 5491872 | 20241106054722_Adgae | US004J | 2024-11-07T14:17:15.073Z | 2024-11-09T14:20:15.495Z |
5491815 | 5491815 | 20241106051931_vZSRD | US004J | 2024-11-07T14:17:03.122Z | 2024-11-09T14:20:14.890Z |
5491811 | 5491811 | 20241106051604_VY3Xq | US004J | 2024-11-07T14:17:02.232Z | 2024-11-09T14:20:14.832Z |
5491705 | 5491705 | 20241106043320_sWjwG | US004J | 2024-11-07T14:16:48.809Z | 2024-11-09T14:20:13.277Z |
5491692 | 5491692 | 20241106042903_YDOaX | US004J | 2024-11-07T14:16:46.567Z | 2024-11-09T14:20:13.126Z |
5491574 | 5491574 | 20241106035434_7NL13 | US004J | 2024-11-07T14:16:25.202Z | 2024-11-09T14:20:11.137Z |
5491444 | 5491444 | 20241106031656_IWAM2 | US004J | 2024-11-07T14:16:09.086Z | 2024-11-09T14:20:07.756Z |
5491126 | 5491126 | 20241106020418_hhRNE | US004J | 2024-11-07T14:15:21.126Z | 2024-11-09T14:20:04.272Z |
5490410 | 5490410 | 20241105223706_cuWgr | US004J | 2024-11-07T14:13:59.083Z | 2024-11-09T14:19:54.964Z |
5486185 | 5486185 | 20241106100036_53CIP | US004J | 2024-11-07T14:02:10.357Z | 2024-11-09T14:16:39.306Z |
5485960 | 5485960 | 20241106085449_TILJS | US004J | 2024-11-07T14:01:16.642Z | 2024-11-09T14:16:35.166Z |
5485950 | 5485950 | 20241106085317_a69MF | US004J | 2024-11-07T14:01:14.961Z | 2024-11-09T14:16:35.036Z |
5485761 | 5485761 | 20241106072109_HZ2aJ | US004J | 2024-11-07T14:00:31.093Z | 2024-11-09T14:16:31.807Z |
5485727 | 5485727 | 20241106070109_BvlNO | US004J | 2024-11-07T14:00:24.465Z | 2024-11-09T14:16:31.143Z |
5478811 | 5478811 | 20241104061932_1961T | US004J | 2024-11-05T14:18:52.829Z | 2024-11-09T14:22:31.516Z |
5478785 | 5478785 | 20241104060331_DQawB | US004J | 2024-11-05T14:18:50.400Z | 2024-11-09T14:22:31.396Z |
5478777 | 5478777 | 20241104055911_oZHS9 | US004J | 2024-11-05T14:18:49.364Z | 2024-11-09T14:22:31.303Z |
5478770 | 5478770 | 20241104055411_3EfH6 | US004J | 2024-11-05T14:18:48.570Z | 2024-11-09T14:22:31.259Z |
5478748 | 5478748 | 20241104053811_14CXx | US004J | 2024-11-05T14:18:47.071Z | 2024-11-09T14:22:31.113Z |
5478712 | 5478712 | 20241104051642_5z1hQ | US004J | 2024-11-05T14:18:43.644Z | 2024-11-09T14:22:30.863Z |
5478701 | 5478701 | 20241104051221_3k2Vr | US004J | 2024-11-05T14:18:43.129Z | 2024-11-09T14:22:30.832Z |
5478697 | 5478697 | 20241104051111_O902S | US004J | 2024-11-05T14:18:42.771Z | 2024-11-09T14:22:30.793Z |
5478618 | 5478618 | 20241104044357_WEKAe | US004J | 2024-11-05T14:18:34.660Z | 2024-11-09T14:22:30.251Z |
5478599 | 5478599 | 20241104044128_vipkK | US004J | 2024-11-05T14:18:33.087Z | 2024-11-09T14:22:30.074Z |
5478019 | 5478019 | 20241104030902_onyZ6 | US004J | 2024-11-05T14:17:45.135Z | 2024-11-09T14:22:23.772Z |
5477914 | 5477914 | 20241104025255_ENwTq | US004J | 2024-11-05T14:17:36.016Z | 2024-11-09T14:22:22.885Z |
5477793 | 5477793 | 20241104023622_6Bt1A | US004J | 2024-11-05T14:17:25.580Z | 2024-11-09T14:22:22.006Z |
5477376 | 5477376 | 20241104014427_bOVES | US004J | 2024-11-05T14:16:47.817Z | 2024-11-09T14:22:17.042Z |
5470891 | 5470891 | 20241104100006_WjgQf | US004J | 2024-11-05T14:02:12.472Z | 2024-11-09T14:20:25.596Z |
5470570 | 5470570 | 20241104085015_MAkxh | US004J | 2024-11-05T14:01:06.489Z | 2024-11-09T14:20:21.415Z |
5470309 | 5470309 | 20241104065110_dYBJn | US004J | 2024-11-05T14:00:11.433Z | 2024-11-09T14:20:18.295Z |
5470226 | 5470226 | 20241103064259_pVjcS | US004J | 2024-11-04T14:17:54.855Z | 2024-11-09T14:23:05.970Z |
5469968 | 5469968 | 20241103045526_hKdIh | US004J | 2024-11-04T14:17:27.994Z | 2024-11-09T14:23:04.480Z |
5469443 | 5469443 | 20241103032749_pMr3j | US004J | 2024-11-04T14:16:28.314Z | 2024-11-09T14:23:02.593Z |
5469429 | 5469429 | 20241103032548_bD5DH | US004J | 2024-11-04T14:16:27.130Z | 2024-11-09T14:23:02.548Z |
5469312 | 5469312 | 20241103030914_VCqZ3 | US004J | 2024-11-04T14:16:18.578Z | 2024-11-09T14:23:02.083Z |
5469279 | 5469279 | 20241103030231_cUgu0 | US004J | 2024-11-04T14:16:12.029Z | 2024-11-09T14:23:01.832Z |
5469230 | 5469230 | 20241103025408_COzlt | US004J | 2024-11-04T14:15:59.355Z | 2024-11-09T14:23:01.595Z |
5464922 | 5464922 | 20241103095335_lBIOi | US004J | 2024-11-04T14:02:12.818Z | 2024-11-09T14:21:29.605Z |
5464880 | 5464880 | 20241103094537_mR8RF | US004J | 2024-11-04T14:01:59.307Z | 2024-11-09T14:21:29.484Z |
5464875 | 5464875 | 20241103094354_TCMfu | US004J | 2024-11-04T14:01:58.442Z | 2024-11-09T14:21:29.475Z |
5464778 | 5464778 | 20241103091106_UiA1T | US004J | 2024-11-04T14:01:38.538Z | 2024-11-09T14:21:28.744Z |
5464680 | 5464680 | 20241103085028_VDK6T | US004J | 2024-11-04T14:01:19.593Z | 2024-11-09T14:21:27.585Z |
5464617 | 5464617 | 20241103083236_iEemV | US004J | 2024-11-04T14:01:07.674Z | 2024-11-09T14:21:27.177Z |
5464585 | 5464585 | 20241103082516_8Rv2C | US004J | 2024-11-04T14:01:01.166Z | 2024-11-09T14:21:26.744Z |
5464552 | 5464552 | 20241103081135_bF1mC | US004J | 2024-11-04T14:00:56.191Z | 2024-11-09T14:21:26.546Z |
5464487 | 5464487 | 20241103074214_WITTI | US004J | 2024-11-04T14:00:39.811Z | 2024-11-09T14:21:25.945Z |
5464483 | 5464483 | 20241103073926_uGYYq | US004J | 2024-11-04T14:00:38.764Z | 2024-11-09T14:21:25.921Z |
5464468 | 5464468 | 20241103073159_oMquS | US004J | 2024-11-04T14:00:35.453Z | 2024-11-09T14:21:25.851Z |
5464428 | 5464428 | 20241103071932_4HTpC | US004J | 2024-11-04T14:00:26.985Z | 2024-11-09T14:21:25.406Z |
5464389 | 5464389 | 20241103065827_q6SBo | US004J | 2024-11-04T14:00:17.893Z | 2024-11-09T14:21:25.087Z |
5463903 | 5463903 | 20241102060555_tkJ9U | US004J | 2024-11-03T14:19:23.356Z | 2024-11-09T14:23:44.428Z |
5463549 | 5463549 | 20241102035748_x3pNo | US004J | 2024-11-03T14:18:56.710Z | 2024-11-09T14:23:41.942Z |
5462764 | 5462764 | 20241102012325_qg6Ha | US004J | 2024-11-03T14:18:03.779Z | 2024-11-09T14:23:36.048Z |
5462611 | 5462611 | 20241102005319_pFqD7 | US004J | 2024-11-03T14:17:47.191Z | 2024-11-09T14:23:34.748Z |
5462311 | 5462311 | 20241101234428_BWvfV | US004J | 2024-11-03T14:17:13.873Z | 2024-11-09T14:23:33.670Z |
5455701 | 5455701 | 20241102090012_WHP7N | US004J | 2024-11-03T14:01:58.731Z | 2024-11-09T14:22:38.213Z |
5455687 | 5455687 | 20241102085635_VFpjo | US004J | 2024-11-03T14:01:55.636Z | 2024-11-09T14:22:38.021Z |
5451191 | 5451191 | 20241031230131_l1OIj | US004J | 2024-11-02T12:16:42.237Z | 2024-11-09T14:24:22.141Z |
5451128 | 5451128 | 20241031224449_m7PuQ | US004J | 2024-11-02T12:16:37.894Z | 2024-11-09T14:24:21.696Z |
5445852 | 5445852 | 20241031085506_sLTH4 | US004J | 2024-11-02T12:03:23.120Z | 2024-11-09T14:23:51.703Z |
5445213 | 5445213 | 20241031071921_9EkCE | US004J | 2024-11-02T12:01:20.118Z | 2024-11-09T14:23:48.484Z |
5432003 | 5432003 | 20241029022901_7sX01 | US004J | 2024-10-31T12:20:55.940Z | 2024-11-06T14:27:25.684Z |
5431815 | 5431815 | 20241029020133_rDfxR | US004J | 2024-10-31T12:20:41.830Z | 2024-11-06T14:27:24.933Z |
5431453 | 5431453 | 20241029011446_GqVhu | US004J | 2024-10-31T12:20:10.171Z | 2024-11-06T14:27:23.768Z |
5421365 | 5421365 | 20241028060723_Ue1mj | US004J | 2024-10-30T12:19:52.648Z | 2024-11-05T14:27:18.382Z |
5421359 | 5421359 | 20241028060700_hpR7d | US004J | 2024-10-30T12:19:52.523Z | 2024-11-05T14:27:18.379Z |
5421349 | 5421349 | 20241028060338_TkcIA | US004J | 2024-10-30T12:19:52.307Z | 2024-11-05T14:27:18.308Z |
5421299 | 5421299 | 20241028053710_69oLz | US004J | 2024-10-30T12:19:48.537Z | 2024-11-05T14:27:18.088Z |
5421289 | 5421289 | 20241028053434_3PoRN | US004J | 2024-10-30T12:19:47.761Z | 2024-11-05T14:27:18.074Z |
5420989 | 5420989 | 20241028040925_18sKX | US004J | 2024-10-30T12:19:31.155Z | 2024-11-05T14:27:16.891Z |
5420822 | 5420822 | 20241028034042_2DD8x | US004J | 2024-10-30T12:19:20.716Z | 2024-11-05T14:27:16.465Z |
5420630 | 5420630 | 20241028030937_M2Feb | US004J | 2024-10-30T12:19:05.634Z | 2024-11-05T14:27:15.945Z |
5419731 | 5419731 | 20241028005810_lC8GQ | US004J | 2024-10-30T12:17:48.875Z | 2024-11-05T14:27:13.820Z |
Advanced export
JSON shape: default, array, newline-delimited
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);