Clara | A simple to use , composable , command line parser for C | Development Tools library

using System;
using System.Collections.Generic;
using System.Linq;
using System.Threading.Tasks;
using System.ComponentModel.DataAnnotations;
using Microsoft.AspNetCore.Http;
using System.ComponentModel.DataAnnotations.Schema;

using System.Web;
using System.Security.Cryptography;
using Microsoft.AspNetCore.Mvc;

namespace demo.Data
{
    public class ItemsMasters
    {

        [Key]
        [Display(Name = "Itemid")]
        public int ItemID { get; set; }

        [Required(ErrorMessage = "Please enter this items Name")]
        [Display(Name = "ItemName")]
        public string ItemName { get; set; }

        [Required(ErrorMessage = "Please enter this items Description")]
        [Display(Name = "ItemDesc")]
        public string ItemDesc { get; set; }

        [Required(ErrorMessage = "Please enter this items Colour")]
        [Display(Name = "ItemColour")]
        public string ItemColour { get; set; }

        [Required(ErrorMessage = "Please enter this items Catergory")]
        [Display(Name = "ItemCatergory")]
        public string ItemCatergory { get; set; }

        
        [Display(Name = "ItemImage")]
        public string ItemImage { get; set; }

        [NotMapped]
        [Display(Name = "Image")]
        public IFormFile Image { get; set; }
        
        [Display(Name = "ItemBrand")]
        public string ItemBrand { get; set; }

        [Display(Name = "ItemDateTime")]
        public DateTime ItemDateTime { get; set; }

        [Display(Name = "ItemUserID")]
        public string ItemUserID { get; set; }

    }


    
}

using System;
using System.Collections.Generic;
using System.Linq;
using System.Threading.Tasks;
using System.ComponentModel.DataAnnotations;
using Microsoft.AspNetCore.Http;
using System.ComponentModel.DataAnnotations.Schema;
using System.Web;
using System.Security.Cryptography;

namespace demo.Data
{
    public class DealsMasters
    {
        [Key]
        [Display(Name = "DealID")]
        public int DealID { get; set; }


        [Display(Name = "DealItemID")]
        public int DealItemID { get; set; }


        [Required(ErrorMessage = "Please enter The name of the supplier")]
        [Display(Name = "Supplier")]
        public string DealSupplier { get; set; }
        

        [Required(ErrorMessage = "Please enter the price of the supplier")]
        [Display(Name = "Price")]
        public Decimal  DealPrice { get; set; }

        [Required(ErrorMessage = "Please enter the link to the suppliers page")]
        [Display(Name = "Link")]
        public string DealLink { get; set; }

        [Required(ErrorMessage = "Please enter if the supplier accents visa")]
        [Display(Name = "Visa")]
        public string DealVisa { get; set; }

        [Required(ErrorMessage = "Please enter if the supplier accents clarna")]
        [Display(Name = "Clara")]
        public string DealClarna { get; set; }

        
        
        [Display(Name = "DealUserID")]
        public string DealUserID { get; set; }



    }
}

@page
@model demo.Pages.GetItemModel

@{
    ViewData["Title"] = "GetItem";
}





    
    
  


        
   

            Go Back
             @Html.DisplayFor(model => model.ItemsMasters.ItemName)
            
        
   


        
   


            
            

            View deals for this item |

            Edit This Item |

            Create a deal for this item |

            Delete This Item
            

        
   

        
   

    
            Description
        
   
        
   

            
    
@Model.ItemsMasters.ItemDesc
        
   
        
   

    
            Colour
        
   
        
   

    
            @Html.DisplayFor(model => model.ItemsMasters.ItemColour)
        
   
        
   

    
            Catergory
        
   
        
   

    
            @Html.DisplayFor(model => model.ItemsMasters.ItemCatergory)
        
   


        
   

    
            Brand
        
   
        
   

    
            @Html.DisplayFor(model => model.ItemsMasters.ItemBrand)
        
   
        
    
  
    
        
            

                
                    Supplier
                
                
                    Price
                
                
                    Visa
                
                
                    Clarna
                
                
                    Link
                
                
            
        
        
            @foreach (var item in Model.DealsMasters)
            {
                

                    
                        @Html.DisplayFor(modelItem => item.DealSupplier)
                    
                    
                        £@Html.DisplayFor(modelItem => item.DealPrice)
                    

                    
                        @Html.DisplayFor(modelItem => item.DealVisa)
                    
                    
                        @Html.DisplayFor(modelItem => item.DealClarna)
                    
                    
                        
@item.DealLink
                    
                    
                        Edit This Deal |
                        Delete This Deal

                    
                
            }
        
    

using System;
using System.Collections.Generic;
using System.Linq;
using System.Threading.Tasks;
using Microsoft.AspNetCore.Mvc;
using Microsoft.AspNetCore.Mvc.RazorPages;
using Microsoft.EntityFrameworkCore;
using demo.Data;
using Microsoft.AspNetCore.Identity;
using Microsoft.AspNetCore.Identity.UI.Services;
using System.Security.Claims;

namespace demo.Pages
{
    public class GetItemModel : PageModel
    {
        private readonly demo.Data.ApplicationDbContext _context;
        private int? id;

        public GetItemModel(demo.Data.ApplicationDbContext context)
        {
            _context = context;
        }

        public ItemsMasters ItemsMasters { get; set; }
        
        public DealsMasters DealsMasters { get; set; }


        public async Task OnGetAsync(int? id)
        {
            if (id == null)
            {
                return NotFound();
            }

            ItemsMasters = await _context.ItemsMasters.FirstOrDefaultAsync(m => m.ItemID == id);
            this.id = id;
            DealsMasters = await _context.DealsMasters.FirstOrDefaultAsync(m => m.DealItemID == this.id);
            
            if (ItemsMasters == null)

            {
                return NotFound();
            }
            if (DealsMasters == null)

            {
                return NotFound();
            }
            return Page();
        }
    }
}

import React, { useState, useEffect } from "react";
import "./App.css";

function App() {
  const [isLoading, setIsLoading] = useState(true);
  const [trendingMovies, setTrendingMovies] = useState();

  useEffect(() => {
    fetch(
      "https://api.themoviedb.org/3/trending/all/day?api_key=***"
    )
      .then((res) => res.json())
      .then((results) => console.log(results))
      .then((data) => setTrendingMovies(data))
      .catch((error) => console.log(error))
      .then(setIsLoading(false));
  }, [trendingMovies]);

  function Loading() {
    return Loading...;
  }

  function DisplayTrendingMovies() {
    return (
      <>
        
Trending:
        {console.log(trendingMovies)}
        
  

   
          {trendingMovies &&
            trendingMovies.map((movie) => (
              
   
{movie.results.original_title}
            ))}
        
  
      
    );
  }

  return <>{isLoading ? Loading() : DisplayTrendingMovies()};
}

