names

38 rows where place_id = 781892

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, surname, forename, occupation, raw_segment, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3662807 1914284 1914284 defendant Almer Nicholas   781892 781892 Almer, Nicholas, of Newmarket, Cambs, inn holder 1
4674919 2257766 2257766 defendant Kerkeby John gent 781892 781892 Kerkeby, John, of Newmarket, Cambs, gent 0
4677959 2258724 2258724 defendant Kirleby John gent 781892 781892 Kirleby, John, of Newmarket, Cambs, gent 0
4705944 2267237 2267237 defendant Clerk John husbandman 781892 781892 Clerk, John, of Newmarket, Cambs, husbandman 0
4711798 2269015 2269015 defendant Kyrkeby John   781892 781892 Kyrkeby, John, of Newmarket, Cambs, franklin 0
4724409 2272930 2272930 defendant Kirkeby John gent 781892 781892 Kirkeby, John, of Newmarket, Cambs, gent 0
4724414 2272931 2272931 defendant Kirkeby John gent 781892 781892 Kirkeby, John, of Newmarket, Cambs, gent 0
4724420 2272933 2272933 defendant Kirkeby John gent 781892 781892 Kirkeby, John, of Newmarket, Cambs, gent 0
4726000 2273419 2273419 plaintiff Goodhewyn William   781892 781892 Goodhewyn, William, of Newmarket, Cambs 0
4751068 2280796 2280796 defendant Kirkeby John gent 781892 781892 Kirkeby, John, of Newmarket, Cambs, gent 1
4764407 2284856 2284856 defendant Watirman John   781892 781892 Watirman, John, of Newmarket, Cambs, servant 3
4764408 2284856 2284856 defendant Bocher Robert husbandman 781892 781892 Bocher, Robert, of Newmarket, Cambs, husbandman 4
4817714 2301627 2301627 defendant Frere John hosteler 781892 781892 Frere, John, of Newmarket, Cambs, hosteler 0
4817716 2301628 2301628 defendant Frere John hosteler 781892 781892 Frere, John, of Newmarket, Cambs, hosteler 0
4843899 2309610 2309610 defendant Wyntyr John   781892 781892 Wyntyr, John, of Newmarket, Cambs, shoe maker 2
4848117 2310882 2310882 defendant Reyngney Thomas ostler 781892 781892 Reyngney, Thomas, of Newmarket, Cambs, ostler 0
4913899 2330854 2330854 defendant Hatewrong Thomas yeoman 781892 781892 Hatewrong, Thomas, of Newmarket, Cambs, yeoman 0
4919277 2332539 2332539 defendant Osteler William yeoman 781892 781892 Osteler, William, of Newmarket, Cambs, yeoman 1
4932255 2336488 2336488 defendant Walshe William ostler 781892 781892 Walshe, William, of Newmarket, Cambs, ostler 2
4988991 2353644 2353644 defendant Leyceter Thomas yeoman 781892 781892 Leyceter, Thomas, of Newmarket, Cambs, yeoman 1
5038827 2368256 2368256 defendant Leyceter Thomas, senior husbandman 781892 781892 Leyceter, Thomas, senior, of Newmarket, Cambs, husbandman 1
5163186 2404964 2404964 defendant Greyson Arthur yeoman 781892 781892 Greyson, Arthur, of Newmarket, Cambs, yeoman 2
5174284 2408184 2408184 defendant Leyston John yeoman 781892 781892 Leyston, John, of Newmarket, Cambs, yeoman 0
5176951 2408951 2408951 defendant Greyson Arthur yeoman 781892 781892 Greyson, Arthur, of Newmarket, Cambs, yeoman 2
5194895 2414255 2414255 defendant Leyston John yeoman 781892 781892 Leyston, John, of Newmarket, Cambs, yeoman 0
5194899 2414256 2414256 defendant Leyston John yeoman 781892 781892 Leyston, John, of Newmarket, Cambs, yeoman 0
5194903 2414257 2414257 defendant Leyston John yeoman 781892 781892 Leyston, John, of Newmarket, Cambs, yeoman 0
5199601 2415627 2415627 defendant Greyson Arthur yeoman 781892 781892 Greyson, Arthur, of Newmarket, Cambs, yeoman 0
5199605 2415628 2415628 defendant Gi_son Arthur yeoman 781892 781892 Gi_son, Arthur, of Newmarket, Cambs, yeoman 2
5305676 2446704 2446704 defendant Wolpet Thomas hosteller 781892 781892 Wolpet, Thomas, of Newmarket, Cambs, hosteller 0
5376710 2468313 2468313 defendant Greyson John gent 781892 781892 Greyson, John, of Newmarket, Cambs, gent 0
5380023 2469338 2469338 defendant Parsyn Thomas husbandman 781892 781892 Parsyn, Thomas, of Newmarket, Cambs, husbandman 1
5383794 2470449 2470449 defendant Parsyfall Thomas husbandman 781892 781892 Parsyfall, Thomas, of Newmarket, Cambs, husbandman 1
5408910 2477625 2477625 defendant Parsyvall Thomas husbandman 781892 781892 Parsyvall, Thomas, of Newmarket, Cambs, husbandman 1
5408917 2477627 2477627 defendant Parsyvall Thomas husbandman 781892 781892 Parsyvall, Thomas, of Newmarket, Cambs, husbandman 1
5427839 2483280 2483280 defendant Grey Thomas chapman 781892 781892 Grey, Thomas, of Newmarket, Cambs, chapman 2
5458226 2492362 2492362 defendant Grey Thomas chapman 781892 781892 Grey, Thomas, of Newmarket, Cambs, chapman 0
5458802 2492524 2492524 defendant Boydon Thomas husbandman 781892 781892 Boydon, Thomas, of Newmarket, Cambs, husbandman 1

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

CREATE TABLE names (
    id INTEGER PRIMARY KEY AUTOINCREMENT,
    case_id INTEGER NOT NULL REFERENCES cases(id) ON DELETE CASCADE,
    role TEXT NOT NULL CHECK (role IN ('plaintiff', 'defendant')),
    surname TEXT NOT NULL,
    forename TEXT,
    occupation TEXT,
    place_id INTEGER REFERENCES places(id),
    raw_segment TEXT NOT NULL,
    seq INTEGER NOT NULL DEFAULT 0
);
CREATE INDEX idx_names_case_id ON names(case_id);
CREATE INDEX idx_names_surname ON names(surname);
CREATE INDEX idx_names_place_id ON names(place_id);
CREATE INDEX idx_names_role_surname ON names(role, surname);