names

33 rows where place_id = 600567

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: case_id, surname, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3641583 1907827 1907827 defendant Burgage John husbandman 600567 600567 Burgage, John, of Upcherche, husbandman 2
3651439 1910814 1910814 defendant Clerke William husbandman 600567 600567 Clerke, William, of Upcherche, husbandman 1
3651440 1910814 1910814 defendant Wode Thomas husbandman 600567 600567 Wode, Thomas, of Upcherche, husbandman 2
3693428 1924160 1924160 defendant Ryder Thomas husbandman 600567 600567 Ryder, Thomas, of Upcherche, husbandman 2
3696508 1925136 1925136 defendant Godyn Lawrence husbandman 600567 600567 Godyn, Lawrence, of Upcherche, husbandman 1
4590023 2228240 2228240 defendant Greneweye Robert   600567 600567 Greneweye, Robert, of Upcherche 1
4675733 2258018 2258018 defendant Uptone Thomas shipman 600567 600567 Uptone, Thomas, of Upcherche, shipman 0
4675734 2258018 2258018 defendant Aylard Stephen shipman 600567 600567 Aylard, Stephen, of Upcherche, shipman 1
4675735 2258018 2258018 defendant Herbard John   600567 600567 Herbard, John, of Upcherche, shipherd or shepherd 2
4711070 2268815 2268815 defendant Herberd John laborer 600567 600567 Herberd, John, of Upcherche, laborer 0
4711071 2268815 2268815 defendant Herberd Thomas laborer 600567 600567 Herberd, Thomas, of Upcherche, laborer 1
4718888 2271250 2271250 defendant Bokyngfold Helen widow 600567 600567 Bokyngfold, Helen, of Upcherche, widow 0
4718896 2271251 2271251 defendant Hervard John   600567 600567 Hervard, John, of Upcherche, shepherd 2
4719885 2271565 2271565 defendant Upton Thomas shipman 600567 600567 Upton, Thomas, of Upcherche, shipman 1
4745171 2279093 2279093 defendant Aylard Stephen   600567 600567 Aylard, Stephen, of Upcherche, shepherd 0
4750341 2280580 2280580 defendant Broke John husbandman 600567 600567 Broke, John, of Upcherche, husbandman 0
4794041 2294272 2294272 defendant Bocton William husbandman 600567 600567 Bocton, William, of Upcherche, husbandman 1
4795100 2294615 2294615 defendant Goldhord James husbandman 600567 600567 Goldhord, James, of Upcherche, husbandman 1
4963990 2346139 2346139 defendant Gibbe Michael husbandman 600567 600567 Gibbe, Michael, of Upcherche, husbandman 3
5068559 2377085 2377085 defendant Page Richard laborer 600567 600567 Page, Richard, of Upcherche, laborer 2
5068560 2377085 2377085 defendant Clerk John laborer 600567 600567 Clerk, John, of Upcherche, laborer 3
5081681 2381027 2381027 defendant Johnson Robert butcher 600567 600567 Johnson, Robert, of Upcherche, butcher 1
5105740 2388128 2388128 defendant Colyn John husbandman 600567 600567 Colyn, John, of Upcherche, husbandman 3
5128662 2394867 2394867 defendant Wroughton William husbandman 600567 600567 Wroughton, William, of Upcherche, husbandman 0
5217110 2420744 2420744 defendant Colyn John (legal representative) 600567 600567 Colyn, John, of Upcherche, yeoman, administrator of 0
5342223 2457763 2457763 defendant Berough John waterman 600567 600567 Berough, John, of Upcherche, waterman 0
5342224 2457763 2457763 defendant Wade William waterman 600567 600567 Wade, William, of Upcherche, waterman 1
5581658 2529344 2529344 defendant Skelton Thomas husbandman 600567 600567 Skelton, Thomas, of Upcherche, husbandman 0
5581660 2529345 2529345 defendant Skelton Thomas husbandman 600567 600567 Skelton, Thomas, of Upcherche, husbandman 0
5581662 2529346 2529346 defendant Skelton Thomas husbandman 600567 600567 Skelton, Thomas, of Upcherche, husbandman 0
5589809 2531803 2531803 defendant Hogge Nicholas laborer 600567 600567 Hogge, Nicholas, of Upcherche, laborer 0
5589810 2531803 2531803 defendant Fryday William laborer 600567 600567 Fryday, William, of Upcherche, laborer 1
5625947 2552072 2552072 defendant Meller David miller 600567 600567 Meller, David, of Upcherche, miller 0

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);