export default App;

  {"page": 1,
  "results": [
    {
      "genre_ids": [28, 12, 878],
      "original_language": "en",
      "original_title": "Spider-Man: No Way Home",
      "poster_path": "/1g0dhYtq4irTY1GPXvft6k4YLjm.jpg",
      "video": false,
      "vote_average": 8.2,
      "vote_count": 9831,
      "overview": "Peter Parker is unmasked and no longer able to separate his normal life from the high-stakes of being a super-hero. When he asks for help from Doctor Strange the stakes become even more dangerous, forcing him to discover what it truly means to be Spider-Man.",
      "release_date": "2021-12-15",
      "title": "Spider-Man: No Way Home",
      "id": 634649,
      "adult": false,
      "backdrop_path": "/iQFcwSGbZXMkeyKrxbPnwnRo5fl.jpg",
      "popularity": 9675.798,
      "media_type": "movie"
    },
    {
      "adult": false,
      "backdrop_path": "/qswImgf57wBf2i8Fv6K2O2BdMoe.jpg",
      "genre_ids": [53, 10749, 18],
      "id": 619979,
      "original_language": "en",
      "original_title": "Deep Water",
      "overview": "Vic and Melinda Van Allen are a couple in the small town of Little Wesley. Their loveless marriage is held together only by a precarious arrangement whereby, in order to avoid the messiness of divorce, Melinda is allowed to take any number of lovers as long as she does not desert her family.",
      "poster_path": "/6yRMyWwjuhKg6IU66uiZIGhaSc8.jpg",
      "release_date": "2022-03-18",
      "title": "Deep Water",
      "video": false,
      "vote_average": 6.0,
      "vote_count": 1,
      "popularity": 111.471,
      "media_type": "movie"
    },
    {
      "genre_ids": [28, 53],
      "original_language": "sv",
      "original_title": "Svart krabba",
      "poster_path": "/mcIYHZYwUbvhvUt8Lb5nENJ7AlX.jpg",
      "id": 760868,
      "vote_average": 0.0,
      "overview": "To end an apocalyptic war and save her daughter, a reluctant soldier embarks on a desperate mission to cross a frozen sea carrying a top-secret cargo.",
      "release_date": "2022-03-18",
      "vote_count": 0,
      "video": false,
      "adult": false,
      "backdrop_path": "/w8pSD1jVt2OzBCr8QQTTjk0mBHt.jpg",
      "title": "Black Crab",
      "popularity": 41.066,
      "media_type": "movie"
    },
    {
      "genre_ids": [16, 10751, 35, 14],
      "original_language": "en",
      "original_title": "Turning Red",
      "poster_path": "/qsdjk9oAKSQMWs0Vt5Pyfh6O4GZ.jpg",
      "video": false,
      "vote_average": 7.4,
      "vote_count": 565,
      "overview": "Thirteen-year-old Mei is experiencing the awkwardness of being a teenager with a twist – when she gets too excited, she transforms into a giant red panda.",
      "release_date": "2022-03-10",
      "title": "Turning Red",
      "id": 508947,
      "adult": false,
      "backdrop_path": "/iPhDToxFzREctUA0ZQiYZamXsMy.jpg",
      "popularity": 7663.359,
      "media_type": "movie"
    },
    {
      "video": false,
      "vote_average": 6.0,
      "overview": "At an elite New England university built on the site of a Salem-era gallows hill, three black women strive to find their place. Navigating politics and privilege, they encounter increasingly terrifying manifestations of the school's haunted past… and present.",
      "release_date": "2022-03-18",
      "vote_count": 1,
      "adult": false,
      "backdrop_path": "/bW0zTTdvc9zafc6hDEG1pMDuMCW.jpg",
      "title": "Master",
      "genre_ids": [27, 53, 18, 9648],
      "id": 680829,
      "original_language": "en",
      "original_title": "Master",
      "poster_path": "/gxbwRHsQ2v6DQv28ttp7pIx7Utj.jpg",
      "popularity": 37.859,
      "media_type": "movie"
    },
    {
      "id": 850018,
      "poster_path": "/r3eGUCijDCNqwcP1Ri8AZyTbPzI.jpg",
      "video": false,
      "vote_average": 0.0,
      "overview": "A man breaks into a tech billionaire's empty vacation home, but things go sideways when the arrogant mogul and his wife arrive for a last-minute getaway.",
      "release_date": "2022-03-11",
      "vote_count": 0,
      "adult": false,
      "backdrop_path": "/cc7Nmid20lcfNh1eucWdLKidi7s.jpg",
      "title": "Windfall",
      "genre_ids": [80, 18, 53],
      "original_title": "Windfall",
      "original_language": "en",
      "popularity": 12.777,
      "media_type": "movie"
    },
    {
      "id": 691683,
      "video": false,
      "title": "Cheaper by the Dozen",
      "overview": "This remake of the beloved classic follows the raucous exploits of a blended family of 12, the Bakers, as they navigate a hectic home life while simultaneously managing their family business.",
      "release_date": "2022-03-18",
      "vote_count": 1,
      "adult": false,
      "backdrop_path": "/4YOpxmGyQZFELwLB7JqcpYKnmKw.jpg",
      "vote_average": 10.0,
      "genre_ids": [35, 10751, 18],
      "poster_path": "/qNRsouZh5zmhaE3n4QpLDXzy1gQ.jpg",
      "original_language": "en",
      "original_title": "Cheaper by the Dozen",
      "popularity": 43.263,
      "media_type": "movie"
    },
    {
      "title": "The Adam Project",
      "overview": "After accidentally crash-landing in 2022, time-traveling fighter pilot Adam Reed teams up with his 12-year-old self on a mission to save the future.",
      "release_date": "2022-03-11",
      "adult": false,
      "backdrop_path": "/ewUqXnwiRLhgmGhuksOdLgh49Ch.jpg",
      "genre_ids": [878, 12, 35],
      "vote_count": 705,
      "original_language": "en",
      "original_title": "The Adam Project",
      "poster_path": "/wFjboE0aFZNbVOF05fzrka9Fqyx.jpg",
      "video": false,
      "id": 696806,
      "vote_average": 7.0,
      "popularity": 2137.891,
      "media_type": "movie"
    },
    {
      "adult": false,
      "backdrop_path": "/zQG1FYDqoWo2hYhE5GVZ1yrWSfh.jpg",
      "genre_ids": [10751, 18],
      "id": 921655,
      "original_language": "en",
      "original_title": "Rescued by Ruby",
      "overview": "Chasing his dream to join an elite K-9 unit, a state trooper partners with a fellow underdog: clever but naughty shelter pup Ruby. Based on a true story.",
      "poster_path": "/tPlJEodEn0SSV4avo8KSawtlTlN.jpg",
      "release_date": "2022-03-17",
      "title": "Rescued by Ruby",
      "video": false,
      "vote_average": 7.4,
      "vote_count": 6,
      "popularity": 47.237,
      "media_type": "movie"
    },
    {
      "overview": "In his second year of fighting crime, Batman uncovers corruption in Gotham City that connects to his own family while facing a serial killer known as the Riddler.",
      "release_date": "2022-03-01",
      "adult": false,
      "backdrop_path": "/5P8SmMzSNYikXpxil6BYzJ16611.jpg",
      "id": 414906,
      "genre_ids": [80, 9648, 53],
      "original_language": "en",
      "original_title": "The Batman",
      "poster_path": "/74xTEgt7R36Fpooo50r9T25onhq.jpg",
      "vote_count": 1981,
      "video": false,
      "vote_average": 8.0,
      "title": "The Batman",
      "popularity": 2675.235,
      "media_type": "movie"
    },
    {
      "release_date": "2022-03-17",
      "adult": false,
      "backdrop_path": "/trtFAmf4IcndxSh5tIfLwxPyW67.jpg",
      "genre_ids": [28, 53],
      "vote_count": 4,
      "original_language": "en",
      "original_title": "Panama",
      "poster_path": "/82I3tDsGDTMy7lHar84Gz0jUuyW.jpg",
      "title": "Panama",
      "video": false,
      "vote_average": 6.0,
      "id": 628878,
      "overview": "An ex-marine is hired by a defense contractor to travel to Panama to complete an arms deal. In the process he becomes involved with the U.S. invasion of Panama, and learns an important lesson about the true nature of political power.",
      "popularity": 40.113,
      "media_type": "movie"
    },
    {
      "backdrop_path": "/fUjATGfykF0EU57DhMDkIXqQlc5.jpg",
      "first_air_date": "2022-03-17",
      "genre_ids": [18, 10765],
      "id": 113566,
      "name": "DMZ",
      "origin_country": ["US"],
      "original_language": "en",
      "original_name": "DMZ",
      "overview": "In the near future after a bitter civil war leaves Manhattan a demilitarized zone (DMZ), destroyed and isolated from the rest of the world, fierce medic Alma Ortega sets out on a harrowing journey to find the son she lost in the evacuation of New York City at the onset of the conflict. Standing in her way are gangs, militias, demagogues and warlords, including Parco Delgado, the popular — and deadly — leader of one of the most powerful gangs in the DMZ.",
      "poster_path": "/wnug9DhsenurS5dWCypjZSRFnH6.jpg",
      "vote_average": 10.0,
      "vote_count": 3,
      "popularity": 66.357,
      "media_type": "tv"
    },
    {
      "backdrop_path": "/x8KTttToqfHC92JiD2Cs8WWkBG7.jpg",
      "genre_ids": [18],
      "original_language": "en",
      "poster_path": "/rFlYeo84b5YtzNkN0IonN6ZCPic.jpg",
      "first_air_date": "2022-03-17",
      "vote_average": 0.0,
      "original_name": "WeCrashed",
      "origin_country": ["US"],
      "vote_count": 0,
      "overview": "Inspired by actual events — and the love story at the center of it all. WeWork grew from a single coworking space into a global brand worth $47 billion in under a decade. Then, in less than a year, its valuation dropped $40 billion. What happened?",
      "id": 117821,
      "name": "WeCrashed",
      "popularity": 61.183,
      "media_type": "tv"
    },
    {
      "vote_average": 7.1,
      "title": "Nightmare Alley",
      "overview": "An ambitious carnival man with a talent for manipulating people with a few well-chosen words hooks up with a female psychiatrist who is even more dangerous than he is.",
      "release_date": "2021-12-02",
      "id": 597208,
      "adult": false,
      "backdrop_path": "/g0YNGpmlXsgHfhGnJz3c5uyzZ1B.jpg",
      "genre_ids": [80, 18, 53],
      "original_language": "en",
      "original_title": "Nightmare Alley",
      "poster_path": "/vfn1feL0V9HNSXuLLpaxAW8O6LO.jpg",
      "vote_count": 1055,
      "video": false,
      "popularity": 1099.529,
      "media_type": "movie"
    },
    {
      "genre_ids": [18, 35],
      "original_language": "en",
      "original_title": "Dog",
      "poster_path": "/zHQy4h36WwuCetKS7C3wcT1hkgA.jpg",
      "id": 626735,
      "vote_average": 7.6,
      "overview": "An army ranger and his dog embark on a road trip along the Pacific Coast Highway to attend a friend's funeral.",
      "release_date": "2022-02-17",
      "vote_count": 110,
      "video": false,
      "adult": false,
      "backdrop_path": "/8T7SS4jU7TmtqrUr45JgZASCTUP.jpg",
      "title": "Dog",
      "popularity": 200.167,
      "media_type": "movie"
    },
    {
      "adult": false,
      "backdrop_path": "/zOVxbbt8BrrjWBJ0eO21S2adUvo.jpg",
      "genre_ids": [35],
      "id": 776328,
      "original_language": "it",
      "original_title": "Marilyn ha gli occhi neri",
      "overview": "Clara and Diego, under the guidance of the psychiatrist of a day rehabilitation center for disturbed people who attend, decide to transform the treatment center into a restaurant, involving all their other companions.",
      "poster_path": "/thHmfbg56EDMCTmjEuz6Xo5M8hV.jpg",
      "release_date": "2021-10-14",
      "title": "Marilyn's Eyes",
      "video": false,
      "vote_average": 6.9,
      "vote_count": 136,
      "popularity": 29.106,
      "media_type": "movie"
    },
    {
      "id": 93544,
      "overview": "Two seasoned drug dealers return to the gritty street of London, but their pursuit of money and power is threatened by a young and ruthless hustler.",
      "name": "Top Boy",
      "vote_count": 14,
      "vote_average": 8.9,
      "backdrop_path": "/4CqfqazO2EBhN469XfIp7RSJZ7h.jpg",
      "original_language": "en",
      "genre_ids": [80, 18],
      "first_air_date": "2019-09-13",
      "original_name": "Top Boy",
      "origin_country": [],
      "poster_path": "/mGZpOEaLZTRzWeQMq5SZM5BbDZg.jpg",
      "popularity": 66.767,
      "media_type": "tv"
    },
    {
      "backdrop_path": "/3vOh84wLx47L1vhNTUuf1Z0zv2i.jpg",
      "genre_ids": [10765],
      "original_language": "pl",
      "poster_path": "/bBzkreVliFn18zFBjysanZnC3Yq.jpg",
      "first_air_date": "2022-03-18",
      "vote_average": 0.0,
      "original_name": "Krakowskie potwory",
      "origin_country": ["PL"],
      "vote_count": 0,
      "overview": "A young woman haunted by her past joins a mysterious professor and his group of gifted students who investigate paranormal activity — and fight demons.",
      "id": 158396,
      "name": "Cracow Monsters",
      "popularity": 24.704,
      "media_type": "tv"
    },
    {
      "backdrop_path": "/ifUfE79O1raUwbaQRIB7XnFz5ZC.jpg",
      "genre_ids": [27, 9648, 53],
      "original_language": "en",
      "original_title": "Scream",
      "poster_path": "/kZNHR1upJKF3eTzdgl5V8s8a4C3.jpg",
      "video": false,
      "vote_average": 6.8,
      "vote_count": 937,
      "overview": "Twenty-five years after a streak of brutal murders shocked the quiet town of Woodsboro, a new killer has donned the Ghostface mask and begins targeting a group of teenagers to resurrect secrets from the town’s deadly past.",
      "release_date": "2022-01-12",
      "id": 646385,
      "title": "Scream",
      "adult": false,
      "popularity": 1191.305,
      "media_type": "movie"
    },
    {
      "original_language": "en",
      "original_title": "Loveland",
      "poster_path": "/zVxFQG0rAFITjIygEMHFRLtR6JI.jpg",
      "video": false,
      "id": 659924,
      "release_date": "2022-03-17",
      "vote_count": 0,
      "adult": false,
      "backdrop_path": "/2QerJOQmmWcINcM1S1sNkDxjXkj.jpg",
      "genre_ids": [878, 10749, 53],
      "vote_average": 0.0,
      "overview": "In an uncharted future, two hardened souls meet and confront each other with the things they have done and what they have become.",
      "title": "Loveland",
      "popularity": 32.544,
      "media_type": "movie"
    }
  ],
  "total_pages": 1000,
  "total_results": 20000
}

