participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
5,306 rows where station_code = "IE0004" 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 |
---|---|---|---|---|---|
5524058 | 5524058 | 20241111030700_hL3bC | IE0004 | 2024-11-12T14:16:29.988Z | 2024-11-12T14:18:08.451Z |
5523889 | 5523889 | 20241111024359_CRZFa | IE0004 | 2024-11-12T14:16:19.141Z | 2024-11-12T14:18:08.387Z |
5523833 | 5523833 | 20241111023210_fe9B3 | IE0004 | 2024-11-12T14:16:16.171Z | 2024-11-12T14:18:08.364Z |
5523821 | 5523821 | 20241111022928_3Yn2X | IE0004 | 2024-11-12T14:16:15.611Z | 2024-11-12T14:18:08.360Z |
5523670 | 5523670 | 20241111020326_GC2pD | IE0004 | 2024-11-12T14:16:06.911Z | 2024-11-12T14:18:08.297Z |
5522607 | 5522607 | 20241110204404_zPSL8 | IE0004 | 2024-11-12T14:13:45.663Z | 2024-11-12T14:18:07.823Z |
5429552 | 5429552 | 20241028193428_RhUiX | IE0004 | 2024-10-31T12:16:45.654Z | 2024-11-06T14:27:16.587Z |
5410709 | 5410709 | 20241027053054_BwOEC | IE0004 | 2024-10-29T12:18:03.157Z | 2024-11-04T14:29:05.285Z |
5410678 | 5410678 | 20241027052755_rMIxt | IE0004 | 2024-10-29T12:18:02.338Z | 2024-11-04T14:29:05.212Z |
5410239 | 5410239 | 20241027050234_4umfj | IE0004 | 2024-10-29T12:17:51.307Z | 2024-11-04T14:29:04.239Z |
5409603 | 5409603 | 20241027042808_Qpgc7 | IE0004 | 2024-10-29T12:17:32.939Z | 2024-11-04T14:29:02.007Z |
5409523 | 5409523 | 20241027042329_wiHUZ | IE0004 | 2024-10-29T12:17:28.485Z | 2024-11-04T14:29:01.938Z |
5409165 | 5409165 | 20241027040355_02mPc | IE0004 | 2024-10-29T12:17:09.544Z | 2024-11-04T14:29:01.235Z |
5408971 | 5408971 | 20241027035141_YSaAm | IE0004 | 2024-10-29T12:16:58.777Z | 2024-11-04T14:29:00.881Z |
5408782 | 5408782 | 20241027034330_1VmU3 | IE0004 | 2024-10-29T12:16:51.328Z | 2024-11-04T14:29:00.537Z |
5408663 | 5408663 | 20241027033457_w1Cgs | IE0004 | 2024-10-29T12:16:43.315Z | 2024-11-04T14:28:59.812Z |
5408599 | 5408599 | 20241027033122_UIF1P | IE0004 | 2024-10-29T12:16:38.868Z | 2024-11-04T14:28:59.671Z |
5408297 | 5408297 | 20241027032207_Qopv8 | IE0004 | 2024-10-29T12:16:21.841Z | 2024-11-04T14:28:59.069Z |
5407376 | 5407376 | 20241027023423_05cST | IE0004 | 2024-10-29T12:15:23.072Z | 2024-11-04T14:28:57.462Z |
5407239 | 5407239 | 20241027022801_VZzI4 | IE0004 | 2024-10-29T12:15:18.396Z | 2024-11-04T14:28:57.259Z |
5407148 | 5407148 | 20241027022404_742y8 | IE0004 | 2024-10-29T12:15:14.951Z | 2024-11-04T14:28:57.110Z |
5407032 | 5407032 | 20241027021751_ZtfmF | IE0004 | 2024-10-29T12:15:09.756Z | 2024-11-04T14:28:56.791Z |
5406893 | 5406893 | 20241027020705_X8Qr8 | IE0004 | 2024-10-29T12:14:53.632Z | 2024-11-04T14:28:56.582Z |
5406673 | 5406673 | 20241027015310_A8k3u | IE0004 | 2024-10-29T12:14:30.969Z | 2024-11-04T14:28:56.018Z |
5406640 | 5406640 | 20241027015144_gwnWn | IE0004 | 2024-10-29T12:14:28.269Z | 2024-11-04T14:28:55.971Z |
5406126 | 5406126 | 20241027011826_AwXPw | IE0004 | 2024-10-29T12:13:52.957Z | 2024-11-04T14:28:55.153Z |
5405909 | 5405909 | 20241027010720_Zw4Tl | IE0004 | 2024-10-29T12:13:32.374Z | 2024-11-04T14:28:54.600Z |
5405804 | 5405804 | 20241027010014_3Y08T | IE0004 | 2024-10-29T12:13:18.711Z | 2024-11-04T14:28:54.336Z |
5405487 | 5405487 | 20241027003916_iUq8e | IE0004 | 2024-10-29T12:12:59.052Z | 2024-11-04T14:28:53.560Z |
5405408 | 5405408 | 20241027003242_RrX59 | IE0004 | 2024-10-29T12:12:54.769Z | 2024-11-04T14:28:53.458Z |
5405334 | 5405334 | 20241027002907_1x3el | IE0004 | 2024-10-29T12:12:50.147Z | 2024-11-04T14:28:53.294Z |
5405099 | 5405099 | 20241027001344_ckHDe | IE0004 | 2024-10-29T12:12:27.469Z | 2024-11-04T14:28:52.677Z |
5405040 | 5405040 | 20241027001005_sYxuw | IE0004 | 2024-10-29T12:12:19.220Z | 2024-11-04T14:28:52.617Z |
5404995 | 5404995 | 20241027000707_bkzkk | IE0004 | 2024-10-29T12:12:15.318Z | 2024-11-04T14:28:52.505Z |
5404725 | 5404725 | 20241026234925_gxOAe | IE0004 | 2024-10-29T12:11:55.131Z | 2024-11-04T14:28:51.872Z |
5404250 | 5404250 | 20241026231208_R2WjD | IE0004 | 2024-10-29T12:11:03.268Z | 2024-11-04T14:28:50.555Z |
5404241 | 5404241 | 20241026231121_7nHby | IE0004 | 2024-10-29T12:11:02.998Z | 2024-11-04T14:28:50.551Z |
5404228 | 5404228 | 20241026231013_SK3sc | IE0004 | 2024-10-29T12:11:02.298Z | 2024-11-04T14:28:50.522Z |
5404199 | 5404199 | 20241026230812_fWwLf | IE0004 | 2024-10-29T12:11:00.153Z | 2024-11-04T14:28:50.454Z |
5403899 | 5403899 | 20241026224444_rA486 | IE0004 | 2024-10-29T12:10:25.977Z | 2024-11-04T14:28:49.980Z |
5403423 | 5403423 | 20241026215532_xIVT8 | IE0004 | 2024-10-29T12:09:28.820Z | 2024-11-04T14:28:48.800Z |
5403404 | 5403404 | 20241026215414_l20z6 | IE0004 | 2024-10-29T12:09:27.763Z | 2024-11-04T14:28:48.729Z |
5403320 | 5403320 | 20241026214045_GDS6I | IE0004 | 2024-10-29T12:09:21.896Z | 2024-11-04T14:28:48.330Z |
5403171 | 5403171 | 20241026212537_u5XAq | IE0004 | 2024-10-29T12:09:10.195Z | 2024-11-04T14:28:47.923Z |
5402872 | 5402872 | 20241026203613_PT3P0 | IE0004 | 2024-10-29T12:08:31.009Z | 2024-11-04T14:28:46.759Z |
5402581 | 5402581 | 20241026195837_13aRw | IE0004 | 2024-10-29T12:07:44.774Z | 2024-11-04T14:28:45.386Z |
5400175 | 5400175 | 20241026055029_ulbyN | IE0004 | 2024-10-28T12:20:25.562Z | 2024-11-03T14:27:41.457Z |
5400171 | 5400171 | 20241026055019_eG88G | IE0004 | 2024-10-28T12:20:25.540Z | 2024-11-03T14:27:41.455Z |
5398040 | 5398040 | 20241026021956_zlsaw | IE0004 | 2024-10-28T12:18:58.379Z | 2024-11-03T14:27:35.103Z |
5397897 | 5397897 | 20241026020619_C4SMr | IE0004 | 2024-10-28T12:18:49.859Z | 2024-11-03T14:27:34.458Z |
5397373 | 5397373 | 20241026012420_u8aPb | IE0004 | 2024-10-28T12:18:18.726Z | 2024-11-03T14:27:32.758Z |
5397294 | 5397294 | 20241026011622_7nBQs | IE0004 | 2024-10-28T12:18:14.868Z | 2024-11-03T14:27:32.551Z |
5397287 | 5397287 | 20241026011559_UY7D1 | IE0004 | 2024-10-28T12:18:14.304Z | 2024-11-03T14:27:32.515Z |
5396531 | 5396531 | 20241026000955_0KhG3 | IE0004 | 2024-10-28T12:17:48.938Z | 2024-11-03T14:27:30.157Z |
5396483 | 5396483 | 20241026000712_K7xmw | IE0004 | 2024-10-28T12:17:45.763Z | 2024-11-03T14:27:29.968Z |
5396475 | 5396475 | 20241026000636_1MjHf | IE0004 | 2024-10-28T12:17:45.605Z | 2024-11-03T14:27:29.966Z |
5396352 | 5396352 | 20241025235919_BiiW2 | IE0004 | 2024-10-28T12:17:35.937Z | 2024-11-03T14:27:29.621Z |
5396282 | 5396282 | 20241025235230_XYVPL | IE0004 | 2024-10-28T12:17:30.089Z | 2024-11-03T14:27:29.152Z |
5395918 | 5395918 | 20241025232312_9QY2B | IE0004 | 2024-10-28T12:17:05.207Z | 2024-11-03T14:27:27.621Z |
5395068 | 5395068 | 20241025220556_KUWr1 | IE0004 | 2024-10-28T12:15:55.315Z | 2024-11-03T14:27:23.895Z |
5393914 | 5393914 | 20241025191051_L2hsK | IE0004 | 2024-10-28T12:13:52.548Z | 2024-11-03T14:27:19.051Z |
5393849 | 5393849 | 20241025185758_NL4QL | IE0004 | 2024-10-28T12:13:38.764Z | 2024-11-03T14:27:18.656Z |
5367138 | 5367138 | 20241023053605_Gx4A8 | IE0004 | 2024-10-25T12:21:46.760Z | 2024-10-31T12:30:11.553Z |
5367068 | 5367068 | 20241023051512_cZH4w | IE0004 | 2024-10-25T12:21:43.650Z | 2024-10-31T12:30:10.846Z |
5366980 | 5366980 | 20241023045651_qRWVI | IE0004 | 2024-10-25T12:21:40.198Z | 2024-10-31T12:30:09.811Z |
5366943 | 5366943 | 20241023044432_p6Shf | IE0004 | 2024-10-25T12:21:37.581Z | 2024-10-31T12:30:09.389Z |
5350798 | 5350798 | 20241022222942_PwnI1 | IE0004 | 2024-10-24T12:16:34.090Z | 2024-10-31T12:29:58.804Z |
5345382 | 5345382 | 20241022054202_GfxMw | IE0004 | 2024-10-23T12:19:17.996Z | 2024-10-30T12:26:52.596Z |
5345305 | 5345305 | 20241022053415_Kx0fZ | IE0004 | 2024-10-23T12:19:13.709Z | 2024-10-30T12:26:52.435Z |
5345279 | 5345279 | 20241022053216_61O9M | IE0004 | 2024-10-23T12:19:13.011Z | 2024-10-30T12:26:52.392Z |
5345262 | 5345262 | 20241022053058_yXo4i | IE0004 | 2024-10-23T12:19:12.596Z | 2024-10-30T12:26:52.371Z |
5345182 | 5345182 | 20241022052158_t8cTz | IE0004 | 2024-10-23T12:19:09.659Z | 2024-10-30T12:26:52.282Z |
5345137 | 5345137 | 20241022051502_d88ED | IE0004 | 2024-10-23T12:19:07.341Z | 2024-10-30T12:26:52.226Z |
5345095 | 5345095 | 20241022051245_uAH6I | IE0004 | 2024-10-23T12:19:05.738Z | 2024-10-30T12:26:52.185Z |
5344740 | 5344740 | 20241022044244_oCCG7 | IE0004 | 2024-10-23T12:18:49.592Z | 2024-10-30T12:26:51.603Z |
5344567 | 5344567 | 20241022043244_kIt9i | IE0004 | 2024-10-23T12:18:41.975Z | 2024-10-30T12:26:51.375Z |
5344497 | 5344497 | 20241022042747_9JbMs | IE0004 | 2024-10-23T12:18:40.004Z | 2024-10-30T12:26:51.292Z |
5344092 | 5344092 | 20241022040536_tqIdk | IE0004 | 2024-10-23T12:18:22.749Z | 2024-10-30T12:26:50.929Z |
5342135 | 5342135 | 20241022021029_FoVdS | IE0004 | 2024-10-23T12:16:36.515Z | 2024-10-30T12:26:48.056Z |
5341535 | 5341535 | 20241022013948_5QgXQ | IE0004 | 2024-10-23T12:15:57.295Z | 2024-10-30T12:26:47.157Z |
5335494 | 5335494 | 20241021052805_QYm2Q | IE0004 | 2024-10-22T12:18:15.072Z | 2024-10-29T12:26:36.344Z |
5335470 | 5335470 | 20241021052141_EIZU0 | IE0004 | 2024-10-22T12:18:14.332Z | 2024-10-29T12:26:36.310Z |
5335401 | 5335401 | 20241021045923_pOw5h | IE0004 | 2024-10-22T12:18:11.166Z | 2024-10-29T12:26:36.245Z |
5335397 | 5335397 | 20241021045709_8gk16 | IE0004 | 2024-10-22T12:18:11.040Z | 2024-10-29T12:26:36.242Z |
5334342 | 5334342 | 20241021022445_qC1CC | IE0004 | 2024-10-22T12:16:40.031Z | 2024-10-29T12:26:35.072Z |
5334279 | 5334279 | 20241021021716_2B35J | IE0004 | 2024-10-22T12:16:32.839Z | 2024-10-29T12:26:35.007Z |
5323619 | 5323619 | 20241019053104_ihLZ2 | IE0004 | 2024-10-20T12:06:50.929Z | 2024-10-27T12:28:51.568Z |
5323611 | 5323611 | 20241019051814_gpbfu | IE0004 | 2024-10-20T12:06:48.528Z | 2024-10-27T12:28:51.563Z |
5323598 | 5323598 | 20241019050830_hq0EY | IE0004 | 2024-10-20T12:06:43.984Z | 2024-10-27T12:28:51.533Z |
5323573 | 5323573 | 20241019044443_ipAFI | IE0004 | 2024-10-20T12:06:37.328Z | 2024-10-27T12:28:51.517Z |
5323567 | 5323567 | 20241019043903_fYvTv | IE0004 | 2024-10-20T12:06:35.969Z | 2024-10-27T12:28:51.455Z |
5323557 | 5323557 | 20241019042623_h11uJ | IE0004 | 2024-10-20T12:06:33.112Z | 2024-10-27T12:28:51.443Z |
5323516 | 5323516 | 20241019033505_Hu3GR | IE0004 | 2024-10-20T12:06:25.020Z | 2024-10-27T12:28:50.927Z |
5320079 | 5320079 | 20241017233100_B0jjA | IE0004 | 2024-10-19T12:04:34.480Z | 2024-10-26T12:27:54.009Z |
5318432 | 5318432 | 20241017032436_MwOXe | IE0004 | 2024-10-18T12:03:47.337Z | 2024-10-25T12:24:35.516Z |
5318326 | 5318326 | 20241017023226_4Jf5u | IE0004 | 2024-10-18T12:03:33.256Z | 2024-10-25T12:24:34.615Z |
5318322 | 5318322 | 20241017023032_d4yRL | IE0004 | 2024-10-18T12:03:31.480Z | 2024-10-25T12:24:34.585Z |
5318281 | 5318281 | 20241017021154_jf3SB | IE0004 | 2024-10-18T12:03:18.562Z | 2024-10-25T12:24:34.391Z |
5318241 | 5318241 | 20241017013704_hBWKn | IE0004 | 2024-10-18T12:03:13.195Z | 2024-10-25T12:24:34.048Z |
5318233 | 5318233 | 20241017013305_Ycqzq | IE0004 | 2024-10-18T12:03:11.293Z | 2024-10-25T12:24:33.963Z |
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);