participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
984 rows where station_code = "NZ004S" 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 |
---|---|---|---|---|---|
5134503 | 5134503 | 20240916095414_C2pin | NZ004S | 2024-09-19T12:17:47.315Z | 2024-09-19T12:17:47.315Z |
5130138 | 5130138 | 20240917092445_3gNTI | NZ004S | 2024-09-19T12:12:39.173Z | 2024-09-19T12:12:39.173Z |
5130089 | 5130089 | 20240917085121_0ZR5r | NZ004S | 2024-09-19T12:12:33.480Z | 2024-09-19T12:12:33.480Z |
5108866 | 5108866 | 20240913075046_v4x0X | NZ004S | 2024-09-17T12:14:11.884Z | 2024-09-19T12:20:50.961Z |
5083421 | 5083421 | 20240911131507_LwJpt | NZ004S | 2024-09-15T12:18:41.884Z | 2024-09-19T12:21:49.577Z |
5083337 | 5083337 | 20240911125741_p8knK | NZ004S | 2024-09-15T12:18:39.594Z | 2024-09-19T12:21:49.487Z |
5083235 | 5083235 | 20240911123346_MDwJO | NZ004S | 2024-09-15T12:18:37.264Z | 2024-09-19T12:21:49.419Z |
5083145 | 5083145 | 20240911121453_3zxT4 | NZ004S | 2024-09-15T12:18:36.159Z | 2024-09-19T12:21:49.357Z |
5082465 | 5082465 | 20240911101110_dcnsN | NZ004S | 2024-09-15T12:18:15.494Z | 2024-09-19T12:21:47.979Z |
5071552 | 5071552 | 20240911171520_iJ6wk | NZ004S | 2024-09-15T12:02:54.391Z | 2024-09-19T12:21:02.094Z |
5071504 | 5071504 | 20240911170909_SfFQ1 | NZ004S | 2024-09-15T12:02:43.690Z | 2024-09-19T12:21:02.023Z |
5071255 | 5071255 | 20240911162210_RB7fq | NZ004S | 2024-09-15T12:02:01.724Z | 2024-09-19T12:21:01.321Z |
5071198 | 5071198 | 20240911161423_8aKT5 | NZ004S | 2024-09-15T12:01:52.641Z | 2024-09-19T12:21:01.203Z |
5071154 | 5071154 | 20240911160846_tSt4T | NZ004S | 2024-09-15T12:01:48.503Z | 2024-09-19T12:21:01.123Z |
5070985 | 5070985 | 20240911153819_0jhhe | NZ004S | 2024-09-15T12:01:18.369Z | 2024-09-19T12:21:00.696Z |
5070978 | 5070978 | 20240911153729_lXflG | NZ004S | 2024-09-15T12:01:17.557Z | 2024-09-19T12:21:00.665Z |
5070892 | 5070892 | 20240911152501_StjdP | NZ004S | 2024-09-15T12:01:05.104Z | 2024-09-19T12:21:00.495Z |
5070828 | 5070828 | 20240911151413_8QFC6 | NZ004S | 2024-09-15T12:00:57.699Z | 2024-09-19T12:21:00.367Z |
5070815 | 5070815 | 20240911151221_7BjeF | NZ004S | 2024-09-15T12:00:55.876Z | 2024-09-19T12:21:00.326Z |
5070763 | 5070763 | 20240911150745_HZ24e | NZ004S | 2024-09-15T12:00:46.816Z | 2024-09-19T12:21:00.210Z |
5070413 | 5070413 | 20240908164140_2BKif | NZ004S | 2024-09-14T12:20:37.907Z | 2024-09-17T12:18:56.094Z |
5068961 | 5068961 | 20240910131323_DeQfp | NZ004S | 2024-09-14T12:19:23.295Z | 2024-09-18T12:15:26.897Z |
5068947 | 5068947 | 20240910131041_hDi7h | NZ004S | 2024-09-14T12:19:23.165Z | 2024-09-18T12:15:26.882Z |
5068918 | 5068918 | 20240910125924_hOAk2 | NZ004S | 2024-09-14T12:19:22.900Z | 2024-09-18T12:15:26.847Z |
5068915 | 5068915 | 20240910125858_AOVG7 | NZ004S | 2024-09-14T12:19:22.842Z | 2024-09-18T12:15:26.845Z |
5068910 | 5068910 | 20240910125759_2E384 | NZ004S | 2024-09-14T12:19:22.800Z | 2024-09-18T12:15:26.813Z |
5068591 | 5068591 | 20240910115235_3VDJx | NZ004S | 2024-09-14T12:19:18.906Z | 2024-09-18T12:15:26.348Z |
5068446 | 5068446 | 20240910113325_9SWJk | NZ004S | 2024-09-14T12:19:15.678Z | 2024-09-18T12:15:26.158Z |
5068166 | 5068166 | 20240910110529_pB338 | NZ004S | 2024-09-14T12:19:10.215Z | 2024-09-18T12:15:25.705Z |
5067441 | 5067441 | 20240910093224_pNPGD | NZ004S | 2024-09-14T12:18:43.890Z | 2024-09-18T12:15:24.115Z |
5061019 | 5061019 | 20240909135250_2E6lq | NZ004S | 2024-09-14T12:10:06.191Z | 2024-09-18T12:15:07.825Z |
5060847 | 5060847 | 20240909130407_igUSj | NZ004S | 2024-09-14T12:09:48.819Z | 2024-09-18T12:15:06.894Z |
5059256 | 5059256 | 20240910172654_4yL3z | NZ004S | 2024-09-14T12:05:32.670Z | 2024-09-19T12:21:30.472Z |
5059130 | 5059130 | 20240910171528_kEwuU | NZ004S | 2024-09-14T12:05:17.380Z | 2024-09-19T12:21:30.378Z |
5058699 | 5058699 | 20240910163813_DWYzt | NZ004S | 2024-09-14T12:04:21.436Z | 2024-09-19T12:21:29.906Z |
5058349 | 5058349 | 20240910160606_K5gE2 | NZ004S | 2024-09-14T12:03:34.130Z | 2024-09-19T12:21:29.448Z |
5058038 | 5058038 | 20240910153906_zde8D | NZ004S | 2024-09-14T12:02:41.781Z | 2024-09-19T12:21:29.035Z |
5057690 | 5057690 | 20240910150430_r4edx | NZ004S | 2024-09-14T12:01:44.281Z | 2024-09-19T12:21:28.581Z |
5057219 | 5057219 | 20240910140005_7Js9N | NZ004S | 2024-09-14T12:00:33.205Z | 2024-09-19T12:21:27.316Z |
5056897 | 5056897 | 20240908113712_bs7pg | NZ004S | 2024-09-13T12:17:40.755Z | 2024-09-16T12:21:27.681Z |
5056632 | 5056632 | 20240908105351_pAnU3 | NZ004S | 2024-09-13T12:17:36.457Z | 2024-09-16T12:21:26.261Z |
5056439 | 5056439 | 20240908102941_yJuvq | NZ004S | 2024-09-13T12:17:32.118Z | 2024-09-16T12:21:25.409Z |
5055255 | 5055255 | 20240908073435_aLbGM | NZ004S | 2024-09-13T12:17:08.489Z | 2024-09-16T12:21:18.550Z |
5045565 | 5045565 | 20240908172412_P3Civ | NZ004S | 2024-09-13T12:04:22.166Z | 2024-09-17T12:18:56.799Z |
5045472 | 5045472 | 20240908170928_UWOIR | NZ004S | 2024-09-13T12:04:12.158Z | 2024-09-17T12:18:56.614Z |
5045401 | 5045401 | 20240908170052_yPVhL | NZ004S | 2024-09-13T12:04:05.745Z | 2024-09-17T12:18:56.457Z |
5045368 | 5045368 | 20240908165832_Wjm9B | NZ004S | 2024-09-13T12:04:03.259Z | 2024-09-17T12:18:56.418Z |
5045347 | 5045347 | 20240908165455_XcOgJ | NZ004S | 2024-09-13T12:04:00.745Z | 2024-09-17T12:18:56.382Z |
5045251 | 5045251 | 20240908164313_lsHi8 | NZ004S | 2024-09-13T12:03:46.427Z | 2024-09-17T12:18:56.131Z |
5044763 | 5044763 | 20240908153952_EAWCW | NZ004S | 2024-09-13T12:02:54.200Z | 2024-09-17T12:18:54.961Z |
5044654 | 5044654 | 20240908152647_c0G6G | NZ004S | 2024-09-13T12:02:43.193Z | 2024-09-17T12:18:54.795Z |
5044084 | 5044084 | 20240908141151_5hZ9c | NZ004S | 2024-09-13T12:01:25.847Z | 2024-09-17T12:18:53.497Z |
5044014 | 5044014 | 20240908135325_bnsNF | NZ004S | 2024-09-13T12:01:15.090Z | 2024-09-17T12:18:53.310Z |
5043886 | 5043886 | 20240908133112_I3MSS | NZ004S | 2024-09-13T12:00:54.447Z | 2024-09-17T12:18:53.000Z |
5043881 | 5043881 | 20240908133049_MywfG | NZ004S | 2024-09-13T12:00:53.529Z | 2024-09-17T12:18:52.989Z |
5043817 | 5043817 | 20240908131543_M7rmr | NZ004S | 2024-09-13T12:00:44.647Z | 2024-09-17T12:18:52.898Z |
5043780 | 5043780 | 20240908130459_m5t0R | NZ004S | 2024-09-13T12:00:39.108Z | 2024-09-17T12:18:52.826Z |
5042656 | 5042656 | 20240907122202_E2Vjy | NZ004S | 2024-09-12T12:17:16.580Z | 2024-09-16T12:20:53.875Z |
5042383 | 5042383 | 20240906104551_1oWm2 | NZ004S | 2024-09-12T12:17:01.650Z | 2024-09-14T12:23:17.179Z |
5042232 | 5042232 | 20240906101240_NziLx | NZ004S | 2024-09-12T12:16:58.080Z | 2024-09-14T12:23:16.604Z |
5042105 | 5042105 | 20240906095515_C5vRI | NZ004S | 2024-09-12T12:16:55.506Z | 2024-09-14T12:23:16.017Z |
5041946 | 5041946 | 20240906092955_onx7m | NZ004S | 2024-09-12T12:16:52.920Z | 2024-09-14T12:23:15.405Z |
5041130 | 5041130 | 20240906072441_GTDHa | NZ004S | 2024-09-12T12:16:34.327Z | 2024-09-14T12:23:11.827Z |
5038111 | 5038111 | 20240905172604_FmXH2 | NZ004S | 2024-09-12T12:14:22.933Z | 2024-09-14T12:22:55.082Z |
5037959 | 5037959 | 20240905170841_EtCYw | NZ004S | 2024-09-12T12:14:17.992Z | 2024-09-14T12:22:54.841Z |
5037892 | 5037892 | 20240905165939_MCXHi | NZ004S | 2024-09-12T12:14:16.817Z | 2024-09-14T12:22:54.759Z |
5037664 | 5037664 | 20240905163031_mpbiG | NZ004S | 2024-09-12T12:14:13.513Z | 2024-09-14T12:22:54.487Z |
5037552 | 5037552 | 20240905160743_QWYaw | NZ004S | 2024-09-12T12:14:08.550Z | 2024-09-14T12:22:54.298Z |
5037502 | 5037502 | 20240905160150_0KWZp | NZ004S | 2024-09-12T12:14:07.622Z | 2024-09-14T12:22:54.235Z |
5037445 | 5037445 | 20240905155536_jeGDu | NZ004S | 2024-09-12T12:14:06.712Z | 2024-09-14T12:22:54.197Z |
5037314 | 5037314 | 20240905153602_9bUHu | NZ004S | 2024-09-12T12:14:04.807Z | 2024-09-14T12:22:54.092Z |
5037145 | 5037145 | 20240905151509_hhYrt | NZ004S | 2024-09-12T12:14:01.740Z | 2024-09-14T12:22:53.803Z |
5037042 | 5037042 | 20240905145754_RJtQL | NZ004S | 2024-09-12T12:13:59.614Z | 2024-09-14T12:22:53.645Z |
5036849 | 5036849 | 20240905143433_sIaqx | NZ004S | 2024-09-12T12:13:55.768Z | 2024-09-14T12:22:53.295Z |
5036314 | 5036314 | 20240905131410_sg2Z8 | NZ004S | 2024-09-12T12:13:34.584Z | 2024-09-14T12:22:52.269Z |
5036307 | 5036307 | 20240905131334_HO0is | NZ004S | 2024-09-12T12:13:34.077Z | 2024-09-14T12:22:52.261Z |
5030209 | 5030209 | 20240906134236_rSCFs | NZ004S | 2024-09-12T12:01:26.835Z | 2024-09-15T12:21:18.255Z |
5029852 | 5029852 | 20240906113758_V2Rro | NZ004S | 2024-09-12T12:00:38.934Z | 2024-09-15T12:21:17.412Z |
5029481 | 5029481 | 20240905094535_WXAkp | NZ004S | 2024-09-11T12:16:40.304Z | 2024-09-13T12:20:06.348Z |
5029150 | 5029150 | 20240905113723_3qzKq | NZ004S | 2024-09-11T12:16:14.779Z | 2024-09-14T12:22:51.111Z |
5023804 | 5023804 | 20240905170841_GkuDL | NZ004S | 2024-09-10T12:16:50.327Z | 2024-09-14T12:22:54.839Z |
5023735 | 5023735 | 20240905165939_tmDPx | NZ004S | 2024-09-10T12:16:49.699Z | 2024-09-11T12:16:31.759Z |
5023522 | 5023522 | 20240905163031_2gf5K | NZ004S | 2024-09-10T12:16:47.021Z | 2024-09-11T12:16:31.689Z |
5023443 | 5023443 | 20240905161012_0xy5t | NZ004S | 2024-09-10T12:16:45.216Z | 2024-09-14T12:22:54.310Z |
5023425 | 5023425 | 20240905160743_HIdlR | NZ004S | 2024-09-10T12:16:44.883Z | 2024-09-11T12:16:31.653Z |
5023377 | 5023377 | 20240905160150_5KELX | NZ004S | 2024-09-10T12:16:44.058Z | 2024-09-14T12:22:54.233Z |
5023317 | 5023317 | 20240905155536_nJNBR | NZ004S | 2024-09-10T12:16:43.332Z | 2024-09-11T12:16:31.621Z |
5023193 | 5023193 | 20240905153602_Amy86 | NZ004S | 2024-09-10T12:16:40.483Z | 2024-09-11T12:16:31.572Z |
5022910 | 5022910 | 20240905094535_cskrl | NZ004S | 2024-09-10T12:16:31.980Z | 2024-09-11T12:15:17.326Z |
5018374 | 5018374 | 20240904175007_0WIar | NZ004S | 2024-09-10T12:10:31.816Z | 2024-09-13T12:19:47.659Z |
5018307 | 5018307 | 20240904173820_gpBp3 | NZ004S | 2024-09-10T12:10:22.210Z | 2024-09-13T12:19:47.517Z |
5018164 | 5018164 | 20240904171644_4xf67 | NZ004S | 2024-09-10T12:10:05.401Z | 2024-09-13T12:19:47.339Z |
5018107 | 5018107 | 20240904171131_uhtCc | NZ004S | 2024-09-10T12:10:00.348Z | 2024-09-13T12:19:47.207Z |
5018005 | 5018005 | 20240904170452_RIGIi | NZ004S | 2024-09-10T12:09:51.303Z | 2024-09-13T12:19:47.158Z |
5017579 | 5017579 | 20240904162056_G9UPr | NZ004S | 2024-09-10T12:09:17.849Z | 2024-09-13T12:19:46.946Z |
5017395 | 5017395 | 20240904160451_Ijewy | NZ004S | 2024-09-10T12:09:07.632Z | 2024-09-13T12:19:46.843Z |
5016993 | 5016993 | 20240904151947_7FbuG | NZ004S | 2024-09-10T12:08:37.713Z | 2024-09-13T12:19:46.488Z |
5016095 | 5016095 | 20240904133100_8spUf | NZ004S | 2024-09-10T12:07:21.294Z | 2024-09-13T12:19:45.244Z |
5015986 | 5015986 | 20240904131428_pIUyV | NZ004S | 2024-09-10T12:07:08.286Z | 2024-09-13T12:19:45.089Z |
5015912 | 5015912 | 20240904130036_gyA8a | NZ004S | 2024-09-10T12:06:58.531Z | 2024-09-13T12:19:44.926Z |
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);