| Name      | color     | id    | weight    |       
|-------    |--------   |----   |--------   |
| john      | blue      | 67    | 70        |       
| clara     | yellow    | -     | 67        |       
| diana     | red       | 89    | 56        |       

| name      | object            
| color     | object    
| id        | object    
| weight    | float  

    d = {"FAM1": ["bob.bam", "clara.bam", "tim.bam"]}
    FAMILIES = list(d)
    
    rule all:
        input:
            expand some outputs
            
    wildcard_constraints:
        family = "|".join(FAMILIES)
    
    rule somerulename:
        input:
            lambda w: d[w.family]
        output:
            vcf="{family}/{family}.vcf"
        shell:
            """
            some python command line which produces a single vcf file with bob, clara and tim
            """
    
    rule somerulename:
        input:
            invcf="{family}/{family}.vcf"
        params:
            ref="someref.fasta"
        output:
            out="{family}/{bob}.dn.vcf"
        shell:
            """
            gatk --java-options "-Xms2G -Xmx2g -XX:ParallelGCThreads=2" SelectVariants -R {params.ref} -V {input.invcf} -O {output.out}
            """

import requests
import pandas as pd
import json

get_session_url = "https://qships.tmr.qld.gov.au/webx/"
get_data_url = "https://qships.tmr.qld.gov.au/webx/services/wxdata.svc/GetDataX"

get_data_query = {
    "token": None,
    "reportCode": "MSQ-WEB-0001",
    "dataSource": None,
    "filterName": "Today",
    "parameters": [{
            "__type": "ParameterValueDTO:#WebX.Core.DTO",
            "sName": "DOMAIN_ID",
            "iValueType": 0,
            "aoValues": [{"Value": -1}],
                  }],
    "metaVersion": 0,
}

sess = requests.session()

sess.get(get_session_url).raise_for_status()

my_dict = sess.post(get_data_url, json = get_data_query).json()

print(my_dict)

