participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
342 rows where station_code = "ZA0006" 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 |
---|---|---|---|---|---|
5467571 | 5467571 | 20241102215439_w4atx | ZA0006 | 2024-11-04T14:12:04.853Z | 2024-11-05T14:21:07.145Z |
5466741 | 5466741 | 20241102184403_7EpRW | ZA0006 | 2024-11-04T14:09:40.889Z | 2024-11-05T14:20:53.138Z |
5461847 | 5461847 | 20241101214740_iAkcp | ZA0006 | 2024-11-03T14:16:26.861Z | 2024-11-05T14:22:51.518Z |
5450892 | 5450892 | 20241031213452_SxY1X | ZA0006 | 2024-11-02T12:16:12.513Z | 2024-11-05T14:24:06.068Z |
5450814 | 5450814 | 20241031211339_rIeei | ZA0006 | 2024-11-02T12:15:58.608Z | 2024-11-05T14:24:05.037Z |
5450681 | 5450681 | 20241031201812_n3KLQ | ZA0006 | 2024-11-02T12:15:44.259Z | 2024-11-05T14:24:03.291Z |
5450666 | 5450666 | 20241031201402_u6JL1 | ZA0006 | 2024-11-02T12:15:43.254Z | 2024-11-05T14:24:03.184Z |
5450415 | 5450415 | 20241031191323_d3ARN | ZA0006 | 2024-11-02T12:15:14.641Z | 2024-11-05T14:24:01.162Z |
5450322 | 5450322 | 20241031184254_tW0UA | ZA0006 | 2024-11-02T12:14:58.351Z | 2024-11-05T14:24:00.504Z |
5441352 | 5441352 | 20241029215006_A52Y2 | ZA0006 | 2024-11-01T12:18:28.703Z | 2024-11-05T14:26:00.017Z |
5441136 | 5441136 | 20241029205521_34EKs | ZA0006 | 2024-11-01T12:18:09.971Z | 2024-11-05T14:25:58.528Z |
5441110 | 5441110 | 20241029204825_u3DTu | ZA0006 | 2024-11-01T12:18:07.373Z | 2024-11-05T14:25:58.097Z |
5433428 | 5433428 | 20241029195608_G3tf3 | ZA0006 | 2024-10-31T12:22:14.858Z | 2024-11-05T14:25:56.264Z |
5433273 | 5433273 | 20241029184353_LWFQH | ZA0006 | 2024-10-31T12:22:03.300Z | 2024-11-05T14:25:54.567Z |
5429801 | 5429801 | 20241028200702_8di5S | ZA0006 | 2024-10-31T12:17:03.266Z | 2024-11-05T14:26:32.643Z |
5429706 | 5429706 | 20241028195227_MGgD2 | ZA0006 | 2024-10-31T12:16:56.052Z | 2024-11-05T14:26:32.545Z |
5403814 | 5403814 | 20241026223306_2zrGO | ZA0006 | 2024-10-29T12:10:15.550Z | 2024-11-04T14:28:49.785Z |
5403741 | 5403741 | 20241026222708_ZZjbm | ZA0006 | 2024-10-29T12:10:10.868Z | 2024-11-04T14:28:49.532Z |
5403722 | 5403722 | 20241026222515_iC7rO | ZA0006 | 2024-10-29T12:10:09.841Z | 2024-11-04T14:28:49.520Z |
5403703 | 5403703 | 20241026222408_glSJJ | ZA0006 | 2024-10-29T12:10:08.507Z | 2024-11-04T14:28:49.501Z |
5403589 | 5403589 | 20241026221427_4OxyI | ZA0006 | 2024-10-29T12:10:00.608Z | 2024-11-04T14:28:49.294Z |
5403181 | 5403181 | 20241026212640_2n4Bl | ZA0006 | 2024-10-29T12:09:10.978Z | 2024-11-04T14:28:47.927Z |
5395000 | 5395000 | 20241025215832_E55gh | ZA0006 | 2024-10-28T12:15:52.409Z | 2024-11-03T14:27:23.633Z |
5394877 | 5394877 | 20241025213844_3t6Xp | ZA0006 | 2024-10-28T12:15:36.653Z | 2024-11-03T14:27:23.256Z |
5394724 | 5394724 | 20241025211613_Tvbh9 | ZA0006 | 2024-10-28T12:15:18.164Z | 2024-11-03T14:27:22.411Z |
5394599 | 5394599 | 20241025205519_RMESS | ZA0006 | 2024-10-28T12:15:03.113Z | 2024-11-03T14:27:21.796Z |
5394532 | 5394532 | 20241025204616_ax4G3 | ZA0006 | 2024-10-28T12:14:51.581Z | 2024-11-03T14:27:21.467Z |
5394361 | 5394361 | 20241025202115_EEVmn | ZA0006 | 2024-10-28T12:14:29.426Z | 2024-11-03T14:27:21.016Z |
5394334 | 5394334 | 20241025201642_veGmb | ZA0006 | 2024-10-28T12:14:23.915Z | 2024-11-03T14:27:20.912Z |
5393897 | 5393897 | 20241025190622_4D0mz | ZA0006 | 2024-10-28T12:13:49.534Z | 2024-11-03T14:27:18.836Z |
5385042 | 5385042 | 20241024214032_IJ5nW | ZA0006 | 2024-10-27T12:18:16.991Z | 2024-11-02T12:28:28.982Z |
5385016 | 5385016 | 20241024213744_rwcAh | ZA0006 | 2024-10-27T12:18:13.719Z | 2024-11-02T12:28:28.932Z |
5385006 | 5385006 | 20241024213509_nNDZf | ZA0006 | 2024-10-27T12:18:11.794Z | 2024-11-02T12:28:28.914Z |
5384979 | 5384979 | 20241024213013_96eHx | ZA0006 | 2024-10-27T12:18:06.707Z | 2024-11-02T12:28:28.839Z |
5384945 | 5384945 | 20241024211937_2O8wb | ZA0006 | 2024-10-27T12:18:02.417Z | 2024-11-02T12:28:28.776Z |
5384854 | 5384854 | 20241024210419_6IENG | ZA0006 | 2024-10-27T12:17:50.765Z | 2024-11-02T12:28:28.514Z |
5384599 | 5384599 | 20241024202718_giTrr | ZA0006 | 2024-10-27T12:17:16.253Z | 2024-11-02T12:28:27.384Z |
5384421 | 5384421 | 20241024200643_vV1em | ZA0006 | 2024-10-27T12:17:02.245Z | 2024-11-02T12:28:27.192Z |
5384334 | 5384334 | 20241024195644_we08O | ZA0006 | 2024-10-27T12:16:57.272Z | 2024-11-02T12:28:26.967Z |
5383557 | 5383557 | 20241024183310_FUkG5 | ZA0006 | 2024-10-27T12:15:44.247Z | 2024-11-02T12:28:25.756Z |
5371884 | 5371884 | 20241023191345_sS6NB | ZA0006 | 2024-10-26T12:16:49.008Z | 2024-11-01T12:26:51.058Z |
5363796 | 5363796 | 20241023214512_VaPBS | ZA0006 | 2024-10-25T12:16:46.994Z | 2024-11-01T12:26:53.636Z |
5363743 | 5363743 | 20241023214003_vpeLk | ZA0006 | 2024-10-25T12:16:40.740Z | 2024-11-01T12:26:53.590Z |
5363464 | 5363464 | 20241023210629_8tjEG | ZA0006 | 2024-10-25T12:16:13.749Z | 2024-11-01T12:26:53.311Z |
5363211 | 5363211 | 20241023203634_p2hJ6 | ZA0006 | 2024-10-25T12:15:41.493Z | 2024-11-01T12:26:52.961Z |
5363140 | 5363140 | 20241023203013_ED7Ct | ZA0006 | 2024-10-25T12:15:32.100Z | 2024-11-01T12:26:52.877Z |
5362837 | 5362837 | 20241023200424_nxhLD | ZA0006 | 2024-10-25T12:15:12.003Z | 2024-11-01T12:26:52.473Z |
5362652 | 5362652 | 20241023195141_O0uVh | ZA0006 | 2024-10-25T12:14:55.905Z | 2024-11-01T12:26:52.181Z |
5362534 | 5362534 | 20241023193926_7DcX2 | ZA0006 | 2024-10-25T12:14:40.197Z | 2024-11-01T12:26:51.902Z |
5361641 | 5361641 | 20241023183225_bARBC | ZA0006 | 2024-10-25T12:13:03.781Z | 2024-11-01T12:26:50.402Z |
5361607 | 5361607 | 20241023182839_C2pY5 | ZA0006 | 2024-10-25T12:13:00.641Z | 2024-11-01T12:26:50.375Z |
5361477 | 5361477 | 20241023182029_vfBtV | ZA0006 | 2024-10-25T12:12:44.544Z | 2024-11-01T12:26:50.192Z |
5350878 | 5350878 | 20241022223735_5MTJF | ZA0006 | 2024-10-24T12:16:44.609Z | 2024-10-31T12:29:58.977Z |
5350788 | 5350788 | 20241022222904_AbLhf | ZA0006 | 2024-10-24T12:16:33.248Z | 2024-10-31T12:29:58.790Z |
5350785 | 5350785 | 20241022222753_OGDL7 | ZA0006 | 2024-10-24T12:16:33.042Z | 2024-10-31T12:29:58.786Z |
5350583 | 5350583 | 20241022220517_pyAjY | ZA0006 | 2024-10-24T12:16:01.074Z | 2024-10-31T12:29:58.492Z |
5350456 | 5350456 | 20241022215158_AgLGv | ZA0006 | 2024-10-24T12:15:46.634Z | 2024-10-31T12:29:58.209Z |
5350025 | 5350025 | 20241022210254_gpmMV | ZA0006 | 2024-10-24T12:15:07.136Z | 2024-10-31T12:29:57.193Z |
5349919 | 5349919 | 20241022204902_AP5cm | ZA0006 | 2024-10-24T12:14:48.461Z | 2024-10-31T12:29:56.923Z |
5349843 | 5349843 | 20241022204028_OE1JO | ZA0006 | 2024-10-24T12:14:42.953Z | 2024-10-31T12:29:56.782Z |
5349262 | 5349262 | 20241022193757_KD2r3 | ZA0006 | 2024-10-24T12:13:22.568Z | 2024-10-31T12:29:54.950Z |
5339374 | 5339374 | 20241021222836_M9snj | ZA0006 | 2024-10-23T12:13:02.805Z | 2024-10-30T12:26:44.063Z |
5339044 | 5339044 | 20241021214352_EQJ6P | ZA0006 | 2024-10-23T12:12:25.057Z | 2024-10-30T12:26:43.502Z |
5338572 | 5338572 | 20241021200036_izdfL | ZA0006 | 2024-10-23T12:11:24.420Z | 2024-10-30T12:26:42.510Z |
5338295 | 5338295 | 20241021190849_Z8Vap | ZA0006 | 2024-10-23T12:10:39.992Z | 2024-10-30T12:26:42.133Z |
5326886 | 5326886 | 20241019221206_BFeNz | ZA0006 | 2024-10-21T12:10:41.830Z | 2024-10-28T12:26:42.808Z |
5326861 | 5326861 | 20241019213110_3dmtO | ZA0006 | 2024-10-21T12:10:33.820Z | 2024-10-28T12:26:42.782Z |
5326824 | 5326824 | 20241019204946_IIHCL | ZA0006 | 2024-10-21T12:10:25.353Z | 2024-10-28T12:26:42.567Z |
5326817 | 5326817 | 20241019203941_T8A35 | ZA0006 | 2024-10-21T12:10:24.554Z | 2024-10-28T12:26:42.537Z |
5326809 | 5326809 | 20241019202843_jjnT4 | ZA0006 | 2024-10-21T12:10:23.429Z | 2024-10-28T12:26:42.518Z |
5326735 | 5326735 | 20241019195547_AcAt6 | ZA0006 | 2024-10-21T12:10:13.955Z | 2024-10-28T12:26:42.350Z |
5326557 | 5326557 | 20241019190003_bpAlm | ZA0006 | 2024-10-21T12:09:54.890Z | 2024-10-28T12:26:42.045Z |
5326209 | 5326209 | 20241020224100_CVEeW | ZA0006 | 2024-10-21T12:07:49.162Z | 2024-10-29T12:26:33.871Z |
5326207 | 5326207 | 20241020224015_2xnWZ | ZA0006 | 2024-10-21T12:07:48.953Z | 2024-10-29T12:26:33.868Z |
5326203 | 5326203 | 20241020213924_ssEOv | ZA0006 | 2024-10-21T12:07:48.448Z | 2024-10-29T12:26:33.707Z |
5326197 | 5326197 | 20241020210958_phxrR | ZA0006 | 2024-10-21T12:07:47.710Z | 2024-10-29T12:26:33.606Z |
5326195 | 5326195 | 20241020210229_I0ZXw | ZA0006 | 2024-10-21T12:07:47.474Z | 2024-10-29T12:26:33.599Z |
5326192 | 5326192 | 20241020204435_756ew | ZA0006 | 2024-10-21T12:07:47.166Z | 2024-10-29T12:26:33.505Z |
5318140 | 5318140 | 20241016220316_JiOJV | ZA0006 | 2024-10-18T12:02:59.493Z | 2024-10-25T12:24:33.478Z |
5316409 | 5316409 | 20241015212212_0DPvT | ZA0006 | 2024-10-17T12:06:35.677Z | 2024-10-24T12:27:56.451Z |
5316386 | 5316386 | 20241015210054_q06Yc | ZA0006 | 2024-10-17T12:06:28.657Z | 2024-10-24T12:27:56.357Z |
5311042 | 5311042 | 20241014224057_G3CNj | ZA0006 | 2024-10-16T12:08:11.823Z | 2024-10-23T12:24:40.794Z |
5310999 | 5310999 | 20241014222332_JwSQU | ZA0006 | 2024-10-16T12:08:06.610Z | 2024-10-23T12:24:40.531Z |
5310973 | 5310973 | 20241014220941_3z8o2 | ZA0006 | 2024-10-16T12:08:05.035Z | 2024-10-23T12:24:40.410Z |
5310932 | 5310932 | 20241014215713_v555r | ZA0006 | 2024-10-16T12:08:02.144Z | 2024-10-23T12:24:40.103Z |
5310913 | 5310913 | 20241014214231_VLkeQ | ZA0006 | 2024-10-16T12:08:00.497Z | 2024-10-23T12:24:39.969Z |
5310577 | 5310577 | 20241014190112_oaerZ | ZA0006 | 2024-10-16T12:07:16.562Z | 2024-10-23T12:24:35.713Z |
5301123 | 5301123 | 20241012224342_qURHu | ZA0006 | 2024-10-14T12:14:53.319Z | 2024-10-21T12:23:55.460Z |
5300864 | 5300864 | 20241012220230_Nuz59 | ZA0006 | 2024-10-14T12:14:33.295Z | 2024-10-21T12:23:53.516Z |
5300617 | 5300617 | 20241012210329_bvupi | ZA0006 | 2024-10-14T12:14:19.278Z | 2024-10-21T12:23:50.573Z |
5299950 | 5299950 | 20241012194956_gp1DC | ZA0006 | 2024-10-14T12:13:19.790Z | 2024-10-21T12:23:45.237Z |
5299400 | 5299400 | 20241012184353_VSPch | ZA0006 | 2024-10-14T12:12:14.183Z | 2024-10-21T12:23:38.570Z |
5299010 | 5299010 | 20241012174756_P6wCp | ZA0006 | 2024-10-14T12:11:28.261Z | 2024-10-21T12:23:33.436Z |
5292134 | 5292134 | 20241011224228_HznCN | ZA0006 | 2024-10-13T12:15:44.129Z | 2024-10-20T12:24:40.578Z |
5292071 | 5292071 | 20241011223515_1mQAL | ZA0006 | 2024-10-13T12:15:41.471Z | 2024-10-20T12:24:39.934Z |
5291736 | 5291736 | 20241011215150_7u2R2 | ZA0006 | 2024-10-13T12:15:06.860Z | 2024-10-20T12:24:35.561Z |
5291687 | 5291687 | 20241011214233_CGhIh | ZA0006 | 2024-10-13T12:14:59.610Z | 2024-10-20T12:24:34.858Z |
5291578 | 5291578 | 20241011212320_Owcwi | ZA0006 | 2024-10-13T12:14:49.251Z | 2024-10-20T12:24:33.417Z |
5291475 | 5291475 | 20241011210245_7UW7H | ZA0006 | 2024-10-13T12:14:38.162Z | 2024-10-20T12:24:31.867Z |
5291405 | 5291405 | 20241011204947_8zOtv | ZA0006 | 2024-10-13T12:14:27.744Z | 2024-10-20T12:24:30.254Z |
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);