participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
3,946 rows where station_code = "NZ0038" 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 |
---|---|---|---|---|---|
5083652 | 5083652 | 20240911140445_te0K3 | NZ0038 | 2024-09-15T12:18:45.070Z | 2024-09-16T12:19:19.851Z |
5083633 | 5083633 | 20240911140122_GFR1G | NZ0038 | 2024-09-15T12:18:44.814Z | 2024-09-16T12:19:19.798Z |
5083631 | 5083631 | 20240911140103_Y2fo2 | NZ0038 | 2024-09-15T12:18:44.810Z | 2024-09-16T12:19:19.788Z |
5083555 | 5083555 | 20240911134735_XGvzj | NZ0038 | 2024-09-15T12:18:43.944Z | 2024-09-16T12:19:19.480Z |
5083303 | 5083303 | 20240911125150_xqiad | NZ0038 | 2024-09-15T12:18:38.648Z | 2024-09-16T12:19:17.897Z |
5083283 | 5083283 | 20240911124444_r4uGk | NZ0038 | 2024-09-15T12:18:38.206Z | 2024-09-16T12:19:17.703Z |
5083133 | 5083133 | 20240911121357_33Hbp | NZ0038 | 2024-09-15T12:18:36.067Z | 2024-09-16T12:19:16.871Z |
5083076 | 5083076 | 20240911115442_oeX7c | NZ0038 | 2024-09-15T12:18:34.893Z | 2024-09-16T12:19:16.573Z |
5082617 | 5082617 | 20240911103550_r3FPH | NZ0038 | 2024-09-15T12:18:20.964Z | 2024-09-16T12:19:13.715Z |
5082590 | 5082590 | 20240911103015_Jl0v3 | NZ0038 | 2024-09-15T12:18:20.510Z | 2024-09-16T12:19:13.637Z |
5082498 | 5082498 | 20240911101724_D8ENL | NZ0038 | 2024-09-15T12:18:16.537Z | 2024-09-16T12:19:12.454Z |
5082446 | 5082446 | 20240911101022_OyRvU | NZ0038 | 2024-09-15T12:18:15.225Z | 2024-09-16T12:19:12.054Z |
5081388 | 5081388 | 20240911073338_ZPfF3 | NZ0038 | 2024-09-15T12:17:31.890Z | 2024-09-16T12:19:00.332Z |
5071484 | 5071484 | 20240911170120_jkBuq | NZ0038 | 2024-09-15T12:02:39.412Z | 2024-09-16T12:17:28.842Z |
5071461 | 5071461 | 20240911165900_nSqSf | NZ0038 | 2024-09-15T12:02:37.325Z | 2024-09-16T12:17:28.836Z |
5071262 | 5071262 | 20240911162327_Bcrsb | NZ0038 | 2024-09-15T12:02:04.173Z | 2024-09-16T12:17:28.771Z |
5071067 | 5071067 | 20240911155501_sJyc0 | NZ0038 | 2024-09-15T12:01:34.962Z | 2024-09-16T12:17:28.724Z |
5070885 | 5070885 | 20240911152309_Nknsg | NZ0038 | 2024-09-15T12:01:04.077Z | 2024-09-16T12:17:28.681Z |
5070811 | 5070811 | 20240911151204_0YjdS | NZ0038 | 2024-09-15T12:00:55.431Z | 2024-09-16T12:17:28.667Z |
5070799 | 5070799 | 20240911151111_i28M5 | NZ0038 | 2024-09-15T12:00:52.209Z | 2024-09-16T12:17:28.666Z |
5070738 | 5070738 | 20240911150149_bIID2 | NZ0038 | 2024-09-15T12:00:43.772Z | 2024-09-16T12:17:28.656Z |
5070630 | 5070630 | 20240911144254_4tP2V | NZ0038 | 2024-09-15T12:00:26.470Z | 2024-09-16T12:17:28.632Z |
5070519 | 5070519 | 20240911142647_cDtkW | NZ0038 | 2024-09-15T12:00:12.494Z | 2024-09-16T12:17:28.610Z |
5068765 | 5068765 | 20240910121921_vx88Z | NZ0038 | 2024-09-14T12:19:21.104Z | 2024-09-16T12:20:14.974Z |
5068756 | 5068756 | 20240910121758_2IsRa | NZ0038 | 2024-09-14T12:19:21.065Z | 2024-09-16T12:20:14.965Z |
5068546 | 5068546 | 20240910114707_2NsBc | NZ0038 | 2024-09-14T12:19:17.693Z | 2024-09-16T12:20:14.301Z |
5068535 | 5068535 | 20240910114622_IofJx | NZ0038 | 2024-09-14T12:19:17.172Z | 2024-09-16T12:20:14.283Z |
5068319 | 5068319 | 20240910111923_dd1vr | NZ0038 | 2024-09-14T12:19:11.982Z | 2024-09-16T12:20:13.383Z |
5068314 | 5068314 | 20240910111909_AcLbF | NZ0038 | 2024-09-14T12:19:11.957Z | 2024-09-16T12:20:13.378Z |
5067733 | 5067733 | 20240910100533_YXy32 | NZ0038 | 2024-09-14T12:18:55.412Z | 2024-09-16T12:20:11.459Z |
5067657 | 5067657 | 20240910095807_MKRUT | NZ0038 | 2024-09-14T12:18:53.261Z | 2024-09-16T12:20:10.615Z |
5067141 | 5067141 | 20240910085904_LHu33 | NZ0038 | 2024-09-14T12:18:33.543Z | 2024-09-16T12:20:07.461Z |
5066984 | 5066984 | 20240910083828_TW29J | NZ0038 | 2024-09-14T12:18:25.267Z | 2024-09-16T12:20:06.938Z |
5066743 | 5066743 | 20240910081137_KjpCb | NZ0038 | 2024-09-14T12:18:09.899Z | 2024-09-16T12:20:05.484Z |
5066629 | 5066629 | 20240910075751_68DFZ | NZ0038 | 2024-09-14T12:18:05.056Z | 2024-09-16T12:20:04.654Z |
5062332 | 5062332 | 20240909171055_zVlfO | NZ0038 | 2024-09-14T12:12:09.819Z | 2024-09-16T12:19:36.938Z |
5062279 | 5062279 | 20240909170652_rJSlz | NZ0038 | 2024-09-14T12:12:05.120Z | 2024-09-16T12:19:36.848Z |
5062087 | 5062087 | 20240909164308_T7XhD | NZ0038 | 2024-09-14T12:11:48.226Z | 2024-09-16T12:19:35.437Z |
5062034 | 5062034 | 20240909163440_fZ1K2 | NZ0038 | 2024-09-14T12:11:45.726Z | 2024-09-16T12:19:35.300Z |
5061871 | 5061871 | 20240909161532_fZn22 | NZ0038 | 2024-09-14T12:11:34.559Z | 2024-09-16T12:19:34.415Z |
5061717 | 5061717 | 20240909154728_BVQMA | NZ0038 | 2024-09-14T12:11:15.089Z | 2024-09-16T12:19:33.231Z |
5061669 | 5061669 | 20240909153915_unJiz | NZ0038 | 2024-09-14T12:11:08.584Z | 2024-09-16T12:19:32.967Z |
5061272 | 5061272 | 20240909143830_IRfGY | NZ0038 | 2024-09-14T12:10:39.363Z | 2024-09-16T12:19:30.228Z |
5061257 | 5061257 | 20240909143810_pVSh1 | NZ0038 | 2024-09-14T12:10:38.694Z | 2024-09-16T12:19:30.142Z |
5061146 | 5061146 | 20240909142227_mJwrI | NZ0038 | 2024-09-14T12:10:22.356Z | 2024-09-16T12:19:29.399Z |
5061136 | 5061136 | 20240909142145_3GwDU | NZ0038 | 2024-09-14T12:10:21.248Z | 2024-09-16T12:19:29.358Z |
5059300 | 5059300 | 20240910172917_iBU3F | NZ0038 | 2024-09-14T12:05:38.686Z | 2024-09-16T12:18:03.381Z |
5059178 | 5059178 | 20240910171954_mBNNE | NZ0038 | 2024-09-14T12:05:23.970Z | 2024-09-16T12:18:02.576Z |
5058879 | 5058879 | 20240910165404_iHxXS | NZ0038 | 2024-09-14T12:04:43.950Z | 2024-09-16T12:17:59.413Z |
5058623 | 5058623 | 20240910163153_AZVaE | NZ0038 | 2024-09-14T12:04:09.831Z | 2024-09-16T12:17:56.708Z |
5058560 | 5058560 | 20240910162630_rvDRB | NZ0038 | 2024-09-14T12:03:58.251Z | 2024-09-16T12:17:56.053Z |
5058240 | 5058240 | 20240910155621_qwPVB | NZ0038 | 2024-09-14T12:03:14.504Z | 2024-09-16T12:17:51.971Z |
5058135 | 5058135 | 20240910154715_RV5pR | NZ0038 | 2024-09-14T12:03:00.896Z | 2024-09-16T12:17:50.543Z |
5057983 | 5057983 | 20240910153309_9mGQg | NZ0038 | 2024-09-14T12:02:32.816Z | 2024-09-16T12:17:49.025Z |
5056559 | 5056559 | 20240908104112_d2HQh | NZ0038 | 2024-09-13T12:17:34.958Z | 2024-09-16T12:21:25.884Z |
5056510 | 5056510 | 20240908103717_FyeRI | NZ0038 | 2024-09-13T12:17:34.255Z | 2024-09-16T12:21:25.711Z |
5056321 | 5056321 | 20240908101147_RKwOo | NZ0038 | 2024-09-13T12:17:30.302Z | 2024-09-16T12:21:24.431Z |
5056150 | 5056150 | 20240908094710_j3vtz | NZ0038 | 2024-09-13T12:17:27.994Z | 2024-09-16T12:21:23.593Z |
5055710 | 5055710 | 20240908084545_SzyXK | NZ0038 | 2024-09-13T12:17:20.710Z | 2024-09-16T12:21:21.671Z |
5055698 | 5055698 | 20240908084205_YdmME | NZ0038 | 2024-09-13T12:17:20.433Z | 2024-09-16T12:21:21.650Z |
5055565 | 5055565 | 20240908082355_vKLWB | NZ0038 | 2024-09-13T12:17:17.167Z | 2024-09-16T12:21:20.374Z |
5051273 | 5051273 | 20240907171041_QRCiK | NZ0038 | 2024-09-13T12:14:08.286Z | 2024-09-16T12:21:00.000Z |
5051094 | 5051094 | 20240907164738_nFFx5 | NZ0038 | 2024-09-13T12:14:01.430Z | 2024-09-16T12:20:59.578Z |
5050750 | 5050750 | 20240907160357_G3xNJ | NZ0038 | 2024-09-13T12:13:45.970Z | 2024-09-16T12:20:58.481Z |
5050632 | 5050632 | 20240907155010_vsx4e | NZ0038 | 2024-09-13T12:13:41.266Z | 2024-09-16T12:20:58.178Z |
5050620 | 5050620 | 20240907154819_MeWYT | NZ0038 | 2024-09-13T12:13:40.416Z | 2024-09-16T12:20:58.102Z |
5044962 | 5044962 | 20240908155945_LY2ac | NZ0038 | 2024-09-13T12:03:17.904Z | 2024-09-16T12:20:23.936Z |
5044317 | 5044317 | 20240908144636_cBAHD | NZ0038 | 2024-09-13T12:01:55.237Z | 2024-09-16T12:20:21.444Z |
5044314 | 5044314 | 20240908144540_B7nw8 | NZ0038 | 2024-09-13T12:01:54.813Z | 2024-09-16T12:20:21.431Z |
5044294 | 5044294 | 20240908144114_Hf4wo | NZ0038 | 2024-09-13T12:01:52.365Z | 2024-09-16T12:20:21.344Z |
5044274 | 5044274 | 20240908143814_N19t3 | NZ0038 | 2024-09-13T12:01:49.637Z | 2024-09-16T12:20:21.316Z |
5043956 | 5043956 | 20240908134125_qEsgB | NZ0038 | 2024-09-13T12:01:03.403Z | 2024-09-16T12:20:19.561Z |
5043922 | 5043922 | 20240908133529_hpkuW | NZ0038 | 2024-09-13T12:00:58.678Z | 2024-09-16T12:20:19.494Z |
5043849 | 5043849 | 20240908132102_3YYWo | NZ0038 | 2024-09-13T12:00:48.597Z | 2024-09-16T12:20:19.146Z |
5043758 | 5043758 | 20240908125855_bQeJB | NZ0038 | 2024-09-13T12:00:33.613Z | 2024-09-16T12:20:18.757Z |
5043197 | 5043197 | 20240907140458_IB7Bz | NZ0038 | 2024-09-12T12:17:24.984Z | 2024-09-16T12:20:55.799Z |
5043100 | 5043100 | 20240907134912_2hnSX | NZ0038 | 2024-09-12T12:17:23.360Z | 2024-09-16T12:20:55.455Z |
5042392 | 5042392 | 20240906104807_ukva1 | NZ0038 | 2024-09-12T12:17:01.729Z | 2024-09-14T12:23:17.197Z |
5038125 | 5038125 | 20240905172709_khs9Y | NZ0038 | 2024-09-12T12:14:23.281Z | 2024-09-14T12:22:55.089Z |
5038116 | 5038116 | 20240905172644_a6F24 | NZ0038 | 2024-09-12T12:14:23.047Z | 2024-09-14T12:22:55.083Z |
5037968 | 5037968 | 20240905170850_UfoDU | NZ0038 | 2024-09-12T12:14:18.051Z | 2024-09-14T12:22:54.844Z |
5037912 | 5037912 | 20240905170403_uKerY | NZ0038 | 2024-09-12T12:14:17.168Z | 2024-09-14T12:22:54.793Z |
5037871 | 5037871 | 20240905165849_zRxl2 | NZ0038 | 2024-09-12T12:14:16.522Z | 2024-09-14T12:22:54.750Z |
5037806 | 5037806 | 20240905165216_5HIAD | NZ0038 | 2024-09-12T12:14:15.678Z | 2024-09-14T12:22:54.640Z |
5037340 | 5037340 | 20240905153914_8Yhpn | NZ0038 | 2024-09-12T12:14:05.291Z | 2024-09-14T12:22:54.121Z |
5037179 | 5037179 | 20240905151840_oNnHl | NZ0038 | 2024-09-12T12:14:02.550Z | 2024-09-14T12:22:53.852Z |
5037111 | 5037111 | 20240905151048_tY1oA | NZ0038 | 2024-09-12T12:14:01.114Z | 2024-09-14T12:22:53.767Z |
5037034 | 5037034 | 20240905145553_92Z7z | NZ0038 | 2024-09-12T12:13:59.346Z | 2024-09-14T12:22:53.629Z |
5036990 | 5036990 | 20240905145147_OtGs5 | NZ0038 | 2024-09-12T12:13:58.809Z | 2024-09-14T12:22:53.613Z |
5036977 | 5036977 | 20240905145009_b7pk8 | NZ0038 | 2024-09-12T12:13:58.419Z | 2024-09-14T12:22:53.594Z |
5036921 | 5036921 | 20240905144503_0YBHF | NZ0038 | 2024-09-12T12:13:57.476Z | 2024-09-14T12:22:53.543Z |
5036730 | 5036730 | 20240905142125_OI775 | NZ0038 | 2024-09-12T12:13:53.386Z | 2024-09-14T12:22:53.129Z |
5036664 | 5036664 | 20240905141303_2lMj3 | NZ0038 | 2024-09-12T12:13:51.709Z | 2024-09-14T12:22:53.081Z |
5036598 | 5036598 | 20240905135748_2VPhw | NZ0038 | 2024-09-12T12:13:49.770Z | 2024-09-14T12:22:52.612Z |
5036378 | 5036378 | 20240905132132_LeQvI | NZ0038 | 2024-09-12T12:13:38.294Z | 2024-09-14T12:22:52.381Z |
5036349 | 5036349 | 20240905131731_xBgHB | NZ0038 | 2024-09-12T12:13:36.871Z | 2024-09-14T12:22:52.340Z |
5036274 | 5036274 | 20240905130920_5s6OW | NZ0038 | 2024-09-12T12:13:32.144Z | 2024-09-14T12:22:52.200Z |
5036162 | 5036162 | 20240905125129_Bsnox | NZ0038 | 2024-09-12T12:13:27.685Z | 2024-09-14T12:22:51.949Z |
5030054 | 5030054 | 20240906122445_fE7ey | NZ0038 | 2024-09-12T12:01:03.362Z | 2024-09-15T12:21:17.982Z |
5030040 | 5030040 | 20240906121202_sg6kr | NZ0038 | 2024-09-12T12:01:01.755Z | 2024-09-15T12:21:17.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);