{'d': {'__type': 'DataSetDTO:#WebX.Core.DTO', 'BuildVersion': '7.0.0.12590', 'ReportCode': 'MSQ-WEB-0001', 'Tables': [{'__type': 'DataTableDTO:#WebX.Core.DTO', 'BuildVersion': '7.0.0.12590', 'AsOfDate': '14:36 on Jan 19', 'Data': [[132378, 334489, 'EXT', 'NANA Z', 'BULK CARRIER', 229.2, 'LBH Australia Pty Ltd (Mackay)', '/Date(1642600800000+1000)/', '/Date(1642600800000+1000)/', 'SEA for HPS', 'Anch for HPS & DBCT', 'PLAN', 'Keelung (Chilung)', 'Kwangyang', None, 633086, 705], [132112, 333984, 'DEP', 'KRITI WARRIOR', 'BULK CARRIER', 234.98, 'Wilhelmsen Ships Service (Gladstone)', '/Date(1642600800000+1000)/', '/Date(1642608900000+1000)/', 'Fishermans Landing 1', 'SEA', 'CONF', 'Amrun', 'Amrun', '2201', 632395, 725], [132232, 334208, 'EXT', 'BLUE GRASS MARINER', 'TANKER', 183.06, 'Gulf Agency Company (Mackay)', '/Date(1642600860000+1000)/', '/Date(1642600860000+1000)/', 'SEA M', 'Anch for MKY', 'PLAN', 'Gladstone', 'Singapore', None, 633566, 705], [132654, 335076, 'EXT', 'SERIFOS WARRIOR', 'BULK CARRIER', 234.98, 'Wilhelmsen Ships Service (Gladstone)', '/Date(1642606200000+1000)/', '/Date(1642609800000+1000)/', 'SEA', 'Fairway Buoy Anchorage', 'PLAN', 'Amrun', 'Amrun', '2201', 632055, 705], [132030, 333847, 'ARR', 'MH GREEN', 'CONTAINER SHIP', 199.98, 'Inchcape Shipping Services (Queensland)', '/Date(1642610700000+1000)/', '/Date(1642623300000+1000)/', 'SEA', 'Fisherman Island No 8', 'SCHD', 'Yantian', 'Botany Bay', '11S/11N', 633005, 710], [131681, 333193, 'ARR', 'KM NAGOYA', 'BULK CARRIER', 234.98, 'Gulf Agency Company (Gladstone)', '/Date(1642611600000+1000)/', '/Date(1642618800000+1000)/', 'Fairway Buoy Anchorage', 'Clinton Coal 2', 'CONF', 'Fangcheng', 'Singapore', None, 633504, 725], [132781, 335341, 'ARR', 'MORNING CLARA', 'VEHICLES CARRIER', 199.9, 'Wilhelmsen Ships Service (Brisbane)', '/Date(1642611600000+1000)/', '/Date(1642626000000+1000)/', 'Drift Point Cartwright', 'Fisherman Island No 1', 'SCHD', 'Tianjin', 'Port Kembla', '2251', 633093, 710], [131971, 333736, 'DEP', 'MAPLE FORTITUDE', 'BULK CARRIER', 179.9, 'Inchcape Shipping Services (Queensland)', '/Date(1642615200000+1000)/', '/Date(1642621500000+1000)/', 'Townsville 09', 'SEA', 'SCHD', 'Lanshan', 'Auckland', '2101', 633738, 710], [131629, 333076, 'DEP', 'JP CORAL', 'BULK CARRIER', 228.0, 'Sturrock Grindrod Maritime (Gladstone)', '/Date(1642617000000+1000)/', '/Date(1642625100000+1000)/', 'Clinton Coal 2', 'SEA', 'CONF', 'Matsushima - Nagasaki', 'Matsuura - Nagasaki', '146', 631305, 725], [130504, 331071, 'ARR', 'KENNADI', 'BULK CARRIER', 199.9, 'LBH Australia Pty Ltd (Gladstone)', '/Date(1642617000000+1000)/', '/Date(1642626000000+1000)/', 'East Anchorage 9', 'Clinton Coal 4', 'CONF', 'Kwangyang', 'Kendari - Sulawesi', '37', 633759, 725], [131497, 332926, 'ARR', 'STAR VIRGINIA', 'BULK CARRIER', 229.0, 'Inchcape Shipping Services (Queensland)', '/Date(1642617900000+1000)/', '/Date(1642633200000+1000)/', 'Point Cartwright Anchorage', 'Fisherman Island Coal Berth', 'SCHD', 'Kitakyushu', 'Fukuyama - Hiroshima', '2', 632115, 710], [132459, 334657, 'ARR', 'NORD ANNAPOLIS', 'BULK CARRIER', 179.9, 'Monson Agencies Australia (Gladstone)', '/Date(1642617900000+1000)/', '/Date(1642625100000+1000)/', 'East Anchorage 11', 'Auckland Point 2', 'CONF', 'Portland', 'Chittagong', '26', 633752, 725], [132563, 334863, 'DEP', 'POSITIVE LEADER', 'VEHICLES CARRIER', 180.0, 'Monson Agencies Australia (Brisbane)', '/Date(1642622400000+1000)/', '/Date(1642635000000+1000)/', 'Fisherman Island No 1', 'SEA', 'SCHD', 'Townsville', 'Port Kembla', '090', 632525, 710], [132221, 334613, 'ARR', 'DANCEWOOD SW', 'BULK CARRIER', 170.7, 'Inchcape Shipping Services (Queensland)', '/Date(1642622400000+1000)/', '/Date(1642640400000+1000)/', 'Point Cartwright Anchorage', 'Pinkenba No 1', 'SCHD', 'Guam', 'Shibushi', '202201', 632332, 710], [132357, 334450, 'EXT', 'DOUBLE FANTASY', 'BULK CARRIER', 234.98, 'Monson Agencies Australia (Townsville & Abbot Point)', '/Date(1642622400000+1000)/', '/Date(1642622400000+1000)/', 'SEA', 'Abbot Point Anchorage', 'SCHD', 'Chiba', None, None, 631611, 710], [132431, 334598, 'DEP', 'INDUS PROSPERITY', 'BULK CARRIER', 229.2, 'Monson Agencies Australia (Townsville & Abbot Point)', '/Date(1642624200000+1000)/', '/Date(1642624200000+1000)/', 'Abott Point 2', 'SEA', 'SCHD', 'Chiba', 'Dung Quat', None, 627891, 710], [132465, 334672, 'DEP', 'KOTA LUMAYAN', 'CONTAINER SHIP', 260.502, 'Gulf Agency Company (Brisbane)', '/Date(1642626000000+1000)/', '/Date(1642639500000+1000)/', 'Fisherman Island No. 9', 'SEA', 'PLAN', 'Singapore', 'Sydney', '0147', 632026, 705], [132356, 334446, 'ARR', 'TRITON', 'BULK CARRIER', 225.0, 'Sturrock Grindrod Maritime (Mackay)', '/Date(1642626000000+1000)/', '/Date(1642632000000+1000)/', 'North Anchorage 22', 'HPS Berth 2', 'SCHD', 'Gunsan (ex Kunsan)', 'Singapore', '012022', 633638, 710], [132430, 334595, 'ARR', 'GOLDEN YOSA', 'TANKER', 144.03, 'Sturrock Grindrod Maritime (Brisbane)', '/Date(1642626000000+1000)/', '/Date(1642644000000+1000)/', 'SEA', 'Viva Energy', 'SCHD', 'Geelong', 'Townsville', '74(C1)', 628015, 710], [132631, 335048, 'DEP', 'MONDIAL SUN', 'BULK CARRIER', 229.0, 'Ben Line Agencies', '/Date(1642626000000+1000)/', '/Date(1642629600000+1000)/', 'Abbot Point 1', 'SEA', 'SCHD', 'Bahudopi', 'India', '018', 633700, 710], [132451, 334640, 'EXT', 'GOLDEN HACHI', 'TANKER', 126.8, 'Sturrock Grindrod Maritime (Brisbane)', '/Date(1642626000000+1000)/', '/Date(1642626000000+1000)/', 'SEA', 'Point Cartwright Anchorage', 'PLAN', 'Singapore', 'Botany Bay', '10', 632483, 705], [132442, 334622, 'DEP', 'FOREVER SW', 'BULK CARRIER', 189.99, 'Gulf Agency Company (Brisbane)', '/Date(1642626000000+1000)/', '/Date(1642643100000+1000)/', 'Fisherman Island Coal Berth', 'SEA', 'SCHD', 'Toledo/Cebu', 'Kushiro', '2A', 569051, 710], [132572, 334905, 'ARR', 'GREEK FRIENDSHIP', 'BULK CARRIER', 228.9, 'LBH Australia Pty Ltd (Mackay)', '/Date(1642627800000+1000)/', '/Date(1642627800000+1000)/', 'Abbot Point Anchorage 11', 'Abott Point 2', 'SCHD', 'Tianjin', 'Singapore', None, 633660, 710], [132262, 334259, 'DEP', 'ASTREA', 'BULK CARRIER', 228.99, 'Wave Shipping Pty Ltd', '/Date(1642627800000+1000)/', '/Date(1642627860000+1000)/', 'HPS Berth 1', 'SEA Paddock Departure', 'PLAN', 'Lianyungang', 'Singapore', '1', 633595, 705], [132510, 334762, 'DEP', 'BRILLIANT ADVANCE', 'BULK CARRIER', 228.99, 'Wilhelmsen Ships Service (Weipa)', '/Date(1642629600000+1000)/', '/Date(1642633200000+1000)/', 'Chith Export Facility', 'SEA', 'CONF', 'Laizhou', 'Gladstone', None, 631808, 725], [132170, 334112, 'ARR', 'LOWLANDS CRIMSON', 'BULK CARRIER', 234.96, 'Wilhelmsen Ships Service (Weipa)', '/Date(1642629600000+1000)/', '/Date(1642636800000+1000)/', 'Anchorage ^D', 'Chith Export Facility', 'CONF', 'Gladstone', 'China', None, 630787, 725], [132433, 334601, 'DEP', 'PT NORFOLK', 'GENERAL CARGO BARGE', 70.15, 'Pacific Tug (Aust) PTY LTD', '/Date(1642631400000+1000)/', '/Date(1642635000000+1000)/', 'Marina', 'Bundaberg Anchorage', 'CONF', None, None, None, 624749, 725], [132428, 334591, 'REM', 'PT KYTHIRA', 'TUG', 26.0, 'Pacific Tug (Aust) PTY LTD', '/Date(1642631400000+1000)/', '/Date(1642635000000+1000)/', 'Marina', 'Bundaberg Anchorage', 'CONF', None, 'Brisbane', None, 570086, 725], [131637, 333097, 'ARR', 'BALZANI', 'TANKER', 228.418, 'Monson Agencies Australia (Gladstone)', '/Date(1642632300000+1000)/', '/Date(1642642200000+1000)/', 'North Anchorage 7', 'Fishermans Landing 2', 'CONF', 'Yeosu (ex Yosu)', 'Port Kembla', '32106', 632359, 725], [132699, 335167, 'EXT', 'FEDERAL IMABARI', 'BULK CARRIER', 199.98, 'Monson Agencies Australia (Brisbane)', '/Date(1642633200000+1000)/', '/Date(1642633200000+1000)/', 'Skardon River Anchorage', 'SEA', 'CONF', None, None, None, 624678, 725], [132451, 335328, 'ARR', 'GOLDEN HACHI', 'TANKER', 126.8, 'Sturrock Grindrod Maritime (Brisbane)', '/Date(1642635000000+1000)/', '/Date(1642651200000+1000)/', 'Point Cartwright Anchorage', 'Ampol Lytton Products', 'PLAN', 'Singapore', 'Botany Bay', '10', 632483, 705], [131897, 333604, 'DEP', 'PROTEUS', 'TANKER', 183.06, 'Gulf Agency Company (Mackay)', '/Date(1642635000000+1000)/', '/Date(1642635060000+1000)/', 'Mackay Berth 1', 'SEA MKY', 'SCHD', 'Gladstone', 'Townsville', None, 633592, 710], [132059, 333886, 'ARR', 'RTM WAKMATHA', 'BULK CARRIER', 236.0, 'Wilhelmsen Ships Service (Gladstone)', '/Date(1642635000000+1000)/', '/Date(1642644900000+1000)/', 'Fairway Buoy Anchorage', 'Fishermans Landing 1', 'CONF', 'Gove', 'Amrun', None, 633057, 725], [132024, 333833, 'ARR', 'MARIA PRINCESS', 'TANKER', 228.59, 'Gulf Agency Company (Brisbane)', '/Date(1642635000000+1000)/', '/Date(1642654800000+1000)/', 'Point Cartwright Anchorage', 'Fishermans Island Tanker Terminal', 'SCHD', 'Seria Brunei', None, None, 633606, 710], [132504, 334740, 'EXT', 'MAIRAKI', 'BULK CARRIER', 291.9, 'LBH Australia Pty Ltd (Gladstone)', '/Date(1642636800000+1000)/', '/Date(1642636800000+1000)/', 'SEA', 'Drift Gladstone', 'PLAN', 'Tianjin', None, '43', 633705, 705], [132029, 333846, 'DEP', 'MANTA NILGUN', 'GENERAL CARGO', 179.99, 'Monson Agencies Australia (Gladstone)', '/Date(1642637700000+1000)/', '/Date(1642644000000+1000)/', 'South Trees East', 'SEA', 'CONF', 'Port Moresby', 'Nakhodka', '202201', 632946, 725], [132001, 333781, 'ARR', 'NSU KEYSTONE', 'BULK CARRIER', 299.94, 'Inchcape Shipping Services (Queensland)', '/Date(1642638600000+1000)/', '/Date(1642644000000+1000)/', 'North Anchorage 19', 'DBCT Berth 1', 'SCHD', 'Yeosu (ex Yosu)', 'Kimitsu', '57', 633532, 710], [131382, 332650, 'EXT', 'AQUADIVA', 'BULK CARRIER', 292.0, 'Gulf Agency Company (Gladstone)', '/Date(1642639500000+1000)/', '/Date(1642643100000+1000)/', 'SEA', 'Fairway Buoy Anchorage', 'PLAN', 'Bayuquan', 'Abbot Point', None, 633453, 705], [132417, 334562, 'DEP', 'KMARIN KENAI', 'BULK CARRIER', 229.0, 'Monson Agencies Australia (Mackay)', '/Date(1642640400000+1000)/', '/Date(1642644000000+1000)/', 'DBCT Berth 1', 'SEA Paddock Departure', 'SCHD', 'Yeosu (ex Yosu)', 'Sepetiba', None, 633645, 710], [132708, 335184, 'ARR', 'MSC ELA', 'CONTAINER SHIP', 294.06, 'Mediterranean Shipping Company', '/Date(1642641300000+1000)/', '/Date(1642654800000+1000)/', 'SEA', 'Fisherman Island No. 9', 'SCHD', 'Sydney', 'Shanghai', 'SE151R', 633718, 710], [132611, 335017, 'DEP', 'SSB 1803', 'BARGE CARRIER', 52.7, 'Sea Swift Pty Ltd', '/Date(1642644000000+1000)/', '/Date(1642647600000+1000)/', 'Hammond Island', 'SEA', 'CONF', None, None, None, 586569, 725], [132429, 334592, 'EXT', 'LEONORA VICTORY', 'TANKER', 183.2, 'Monson Agencies Australia (Gladstone)', '/Date(1642644000000+1000)/', '/Date(1642644000000+1000)/', 'SEA', 'Fairway Buoy Anchorage', 'PLAN', 'Balboa', 'Unknown Port', '32', 633737, 705], [132601, 335000, 'DEP', 'NORMAN RIVER', 'TUG', 24.45, 'Sea Swift Pty Ltd', '/Date(1642644000000+1000)/', '/Date(1642647600000+1000)/', 'Hammond Island', 'SEA', 'CONF', 'Cape Flattery', 'Cairns', None, 633691, 725], [132079, 335477, 'EXT', 'DEE4 LARCH', 'TANKER', 183.06, 'Inchcape Shipping Services (Queensland)', '/Date(1642646040000+1000)/', '/Date(1642646040000+1000)/', 'East Anchorage 6', 'SEA', 'PLAN', 'Etajima', 'Unknown Port', '1', 632184, 705], [132470, 334682, 'ARR', 'CASTILLO DE SANTISTEBAN', 'LIQUEFIED GAS TANKER', 299.9, 'Gulf Agency Company (Gladstone)', '/Date(1642646700000+1000)/', '/Date(1642658400000+1000)/', 'LNG Anchorage 2', 'Queensland Curtis LNG', 'CONF', 'Taiwan', 'Ningbo', None, 632133, 725], [132434, 334603, 'REM', 'PT NORFOLK', 'GENERAL CARGO BARGE', 70.15, 'Pacific Tug (Aust) PTY LTD', '/Date(1642647600000+1000)/', '/Date(1642662000000+1000)/', 'Shark Spit Anchorage', 'Queensport', 'SCHD', None, None, None, 624749, 710], [132538, 334816, 'EXT', 'WINCANTON', 'LIQUEFIED GAS TANKER', 119.95, 'Inchcape Shipping Services (Queensland)', '/Date(1642647600000+1000)/', '/Date(1642647600000+1000)/', 'SEA', 'Fairway Buoy Anchorage', 'PLAN', 'Newcastle', 'Newcastle', '264', 632386, 705], [132432, 334600, 'REM', 'PT KYTHIRA', 'TUG', 26.0, 'Pacific Tug (Aust) PTY LTD', '/Date(1642647600000+1000)/', '/Date(1642662000000+1000)/', 'Shark Spit Anchorage', 'Queensport', 'SCHD', 'Bundaberg', None, None, 570086, 710], [131727, 333300, 'ARR', 'SEMIRAMIS', 'BULK CARRIER', 228.9, 'Sturrock Grindrod Maritime (Mackay)', '/Date(1642647660000+1000)/', '/Date(1642653060000+1000)/', 'South Anchorage 09', 'HPS Berth 1', 'PLAN', 'Jingtang (Tangshan)', 'Singapore', 'TP0264', 633516, 705], [132130, 335179, 'ARR', 'CHORUS', 'BULK CARRIER', 228.99, 'Monson Agencies Australia (Mackay)', '/Date(1642649400000+1000)/', None, 'North Anchorage 06', 'DBCT Berth 3', 'SCHD', 'Busan', 'Kakogawa', '80', 633558, 710], [132439, 334614, 'EXT', 'SM TIGER', 'BULK CARRIER', 292.0, 'LBH Australia Pty Ltd (Mackay)', '/Date(1642649400000+1000)/', '/Date(1642649400000+1000)/', 'SEA for HPS', 'Anch for HPS & DBCT', 'PLAN', 'Kwangyang', 'Pohang', '50', 633640, 705], [132795, 335381, 'ARR', 'ALBATROSS BAY', 'LANDING CRAFT', 64.0, 'Sea Swift Pty Ltd', '/Date(1642651200000+1000)/', '/Date(1642654800000+1000)/', 'SEA', 'Horn Island', 'CONF', 'Cairns', 'Seisia', 'AB 2203', 633274, 725], [132433, 335356, 'ARR', 'PT NORFOLK', 'GENERAL CARGO BARGE', 70.15, 'Pacific Tug (Aust) PTY LTD', '/Date(1642651200000+1000)/', '/Date(1642654800000+1000)/', 'Bundaberg Anchorage', 'Marina', 'CONF', None, None, None, 624749, 725], [132428, 335355, 'REM', 'PT KYTHIRA', 'TUG', 26.0, 'Pacific Tug (Aust) PTY LTD', '/Date(1642651200000+1000)/', '/Date(1642654800000+1000)/', 'Bundaberg Anchorage', 'Marina', 'CONF', None, 'Brisbane', None, 570086, 725], [132295, 334319, 'DEP', 'HOEGH KOBE', 'VEHICLES CARRIER', 199.1, 'Seaway Agencies Pty Ltd', '/Date(1642654800000+1000)/', '/Date(1642669200000+1000)/', 'Wagners', 'SEA', 'SCHD', 'Auckland', 'Port Kembla', '68', 631289, 710], [132291, 334306, 'ARR', 'LOCH MAREE', 'BULK CARRIER', 176.83, 'Wave Shipping Pty Ltd', '/Date(1642655700000+1000)/', '/Date(1642672800000+1000)/', 'Point Cartwright Anchorage', 'Fisherman Island General Purpose Berth', 'SCHD', 'Fujairah', 'Lae', '9', 633744, 710], [132232, 334209, 'ARR', 'BLUE GRASS MARINER', 'TANKER', 183.06, 'Gulf Agency Company (Mackay)', '/Date(1642657200000+1000)/', '/Date(1642657260000+1000)/', 'Anch for MKY', 'Mackay Berth 1', 'SCHD', 'Gladstone', 'Singapore', None, 633566, 710], [132538, 334817, 'ARR', 'WINCANTON', 'LIQUEFIED GAS TANKER', 119.95, 'Inchcape Shipping Services (Queensland)', '/Date(1642657500000+1000)/', '/Date(1642668300000+1000)/', 'Fairway Buoy Anchorage', 'Fishermans Landing 5', 'CONF', 'Newcastle', 'Newcastle', '264', 632386, 725], [132473, 334686, 'EXT', 'GREAT CHEER', 'BULK CARRIER', 229.2, 'LBH Australia Pty Ltd (Mackay)', '/Date(1642658400000+1000)/', '/Date(1642658400000+1000)/', 'SEA for HPS', 'Anch for HPS & DBCT', 'PLAN', 'Kakogawa', 'Indonesia', '2201VC', 633677, 705], [132513, 334770, 'DEP', 'KAI YANG STAR', 'BULK CARRIER', 234.98, 'Wilhelmsen Ships Service (Weipa)', '/Date(1642659300000+1000)/', '/Date(1642666500000+1000)/', 'Lorim West', 'SEA', 'CONF', 'Dongjiakou', 'Qingdao', None, 633694, 725], [132575, 335351, 'EXT', 'IPSEA COLOSSUS', 'BULK CARRIER', 197.0, 'Monson Agencies Australia (Townsville & Abbot Point)', '/Date(1642662000000+1000)/', '/Date(1642662000000+1000)/', 'SEA', 'Abbot Point Anchorage', 'SCHD', 'Chittagong', None, None, 625240, 710], [132285, 334295, 'DEP', 'FW EXCURSIONIST', 'BULK CARRIER', 179.9, 'Wave Shipping Pty Ltd', '/Date(1642662000000+1000)/', '/Date(1642679100000+1000)/', 'Fisherman Island General Purpose Berth', 'SEA', 'SCHD', 'Busan', 'New Plymouth', '24', 633667, 710], [132364, 334463, 'EXT', 'JUPITER', 'BULK CARRIER', 225.0, 'LBH Australia Pty Ltd (Mackay)', '/Date(1642663800000+1000)/', '/Date(1642663800000+1000)/', 'SEA for DBCT', 'Anch for HPS & DBCT', 'PLAN', 'Rizhao', 'Singapore', '17', 633643, 705], [132781, 335342, 'DEP', 'MORNING CLARA', 'VEHICLES CARRIER', 199.9, 'Wilhelmsen Ships Service (Brisbane)', '/Date(1642665600000+1000)/', '/Date(1642680000000+1000)/', 'Fisherman Island No 1', 'SEA', 'SCHD', 'Tianjin', 'Port Kembla', '2251', 633093, 710], [131704, 333251, 'DEP', 'TANGGUH JAYA', 'LIQUEFIED GAS TANKER', 285.1, 'Wilhelmsen Ships Service (Gladstone)', '/Date(1642666500000+1000)/', '/Date(1642676400000+1000)/', 'Santos GLNG', 'SEA', 'CONF', 'Mexico', 'Incheon', None, 633458, 725], [130826, 331647, 'ARR', 'DL DAHLIA', 'BULK CARRIER', 229.0, 'Monson Agencies Australia (Gladstone)', '/Date(1642668300000+1000)/', '/Date(1642677300000+1000)/', 'Fairway Buoy Anchorage', 'Clinton Coal 1', 'CONF', 'Yeongheung', 'Tanjung Bin', '2712', 633296, 725], [132582, 334934, 'DEP', 'CORAL GEOGRAPHER', 'PASSENGER', 94.5, 'Coral Expeditions', '/Date(1642669200000+1000)/', '/Date(1642672800000+1000)/', 'C123', 'SEA', 'CONF', 'Cairns', 'Cairns', None, 633369, 725], [130422, 330911, 'DEP', 'NSU QUEST', 'BULK CARRIER', 299.94, 'Inchcape Shipping Services (Queensland)', '/Date(1642673700000+1000)/', '/Date(1642682700000+1000)/', 'Clinton Coal 3', 'SEA', 'CONF', 'Hay Point', 'Japan', '45', 632982, 725], [132795, 335383, 'REM', 'ALBATROSS BAY', 'LANDING CRAFT', 64.0, 'Sea Swift Pty Ltd', '/Date(1642674600000+1000)/', '/Date(1642676400000+1000)/', 'Horn Island', 'Main Jetty', 'CONF', 'Cairns', 'Seisia', 'AB 2203', 633274, 725], [132759, 335288, 'EXT', 'CMB PAUILLAC', 'BULK CARRIER', 235.0, 'Wilhelmsen Ships Service (Gladstone)', '/Date(1642675500000+1000)/', '/Date(1642679100000+1000)/', 'SEA', 'Fairway Buoy Anchorage', 'PLAN', 'Gove', 'Weipa', None, 633160, 705], [132430, 334596, 'DEP', 'GOLDEN YOSA', 'TANKER', 144.03, 'Sturrock Grindrod Maritime (Brisbane)', '/Date(1642676400000+1000)/', '/Date(1642692600000+1000)/', 'Viva Energy', 'SEA', 'SCHD', 'Geelong', 'Townsville', '74(C1)', 628015, 710], [132456, 334647, 'EXT', 'MISSY ENTERPRISE', 'GENERAL CARGO', 181.16, 'Wave Shipping Pty Ltd', '/Date(1642676400000+1000)/', '/Date(1642676460000+1000)/', 'SEA', 'Bundaberg Anchorage', 'PLAN', 'Singapore', 'Japan', '2', 631532, 705], [132389, 335619, 'EXT', 'GLOVIS CHORUS', 'VEHICLES CARRIER', 199.99, 'Gulf Agency Company (Brisbane)', '/Date(1642680000000+1000)/', '/Date(1642680000000+1000)/', 'SEA', 'Point Cartwright Anchorage', 'PLAN', 'Port Kembla', 'Pyeongtaek ', '77A', 630944, 705], [132505, 334744, 'EXT', 'NSU CHALLENGER', 'BULK CARRIER', 299.95, 'Gulf Agency Company (Gladstone)', '/Date(1642680000000+1000)/', '/Date(1642683600000+1000)/', 'SEA', 'Fairway Buoy Anchorage', 'PLAN', 'Nagoya', 'Oita', None, 633706, 705], [132727, 335219, 'EXT', 'RTM DIAS', 'BULK CARRIER', 234.87, 'Wilhelmsen Ships Service (Weipa)', '/Date(1642680900000+1000)/', '/Date(1642680900000+1000)/', 'SEA', 'Weipa Anchorage', 'PLAN', 'Gladstone', 'China', None, 633623, 705], [132859, 335500, 'ARR', 'FOURCROY', 'LANDING CRAFT', 49.8, 'Sea Swift Pty Ltd', '/Date(1642685400000+1000)/', '/Date(1642686900000+1000)/', 'SEA', 'Horn Island Barge Ramp', 'CONF', 'Saibai Island', 'Weipa', None, 633180, 725]], 'IsCustomMetaData': False, 'MetaData': {'__type': 'DataTableMetaDTO:#WebX.Core.DTO', 'Columns': [{'__type': 'ColumnMetaDTO:#WebX.Core.DTO', 'Format': '', 'HAlignment': 'haright', 'Name': 'VOYAGE_ID', 'SortIndex': -1, 'SortOrder': '', 'Sortable': True, 'Template': '', 'Title': 'Voyage Id', 'Visible': False, 'Width': '50px'}, {'__type': 'ColumnMetaDTO:#WebX.Core.DTO', 'Format': '', 'HAlignment': 'haright', 'Name': 'ID', 'SortIndex': -1, 'SortOrder': '', 'Sortable': True, 'Template': '', 'Title': 'Id', 'Visible': False, 'Width': '20px'}, {'__type': 'ColumnMetaDTO:#WebX.Core.DTO', 'Format': '', 'Name': 'JOB_TYPE_CODE', 'SortIndex': -1, 'SortOrder': '', 'Sortable': True, 'Template': '', 'Title': 'Job Type', 'Visible': True, 'Width': '71px'}, {'__type': 'ColumnMetaDTO:#WebX.Core.DTO', 'Format': '"link": {"title":"Ship Info", "type":"dashboard", "target":"_popup", "code":"standard.vesselinfo", "params":[{"name":"VID","value":"[%VESSEL_ID%]"}]}', 'Name': 'VESSEL_NAME', 'SortIndex': -1, 'SortOrder': '', 'Sortable': True, 'Template': '', 'Title': 'Ship', 'Visible': True, 'Width': '94px'}, {'__type': 'ColumnMetaDTO:#WebX.Core.DTO', 'Format': '', 'Name': 'MSQ_SHIP_TYPE', 'SortIndex': -1, 'SortOrder': '', 'Sortable': True, 'Template': '', 'Title': 'Ship Type', 'Visible': True, 'Width': '115px'}, {'__type': 'ColumnMetaDTO:#WebX.Core.DTO', 'Format': '', 'HAlignment': 'haright', 'Name': 'LOA', 'SortIndex': -1, 'SortOrder': '', 'Sortable': True, 'Template': '', 'Title': 'LOA', 'Visible': True, 'Width': '95px'}, {'__type': 'ColumnMetaDTO:#WebX.Core.DTO', 'Format': '', 'Name': 'AGENCY_NAME', 'SortIndex': -1, 'SortOrder': '', 'Sortable': True, 'Template': '', 'Title': 'Agency', 'Visible': True, 'Width': '287px'}, {'__type': 'ColumnMetaDTO:#WebX.Core.DTO', 'Format': '', 'Name': 'START_TIME', 'SortIndex': -1, 'SortOrder': '', 'Sortable': True, 'Template': '', 'Title': 'Start Time', 'Visible': True, 'Width': '91px'}, {'__type': 'ColumnMetaDTO:#WebX.Core.DTO', 'Format': '', 'Name': 'END_TIME', 'SortIndex': -1, 'SortOrder': '', 'Sortable': True, 'Template': '', 'Title': 'End Time', 'Visible': True, 'Width': '91px'}, {'__type': 'ColumnMetaDTO:#WebX.Core.DTO', 'Format': '', 'Name': 'FROM_LOCATION_NAME', 'SortIndex': -1, 'SortOrder': '', 'Sortable': True, 'Template': '', 'Title': 'From Location', 'Visible': True, 'Width': '139px'}, {'__type': 'ColumnMetaDTO:#WebX.Core.DTO', 'Format': '', 'Name': 'TO_LOCATION_NAME', 'SortIndex': -1, 'SortOrder': '', 'Sortable': True, 'Template': '', 'Title': 'To Location', 'Visible': True, 'Width': '139px'}, {'__type': 'ColumnMetaDTO:#WebX.Core.DTO', 'Format': '', 'Name': 'STATUS_TYPE_CODE', 'SortIndex': -1, 'SortOrder': '', 'Sortable': True, 'Template': '', 'Title': 'Status', 'Visible': True, 'Width': '83px'}, {'__type': 'ColumnMetaDTO:#WebX.Core.DTO', 'Format': '', 'Name': 'LASTPORT_NAME', 'SortIndex': -1, 'SortOrder': '', 'Sortable': True, 'Template': '', 'Title': 'Last Port', 'Visible': True, 'Width': '114px'}, {'__type': 'ColumnMetaDTO:#WebX.Core.DTO', 'Format': '', 'Name': 'NEXTPORT_NAME', 'SortIndex': -1, 'SortOrder': '', 'Sortable': True, 'Template': '', 'Title': 'Next Port', 'Visible': True, 'Width': '114px'}, {'__type': 'ColumnMetaDTO:#WebX.Core.DTO', 'Format': '', 'Name': 'VOYAGE_NUMBER', 'SortIndex': -1, 'SortOrder': '', 'Sortable': True, 'Template': '', 'Title': 'Voyage #', 'Visible': True, 'Width': '45px'}, {'__type': 'ColumnMetaDTO:#WebX.Core.DTO', 'Format': '', 'HAlignment': 'haright', 'Name': 'VESSEL_ID', 'SortIndex': -1, 'SortOrder': '', 'Template': '', 'Title': 'Vessel Id', 'Visible': False, 'Width': '64px'}, {'__type': 'ColumnMetaDTO:#WebX.Core.DTO', 'Format': '', 'HAlignment': 'haright', 'Name': 'STATUS_TYPE', 'SortIndex': -1, 'SortOrder': '', 'Template': '', 'Title': 'Status Type', 'Visible': False, 'Width': '64px'}], 'Script': 'var data = this.getData();\nvar $row = this.get$Row();\nvar $jobtype = this.get$Cell(\'JOB_TYPE\');\n\nvar $startTime = this.get$Cell(\'START_TIME\');\nvar $endTime = this.get$Cell(\'END_TIME\');\n\nif (data.JOB_TYPE == "Arrival")\n{\n  $jobtype.css(\'color\', \'green\');\n}\nif (data.JOB_TYPE == "Departure")\n{\n  $jobtype.css(\'color\', \'blue\');\n}\nif (data.JOB_TYPE == "Shift")\n{\n  $jobtype.css(\'color\', \'#8B7500\');\n}\nif (data.JOB_TYPE == "External")\n{\n  $jobtype.css(\'color\', \'grey\');\n}\n\nif (data.STATUS_TYPE >= 735 &&data.STATUS_TYPE < 750 )\n{\n    $startTime.css(\'font-weight\', \'bold\');\n    $endTime.css(\'font-weight\', \'bold\');\n    $startTime.css(\'font-style\', \'italic\');\n    $endTime.css(\'font-style\', \'italic\');\n}\n\n', 'TemplateRow': '', 'TemplateTable': '', 'Version': 0}, 'Name': 'DATA'}]}}

