participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
5,991 rows where station_code = "PT0002" 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 |
---|---|---|---|---|---|
5592525 | 5592525 | 20241123034435_6C06l | PT0002 | 2024-11-24T14:21:06.673Z | 2024-11-24T14:21:11.803Z |
5592448 | 5592448 | 20241123032758_awVUw | PT0002 | 2024-11-24T14:21:02.013Z | 2024-11-24T14:21:11.781Z |
5592395 | 5592395 | 20241123031802_jghIW | PT0002 | 2024-11-24T14:20:59.561Z | 2024-11-24T14:21:11.767Z |
5592310 | 5592310 | 20241123030134_mCkkr | PT0002 | 2024-11-24T14:20:53.179Z | 2024-11-24T14:21:11.744Z |
5592277 | 5592277 | 20241123025210_6iBEy | PT0002 | 2024-11-24T14:20:51.220Z | 2024-11-24T14:21:11.734Z |
5592271 | 5592271 | 20241123025014_YIS69 | PT0002 | 2024-11-24T14:20:50.897Z | 2024-11-24T14:21:11.732Z |
5592224 | 5592224 | 20241123023939_Ir35U | PT0002 | 2024-11-24T14:20:47.592Z | 2024-11-24T14:21:11.718Z |
5592154 | 5592154 | 20241123022321_3MCTf | PT0002 | 2024-11-24T14:20:42.022Z | 2024-11-24T14:21:11.698Z |
5592097 | 5592097 | 20241123021317_7gKEK | PT0002 | 2024-11-24T14:20:37.921Z | 2024-11-24T14:21:11.682Z |
5591881 | 5591881 | 20241123012032_aI4rz | PT0002 | 2024-11-24T14:20:22.697Z | 2024-11-24T14:21:11.621Z |
5591836 | 5591836 | 20241123010742_0UsFR | PT0002 | 2024-11-24T14:20:20.022Z | 2024-11-24T14:21:11.607Z |
5591697 | 5591697 | 20241123003306_Hza6W | PT0002 | 2024-11-24T14:20:10.902Z | 2024-11-24T14:21:11.564Z |
5591681 | 5591681 | 20241123002915_b1GkW | PT0002 | 2024-11-24T14:20:10.179Z | 2024-11-24T14:21:11.560Z |
5591622 | 5591622 | 20241123000734_76v95 | PT0002 | 2024-11-24T14:20:06.476Z | 2024-11-24T14:21:11.544Z |
5584607 | 5584607 | 20241123051354_vnkoz | PT0002 | 2024-11-24T14:01:40.296Z | 2024-11-24T14:01:40.296Z |
5584534 | 5584534 | 20241123045937_Dd2UV | PT0002 | 2024-11-24T14:01:25.397Z | 2024-11-24T14:01:25.397Z |
5584473 | 5584473 | 20241123044722_BSoZo | PT0002 | 2024-11-24T14:01:11.044Z | 2024-11-24T14:01:11.044Z |
5584213 | 5584213 | 20241123035427_BfeGG | PT0002 | 2024-11-24T14:00:13.009Z | 2024-11-24T14:00:13.009Z |
5583449 | 5583449 | 20241119223024_UUxE9 | PT0002 | 2024-11-23T14:24:26.707Z | 2024-11-24T14:24:29.811Z |
5572009 | 5572009 | 20241121011906_e0XVt | PT0002 | 2024-11-22T14:17:52.120Z | 2024-11-24T14:23:49.214Z |
5571888 | 5571888 | 20241121010024_CQk6i | PT0002 | 2024-11-22T14:17:45.022Z | 2024-11-24T14:23:47.958Z |
5565489 | 5565489 | 20241120043046_oRq22 | PT0002 | 2024-11-21T14:18:51.033Z | 2024-11-24T14:24:47.300Z |
5565463 | 5565463 | 20241120042828_VzaFC | PT0002 | 2024-11-21T14:18:50.011Z | 2024-11-24T14:24:47.214Z |
5565452 | 5565452 | 20241120042726_njqxe | PT0002 | 2024-11-21T14:18:49.659Z | 2024-11-24T14:24:47.172Z |
5565399 | 5565399 | 20241120042237_DOX4A | PT0002 | 2024-11-21T14:18:47.867Z | 2024-11-24T14:24:47.001Z |
5565373 | 5565373 | 20241120042128_zb21t | PT0002 | 2024-11-21T14:18:47.352Z | 2024-11-24T14:24:46.951Z |
5565175 | 5565175 | 20241120035951_lvcLY | PT0002 | 2024-11-21T14:18:37.818Z | 2024-11-24T14:24:46.153Z |
5565155 | 5565155 | 20241120035739_ODnD1 | PT0002 | 2024-11-21T14:18:34.061Z | 2024-11-24T14:24:46.055Z |
5565138 | 5565138 | 20241120035519_fN3Ln | PT0002 | 2024-11-21T14:18:33.302Z | 2024-11-24T14:24:46.028Z |
5565053 | 5565053 | 20241120034715_7lL6Y | PT0002 | 2024-11-21T14:18:24.701Z | 2024-11-24T14:24:45.666Z |
5565051 | 5565051 | 20241120034709_9eHpf | PT0002 | 2024-11-21T14:18:23.981Z | 2024-11-24T14:24:45.666Z |
5564715 | 5564715 | 20241120032201_7OZXp | PT0002 | 2024-11-21T14:17:59.176Z | 2024-11-24T14:24:43.767Z |
5564574 | 5564574 | 20241120031005_Brcth | PT0002 | 2024-11-21T14:17:50.988Z | 2024-11-24T14:24:43.451Z |
5564571 | 5564571 | 20241120030959_pJCf2 | PT0002 | 2024-11-21T14:17:50.537Z | 2024-11-24T14:24:43.451Z |
5564499 | 5564499 | 20241120030352_P2eRm | PT0002 | 2024-11-21T14:17:42.276Z | 2024-11-24T14:24:43.172Z |
5564422 | 5564422 | 20241120025536_FTFJ2 | PT0002 | 2024-11-21T14:17:34.417Z | 2024-11-24T14:24:43.012Z |
5564362 | 5564362 | 20241120024931_Ao4JH | PT0002 | 2024-11-21T14:17:30.279Z | 2024-11-24T14:24:42.582Z |
5563552 | 5563552 | 20241120014106_qGQgD | PT0002 | 2024-11-21T14:16:17.038Z | 2024-11-24T14:24:37.923Z |
5562055 | 5562055 | 20241119225318_6XM0r | PT0002 | 2024-11-21T14:14:22.305Z | 2024-11-24T14:24:30.640Z |
5561785 | 5561785 | 20241119220807_kXgkL | PT0002 | 2024-11-21T14:14:06.028Z | 2024-11-24T14:24:29.036Z |
5561586 | 5561586 | 20241119211026_kvZZG | PT0002 | 2024-11-21T14:13:30.536Z | 2024-11-24T14:24:27.699Z |
5561546 | 5561546 | 20241119205821_yMRQn | PT0002 | 2024-11-21T14:13:26.194Z | 2024-11-24T14:24:27.518Z |
5557668 | 5557668 | 20241120050411_lu1oJ | PT0002 | 2024-11-21T14:01:27.174Z | 2024-11-24T14:22:43.410Z |
5557646 | 5557646 | 20241120050302_pWqfR | PT0002 | 2024-11-21T14:01:25.361Z | 2024-11-24T14:22:43.314Z |
5557510 | 5557510 | 20241120045230_ngbeL | PT0002 | 2024-11-21T14:01:02.388Z | 2024-11-24T14:22:41.651Z |
5553809 | 5553809 | 20241118042430_vAvvk | PT0002 | 2024-11-19T14:11:27.851Z | 2024-11-24T14:25:23.150Z |
5539130 | 5539130 | 20241110051352_9HxRz | PT0002 | 2024-11-14T14:20:26.354Z | 2024-11-18T14:26:38.864Z |
5537180 | 5537180 | 20241112204913_rxFul | PT0002 | 2024-11-14T14:11:12.767Z | 2024-11-21T14:26:09.514Z |
5537094 | 5537094 | 20241112202456_N8lPe | PT0002 | 2024-11-14T14:11:01.427Z | 2024-11-21T14:26:08.733Z |
5532593 | 5532593 | 20241112054234_ufq3j | PT0002 | 2024-11-13T14:17:02.249Z | 2024-11-20T14:26:24.995Z |
5532439 | 5532439 | 20241112052315_nZhA6 | PT0002 | 2024-11-13T14:16:47.464Z | 2024-11-20T14:26:23.075Z |
5532433 | 5532433 | 20241112052112_jORxT | PT0002 | 2024-11-13T14:16:46.070Z | 2024-11-20T14:26:22.834Z |
5532241 | 5532241 | 20241112045431_NH1Zr | PT0002 | 2024-11-13T14:16:30.203Z | 2024-11-20T14:26:21.278Z |
5532092 | 5532092 | 20241112043659_aR6u2 | PT0002 | 2024-11-13T14:16:17.947Z | 2024-11-20T14:26:18.635Z |
5531659 | 5531659 | 20241112035806_QQ3gg | PT0002 | 2024-11-13T14:15:49.031Z | 2024-11-20T14:26:13.045Z |
5531445 | 5531445 | 20241112034003_b7N3m | PT0002 | 2024-11-13T14:15:39.936Z | 2024-11-20T14:26:11.290Z |
5531147 | 5531147 | 20241112031745_yYgCr | PT0002 | 2024-11-13T14:15:19.595Z | 2024-11-20T14:26:08.302Z |
5531025 | 5531025 | 20241112030735_I8nLP | PT0002 | 2024-11-13T14:15:03.619Z | 2024-11-20T14:26:06.222Z |
5530547 | 5530547 | 20241112022746_bROCI | PT0002 | 2024-11-13T14:14:21.486Z | 2024-11-20T14:26:01.556Z |
5530519 | 5530519 | 20241112022551_9mbsk | PT0002 | 2024-11-13T14:14:20.097Z | 2024-11-20T14:26:01.091Z |
5529945 | 5529945 | 20241112012724_xILe7 | PT0002 | 2024-11-13T14:13:27.516Z | 2024-11-20T14:25:51.302Z |
5529428 | 5529428 | 20241112001819_nYFVO | PT0002 | 2024-11-13T14:12:46.384Z | 2024-11-20T14:25:44.648Z |
5529258 | 5529258 | 20241111235443_3S2Xr | PT0002 | 2024-11-13T14:12:16.620Z | 2024-11-20T14:25:42.275Z |
5529126 | 5529126 | 20241111233205_sFjfh | PT0002 | 2024-11-13T14:12:06.770Z | 2024-11-20T14:25:40.231Z |
5528624 | 5528624 | 20241111215744_JZGkh | PT0002 | 2024-11-13T14:11:10.995Z | 2024-11-20T14:25:32.861Z |
5524987 | 5524987 | 20241110052344_dR2OJ | PT0002 | 2024-11-12T14:21:59.332Z | 2024-11-18T14:26:39.017Z |
5524985 | 5524985 | 20241110052131_Td0pL | PT0002 | 2024-11-12T14:21:59.016Z | 2024-11-18T14:26:38.974Z |
5524981 | 5524981 | 20241110043548_2VzZI | PT0002 | 2024-11-12T14:21:52.996Z | 2024-11-18T14:26:37.962Z |
5524975 | 5524975 | 20241110042236_CoIv2 | PT0002 | 2024-11-12T14:21:50.617Z | 2024-11-18T14:26:37.647Z |
5524967 | 5524967 | 20241110035153_28B3g | PT0002 | 2024-11-12T14:21:43.742Z | 2024-11-18T14:26:36.739Z |
5524963 | 5524963 | 20241110033605_89d8v | PT0002 | 2024-11-12T14:21:39.970Z | 2024-11-18T14:26:36.184Z |
5524956 | 5524956 | 20241110030447_cUVaH | PT0002 | 2024-11-12T14:21:35.107Z | 2024-11-18T14:26:35.357Z |
5524952 | 5524952 | 20241110023644_zrqqT | PT0002 | 2024-11-12T14:21:27.941Z | 2024-11-18T14:26:34.325Z |
5524950 | 5524950 | 20241110023522_yh1HA | PT0002 | 2024-11-12T14:21:27.802Z | 2024-11-18T14:26:34.306Z |
5524938 | 5524938 | 20241110015325_1XXQv | PT0002 | 2024-11-12T14:21:17.908Z | 2024-11-18T14:26:33.129Z |
5524936 | 5524936 | 20241110015032_zbaLq | PT0002 | 2024-11-12T14:21:17.554Z | 2024-11-18T14:26:33.015Z |
5524928 | 5524928 | 20241110012831_byyBC | PT0002 | 2024-11-12T14:21:13.388Z | 2024-11-18T14:26:32.400Z |
5524926 | 5524926 | 20241110012656_masN5 | PT0002 | 2024-11-12T14:21:12.846Z | 2024-11-18T14:26:32.267Z |
5524918 | 5524918 | 20241110005006_TwyRS | PT0002 | 2024-11-12T14:21:03.807Z | 2024-11-18T14:26:30.931Z |
5524912 | 5524912 | 20241109235157_8z2Hs | PT0002 | 2024-11-12T14:20:50.377Z | 2024-11-18T14:26:29.544Z |
5524907 | 5524907 | 20241109233204_w9huD | PT0002 | 2024-11-12T14:20:46.809Z | 2024-11-18T14:26:28.902Z |
5524903 | 5524903 | 20241109232454_AXdAO | PT0002 | 2024-11-12T14:20:45.642Z | 2024-11-18T14:26:28.802Z |
5524901 | 5524901 | 20241109223938_FiH42 | PT0002 | 2024-11-12T14:20:37.395Z | 2024-11-18T14:26:27.920Z |
5524898 | 5524898 | 20241109223017_v6r4m | PT0002 | 2024-11-12T14:20:35.390Z | 2024-11-18T14:26:27.732Z |
5517523 | 5517523 | 20241110035717_44OpR | PT0002 | 2024-11-11T14:14:32.258Z | 2024-11-18T14:26:36.976Z |
5517215 | 5517215 | 20241110030504_bCGJf | PT0002 | 2024-11-11T14:14:05.806Z | 2024-11-18T14:26:35.379Z |
5516469 | 5516469 | 20241110010421_HWxjL | PT0002 | 2024-11-11T14:13:02.963Z | 2024-11-18T14:26:31.360Z |
5509815 | 5509815 | 20241109004515_Nh5Sv | PT0002 | 2024-11-10T14:14:03.366Z | 2024-11-17T14:23:49.496Z |
5505680 | 5505680 | 20241106041942_s6W2f | PT0002 | 2024-11-09T14:20:12.567Z | 2024-11-14T14:23:26.394Z |
5505676 | 5505676 | 20241106040919_jsrbZ | PT0002 | 2024-11-09T14:20:12.126Z | 2024-11-14T14:23:26.350Z |
5505674 | 5505674 | 20241106034907_g2mqT | PT0002 | 2024-11-09T14:20:10.976Z | 2024-11-14T14:23:26.101Z |
5505672 | 5505672 | 20241106034650_Zcg47 | PT0002 | 2024-11-09T14:20:10.803Z | 2024-11-14T14:23:26.084Z |
5505670 | 5505670 | 20241106034613_mfRz0 | PT0002 | 2024-11-09T14:20:10.749Z | 2024-11-14T14:23:26.068Z |
5505664 | 5505664 | 20241106033459_xWdp6 | PT0002 | 2024-11-09T14:20:10.163Z | 2024-11-14T14:23:26.000Z |
5505660 | 5505660 | 20241106032436_99DyO | PT0002 | 2024-11-09T14:20:09.587Z | 2024-11-14T14:23:25.855Z |
5505658 | 5505658 | 20241106032403_1EuhK | PT0002 | 2024-11-09T14:20:09.398Z | 2024-11-14T14:23:25.828Z |
5505656 | 5505656 | 20241106032131_KYu9V | PT0002 | 2024-11-09T14:20:08.818Z | 2024-11-14T14:23:25.728Z |
5505652 | 5505652 | 20241106025303_4S3Td | PT0002 | 2024-11-09T14:20:06.594Z | 2024-11-14T14:23:25.103Z |
5505646 | 5505646 | 20241106021648_lBp6V | PT0002 | 2024-11-09T14:20:04.934Z | 2024-11-14T14:23:24.159Z |
5485413 | 5485413 | 20241105053011_rBNqI | PT0002 | 2024-11-06T14:18:14.405Z | 2024-11-13T14:27:42.264Z |
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);