participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
362 rows where station_code = "ZA0008" 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 |
---|---|---|---|---|---|
5467572 | 5467572 | 20241102215439_w4atx | ZA0008 | 2024-11-04T14:12:04.853Z | 2024-11-05T14:21:07.145Z |
5466742 | 5466742 | 20241102184403_7EpRW | ZA0008 | 2024-11-04T14:09:40.901Z | 2024-11-05T14:20:53.138Z |
5461907 | 5461907 | 20241101220729_3j2VY | ZA0008 | 2024-11-03T14:16:42.987Z | 2024-11-05T14:22:52.926Z |
5461895 | 5461895 | 20241101220327_t7q5a | ZA0008 | 2024-11-03T14:16:38.659Z | 2024-11-05T14:22:52.834Z |
5461873 | 5461873 | 20241101215519_7JrdL | ZA0008 | 2024-11-03T14:16:30.517Z | 2024-11-05T14:22:51.757Z |
5461848 | 5461848 | 20241101214740_iAkcp | ZA0008 | 2024-11-03T14:16:26.861Z | 2024-11-05T14:22:51.518Z |
5461741 | 5461741 | 20241101210417_2FYiq | ZA0008 | 2024-11-03T14:16:09.202Z | 2024-11-05T14:22:50.341Z |
5451063 | 5451063 | 20241031223004_xB3cI | ZA0008 | 2024-11-02T12:16:33.388Z | 2024-11-05T14:24:07.277Z |
5450977 | 5450977 | 20241031220703_A0Tt7 | ZA0008 | 2024-11-02T12:16:26.910Z | 2024-11-05T14:24:06.605Z |
5450943 | 5450943 | 20241031215904_Z6pkL | ZA0008 | 2024-11-02T12:16:20.181Z | 2024-11-05T14:24:06.443Z |
5450893 | 5450893 | 20241031213452_SxY1X | ZA0008 | 2024-11-02T12:16:12.513Z | 2024-11-05T14:24:06.068Z |
5450815 | 5450815 | 20241031211339_rIeei | ZA0008 | 2024-11-02T12:15:58.608Z | 2024-11-05T14:24:05.037Z |
5450780 | 5450780 | 20241031205437_gwoZ6 | ZA0008 | 2024-11-02T12:15:52.238Z | 2024-11-05T14:24:04.556Z |
5450667 | 5450667 | 20241031201402_u6JL1 | ZA0008 | 2024-11-02T12:15:43.254Z | 2024-11-05T14:24:03.184Z |
5450472 | 5450472 | 20241031192452_YTJfF | ZA0008 | 2024-11-02T12:15:27.086Z | 2024-11-05T14:24:01.829Z |
5450417 | 5450417 | 20241031191323_d3ARN | ZA0008 | 2024-11-02T12:15:14.641Z | 2024-11-05T14:24:01.162Z |
5450323 | 5450323 | 20241031184254_tW0UA | ZA0008 | 2024-11-02T12:14:58.369Z | 2024-11-05T14:24:00.504Z |
5441353 | 5441353 | 20241029215006_A52Y2 | ZA0008 | 2024-11-01T12:18:28.703Z | 2024-11-05T14:26:00.017Z |
5440426 | 5440426 | 20241030221017_1A33u | ZA0008 | 2024-11-01T12:15:30.225Z | 2024-11-05T14:25:17.278Z |
5433429 | 5433429 | 20241029195608_G3tf3 | ZA0008 | 2024-10-31T12:22:14.859Z | 2024-11-05T14:25:56.264Z |
5429707 | 5429707 | 20241028195227_MGgD2 | ZA0008 | 2024-10-31T12:16:56.052Z | 2024-11-05T14:26:32.545Z |
5403742 | 5403742 | 20241026222708_ZZjbm | ZA0008 | 2024-10-29T12:10:10.868Z | 2024-11-04T14:28:49.532Z |
5403704 | 5403704 | 20241026222408_glSJJ | ZA0008 | 2024-10-29T12:10:08.507Z | 2024-11-04T14:28:49.501Z |
5403590 | 5403590 | 20241026221427_4OxyI | ZA0008 | 2024-10-29T12:10:00.608Z | 2024-11-04T14:28:49.294Z |
5395389 | 5395389 | 20241025223848_WOrC3 | ZA0008 | 2024-10-28T12:16:11.896Z | 2024-11-03T14:27:25.421Z |
5395001 | 5395001 | 20241025215832_E55gh | ZA0008 | 2024-10-28T12:15:52.409Z | 2024-11-03T14:27:23.633Z |
5394626 | 5394626 | 20241025210022_hN3IM | ZA0008 | 2024-10-28T12:15:06.610Z | 2024-11-03T14:27:21.912Z |
5394600 | 5394600 | 20241025205519_RMESS | ZA0008 | 2024-10-28T12:15:03.113Z | 2024-11-03T14:27:21.796Z |
5394335 | 5394335 | 20241025201642_veGmb | ZA0008 | 2024-10-28T12:14:23.915Z | 2024-11-03T14:27:20.912Z |
5385043 | 5385043 | 20241024214032_IJ5nW | ZA0008 | 2024-10-27T12:18:16.991Z | 2024-11-02T12:28:28.982Z |
5385017 | 5385017 | 20241024213744_rwcAh | ZA0008 | 2024-10-27T12:18:13.719Z | 2024-11-02T12:28:28.932Z |
5385007 | 5385007 | 20241024213509_nNDZf | ZA0008 | 2024-10-27T12:18:11.794Z | 2024-11-02T12:28:28.914Z |
5384946 | 5384946 | 20241024211937_2O8wb | ZA0008 | 2024-10-27T12:18:02.417Z | 2024-11-02T12:28:28.776Z |
5384855 | 5384855 | 20241024210419_6IENG | ZA0008 | 2024-10-27T12:17:50.765Z | 2024-11-02T12:28:28.514Z |
5384600 | 5384600 | 20241024202718_giTrr | ZA0008 | 2024-10-27T12:17:16.253Z | 2024-11-02T12:28:27.384Z |
5384422 | 5384422 | 20241024200643_vV1em | ZA0008 | 2024-10-27T12:17:02.245Z | 2024-11-02T12:28:27.192Z |
5371893 | 5371893 | 20241023202818_GMYvW | ZA0008 | 2024-10-26T12:17:33.068Z | 2024-11-01T12:26:52.869Z |
5371886 | 5371886 | 20241023191541_zSzX0 | ZA0008 | 2024-10-26T12:16:50.094Z | 2024-11-01T12:26:51.090Z |
5371882 | 5371882 | 20241023185507_wn9jy | ZA0008 | 2024-10-26T12:16:38.506Z | 2024-11-01T12:26:50.643Z |
5364581 | 5364581 | 20241023223853_lq2m2 | ZA0008 | 2024-10-25T12:17:25.167Z | 2024-11-01T12:26:55.224Z |
5364392 | 5364392 | 20241023222610_53iys | ZA0008 | 2024-10-25T12:17:19.349Z | 2024-11-01T12:26:55.033Z |
5364280 | 5364280 | 20241023221843_T5WFO | ZA0008 | 2024-10-25T12:17:15.170Z | 2024-11-01T12:26:54.653Z |
5363744 | 5363744 | 20241023214003_vpeLk | ZA0008 | 2024-10-25T12:16:40.740Z | 2024-11-01T12:26:53.590Z |
5363497 | 5363497 | 20241023211350_lcRb5 | ZA0008 | 2024-10-25T12:16:16.353Z | 2024-11-01T12:26:53.325Z |
5363465 | 5363465 | 20241023210629_8tjEG | ZA0008 | 2024-10-25T12:16:13.749Z | 2024-11-01T12:26:53.311Z |
5363141 | 5363141 | 20241023203013_ED7Ct | ZA0008 | 2024-10-25T12:15:32.100Z | 2024-11-01T12:26:52.877Z |
5362535 | 5362535 | 20241023193926_7DcX2 | ZA0008 | 2024-10-25T12:14:40.197Z | 2024-11-01T12:26:51.902Z |
5361608 | 5361608 | 20241023182839_C2pY5 | ZA0008 | 2024-10-25T12:13:00.641Z | 2024-11-01T12:26:50.375Z |
5361478 | 5361478 | 20241023182029_vfBtV | ZA0008 | 2024-10-25T12:12:44.611Z | 2024-11-01T12:26:50.192Z |
5350848 | 5350848 | 20241022223436_uBXJ8 | ZA0008 | 2024-10-24T12:16:42.004Z | 2024-10-31T12:29:58.851Z |
5350719 | 5350719 | 20241022222134_aR0Ws | ZA0008 | 2024-10-24T12:16:20.921Z | 2024-10-31T12:29:58.703Z |
5350609 | 5350609 | 20241022220805_K2Pn7 | ZA0008 | 2024-10-24T12:16:04.300Z | 2024-10-31T12:29:58.551Z |
5350480 | 5350480 | 20241022215501_mUGW8 | ZA0008 | 2024-10-24T12:15:48.363Z | 2024-10-31T12:29:58.265Z |
5350226 | 5350226 | 20241022212429_neJqV | ZA0008 | 2024-10-24T12:15:29.670Z | 2024-10-31T12:29:57.577Z |
5350108 | 5350108 | 20241022211221_iMbEA | ZA0008 | 2024-10-24T12:15:22.800Z | 2024-10-31T12:29:57.316Z |
5350079 | 5350079 | 20241022210841_6DMeI | ZA0008 | 2024-10-24T12:15:17.292Z | 2024-10-31T12:29:57.273Z |
5350026 | 5350026 | 20241022210254_gpmMV | ZA0008 | 2024-10-24T12:15:07.136Z | 2024-10-31T12:29:57.193Z |
5349920 | 5349920 | 20241022204902_AP5cm | ZA0008 | 2024-10-24T12:14:48.461Z | 2024-10-31T12:29:56.923Z |
5349752 | 5349752 | 20241022203246_enhwv | ZA0008 | 2024-10-24T12:14:35.508Z | 2024-10-31T12:29:56.221Z |
5349457 | 5349457 | 20241022200121_AJRjG | ZA0008 | 2024-10-24T12:13:42.825Z | 2024-10-31T12:29:55.479Z |
5349273 | 5349273 | 20241022193840_BS2P2 | ZA0008 | 2024-10-24T12:13:23.289Z | 2024-10-31T12:29:54.956Z |
5348603 | 5348603 | 20241022183549_PRWMh | ZA0008 | 2024-10-24T12:11:47.982Z | 2024-10-31T12:29:53.134Z |
5348599 | 5348599 | 20241022183459_056n2 | ZA0008 | 2024-10-24T12:11:46.932Z | 2024-10-31T12:29:53.131Z |
5339375 | 5339375 | 20241021222836_M9snj | ZA0008 | 2024-10-23T12:13:02.805Z | 2024-10-30T12:26:44.063Z |
5339045 | 5339045 | 20241021214352_EQJ6P | ZA0008 | 2024-10-23T12:12:25.057Z | 2024-10-30T12:26:43.502Z |
5326887 | 5326887 | 20241019221206_BFeNz | ZA0008 | 2024-10-21T12:10:41.830Z | 2024-10-28T12:26:42.808Z |
5326818 | 5326818 | 20241019203941_T8A35 | ZA0008 | 2024-10-21T12:10:24.554Z | 2024-10-28T12:26:42.537Z |
5326810 | 5326810 | 20241019202843_jjnT4 | ZA0008 | 2024-10-21T12:10:23.429Z | 2024-10-28T12:26:42.518Z |
5326558 | 5326558 | 20241019190003_bpAlm | ZA0008 | 2024-10-21T12:09:54.890Z | 2024-10-28T12:26:42.045Z |
5326211 | 5326211 | 20241020224937_BW36V | ZA0008 | 2024-10-21T12:07:49.448Z | 2024-10-29T12:26:33.903Z |
5326206 | 5326206 | 20241020220856_BelTq | ZA0008 | 2024-10-21T12:07:48.690Z | 2024-10-29T12:26:33.781Z |
5326199 | 5326199 | 20241020212048_klFGP | ZA0008 | 2024-10-21T12:07:47.989Z | 2024-10-29T12:26:33.620Z |
5326191 | 5326191 | 20241020204221_ivu99 | ZA0008 | 2024-10-21T12:07:46.858Z | 2024-10-29T12:26:33.504Z |
5326007 | 5326007 | 20241020190157_9PaqJ | ZA0008 | 2024-10-21T12:07:29.737Z | 2024-10-29T12:26:32.987Z |
5318141 | 5318141 | 20241016220316_JiOJV | ZA0008 | 2024-10-18T12:02:59.493Z | 2024-10-25T12:24:33.478Z |
5318131 | 5318131 | 20241016214419_X5xvs | ZA0008 | 2024-10-18T12:02:57.919Z | 2024-10-25T12:24:33.420Z |
5317963 | 5317963 | 20241017181902_DkDS3 | ZA0008 | 2024-10-18T12:01:20.681Z | 2024-10-26T12:27:52.276Z |
5317959 | 5317959 | 20241017180733_TcxfG | ZA0008 | 2024-10-18T12:01:20.144Z | 2024-10-26T12:27:52.231Z |
5316466 | 5316466 | 20241015220934_WrITs | ZA0008 | 2024-10-17T12:06:42.226Z | 2024-10-24T12:27:56.573Z |
5316436 | 5316436 | 20241015214642_3p37t | ZA0008 | 2024-10-17T12:06:40.240Z | 2024-10-24T12:27:56.508Z |
5316426 | 5316426 | 20241015213551_FftZ7 | ZA0008 | 2024-10-17T12:06:39.201Z | 2024-10-24T12:27:56.484Z |
5316411 | 5316411 | 20241015212212_0DPvT | ZA0008 | 2024-10-17T12:06:35.677Z | 2024-10-24T12:27:56.451Z |
5316388 | 5316388 | 20241015210054_q06Yc | ZA0008 | 2024-10-17T12:06:28.747Z | 2024-10-24T12:27:56.357Z |
5316289 | 5316289 | 20241015192506_aNe5X | ZA0008 | 2024-10-17T12:06:13.976Z | 2024-10-24T12:27:56.003Z |
5310933 | 5310933 | 20241014215713_v555r | ZA0008 | 2024-10-16T12:08:02.144Z | 2024-10-23T12:24:40.103Z |
5310914 | 5310914 | 20241014214231_VLkeQ | ZA0008 | 2024-10-16T12:08:00.497Z | 2024-10-23T12:24:39.969Z |
5310883 | 5310883 | 20241014211616_vgmws | ZA0008 | 2024-10-16T12:07:57.172Z | 2024-10-23T12:24:39.474Z |
5310815 | 5310815 | 20241014203712_g2MvM | ZA0008 | 2024-10-16T12:07:50.439Z | 2024-10-23T12:24:38.888Z |
5310579 | 5310579 | 20241014190112_oaerZ | ZA0008 | 2024-10-16T12:07:16.565Z | 2024-10-23T12:24:35.713Z |
5301124 | 5301124 | 20241012224342_qURHu | ZA0008 | 2024-10-14T12:14:53.319Z | 2024-10-21T12:23:55.460Z |
5300618 | 5300618 | 20241012210329_bvupi | ZA0008 | 2024-10-14T12:14:19.278Z | 2024-10-21T12:23:50.573Z |
5300396 | 5300396 | 20241012203358_oz4xk | ZA0008 | 2024-10-14T12:13:57.691Z | 2024-10-21T12:23:48.892Z |
5300220 | 5300220 | 20241012201348_mr9cg | ZA0008 | 2024-10-14T12:13:38.620Z | 2024-10-21T12:23:47.380Z |
5299401 | 5299401 | 20241012184353_VSPch | ZA0008 | 2024-10-14T12:12:14.183Z | 2024-10-21T12:23:38.570Z |
5299067 | 5299067 | 20241012180003_SZ2nt | ZA0008 | 2024-10-14T12:11:40.813Z | 2024-10-21T12:23:33.929Z |
5299011 | 5299011 | 20241012174756_P6wCp | ZA0008 | 2024-10-14T12:11:28.294Z | 2024-10-21T12:23:33.436Z |
5292135 | 5292135 | 20241011224228_HznCN | ZA0008 | 2024-10-13T12:15:44.129Z | 2024-10-20T12:24:40.578Z |
5292094 | 5292094 | 20241011223846_T0leV | ZA0008 | 2024-10-13T12:15:42.612Z | 2024-10-20T12:24:40.085Z |
5292079 | 5292079 | 20241011223647_5w2Qs | ZA0008 | 2024-10-13T12:15:41.879Z | 2024-10-20T12:24:39.976Z |
5292073 | 5292073 | 20241011223515_1mQAL | ZA0008 | 2024-10-13T12:15:41.471Z | 2024-10-20T12:24:39.935Z |
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);