print(pd.json_normalize(my_dict))

                    d.__type d.BuildVersion  d.ReportCode                                           d.Tables
0  DataSetDTO:#WebX.Core.DTO    7.0.0.12590  MSQ-WEB-0001  [{'__type': 'DataTableDTO:#WebX.Core.DTO', 'Bu...

print(pd.json_normalize(my_dict, record_path=['Data']))

File "/Users/kevin_o'connell/opt/anaconda3/lib/python3.8/site-packages/pandas/io/json/_normalize.py", line 243, in _pull_field
result = result[spec]

KeyError: 'Data'

print(pd.concat({k: pd.DataFrame(v).T for k, v in my_dict.items()}, axis=0))

                                                                0
d __type                                DataSetDTO:#WebX.Core.DTO
  BuildVersion                                        7.0.0.12590
  ReportCode                                         MSQ-WEB-0001
  Tables        {'__type': 'DataTableDTO:#WebX.Core.DTO', 'Bui...

df = pd.json_normalize(my_dict['d'], 'Tables')

df = pd.DataFrame(df['Data'].T)

                                                Data
0  [[132393, 334520, EXT, CESI BEIHAI, LIQUEFIED ...

df = pd.json_normalize(my_dict['d'], record_path = 'Tables', meta = ['Data'], errors = 'ignore')

    raise ValueError(

ValueError: Conflicting metadata name Data, need distinguishing prefix 

    
    
    

    ODEN QUEST
    

    Creative Director
    
 
    

        T +1 408 456 7890
        

        M +1 408 456 8956
        
    

    1234 Main Street
    

    Sanita Clara, CA 95126
    
    

    STUDIO ICONIC
    info@studioiconic.net

d = {"Equipment": ["Gym", "Gym", "Class", "Class", "Office", "Office"],
"Details": ["Barbell", "Ball", "Desk", "Desk", "Chair", "Lamp"],
"Recipient": ["Ben", "Ben", "Ben", "Clara", "Clara", "John"]
}

df = pd.DataFrame.from_dict(d)

person1 = Person("Samuel", 5)
person2 = Person("Maria", 3)
person3 = Person("Samuel", 3)
person4 = Person("Maria", 6)
person5 = Person("Clara", 1)

person1 = Person("Samuel", 8)
person2 = Person("Maria", 9)
person3 = Person("Clara", 1);

int melhor_class(t_equipa *eqA, t_equipa *eqB)
{
    if(eqA->pontos > eqB->pontos){
        return 1;
    } else if(eqA->pontos < eqB->pontos){
        return 0;
    } else if(eqA->golosM > eqB->golosM){
        return 1;
    } else if(eqA->golosM < eqB->golosM){
        return 0;
    } else if(eqA->golosS < eqB->golosS){
        return 1;
    } else if(eqA->golosS > eqB->golosS){
        return 0;
    } else {
        return 1;
    }
}

void ordenar_equipas(t_equipa *e)
{
    for(int i = 0; i < NEQS - 1; i++)
    {
        for(int j = 0; j < NEQS - i - 1; j++)
        {
            if (melhor_class(&e[j],&e[j+1]) == 0)
            {
                //swaping part
                t_equipa temp = e[j];
                e[j] = e[j+1];
                e[j+1] = temp;
                
            }
        }
    }
}

                         P  V  E  D  M  S
Gil Vicente             33  0  0  0  18  7
Benfica                 32  0  0  0  10  10
Sporting                31  0  0  0  10  7
Porto                   24  0  0  0  20  8
Arouca                  0  0  0  0  0  0
Belenenses              0  0  0  0  0  0
Boavista                0  0  0  0  0  0
Braga                   0  0  0  0  0  0
Estoril                 0  0  0  0  0  0
Famalicao               0  0  0  0  0  0
Maritimo                0  0  0  0  0  0
Moreirense              0  0  0  0  0  0
Pacos Ferreira          0  0  0  0  0  0
Portimonense            0  0  0  0  0  0
Santa Clara             0  0  0  0  0  0
Tondela                 0  0  0  0  0  0
Vitoria                 0  0  0  0  0  0
Vizela                  0  0  0  0  0  0

void trocar_equipas(t_equipa *e, int p1, int p2)
{
    t_equipa temp = e[p1];
    e[p1] = e[p2];
    e[p2] = temp;

}

void ordenar_equipas(t_equipa *e)
{
    for(int i = 0; i < NEQS - 1; i++)
    {
        for(int j = 0; j < NEQS - i - 1; j++)
        {
            if (melhor_class(&e[j],&e[j+1]) == 0)
            {
                trocar_equipas(&e,j,j+1);
            }
        }
    }
}

                        P  V  E  D  M  S
Arouca                  0  0  0  0  0  0
Belenenses              0  0  0  0  0  0
Benfica                 32  0  0  0  10  10
Boavista                0  0  0  0  0  0
Braga                   0  0  0  0  0  0
Estoril                 0  0  0  0  0  0
Famalicao               0  0  0  0  0  0
Gil Vicente             33  0  0  0  18  7
Maritimo                0  0  0  0  0  0
Moreirense              0  0  0  0  0  0
Pacos Ferreira          0  0  0  0  0  0
Porto                   24  0  0  0  20  8
Portimonense            0  0  0  0  0  0
Santa Clara             0  0  0  0  0  0
Sporting                31  0  0  0  10  7
Tondela                 0  0  0  0  0  0
Vitoria                 0  0  0  0  0  0
Vizela                  0  0  0  0  0  0