names

36 rows where place_id = 677823

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
4028741 2034927 2034927 defendant Lont Thomas husbandman 677823 677823 Lont, Thomas, of Whitstable, husbandman 3
4028747 2034928 2034928 defendant Lont or Lout Thomas husbandman 677823 677823 Lont or Lout, Thomas, of Whitstable, husbandman 3
4226158 2104621 2104621 defendant Smelt Andrew husbandman 677823 677823 Smelt, Andrew, of Whitstable, husbandman 0
4236490 2108336 2108336 defendant Easton Stephen yeoman 677823 677823 Easton, Stephen, of Whitstable, yeoman 1
4320903 2137405 2137405 defendant Barker Henry yeoman 677823 677823 Barker, Henry, of Whitstable, yeoman 0
4549101 2215655 2215655 defendant Bocher Robert   677823 677823 Bocher, Robert, of Whitstable 1
4580053 2225249 2225249 defendant Aleyn William   677823 677823 Aleyn, William, of Whitstable 0
4716654 2270528 2270528 defendant Bakere John husbandman 677823 677823 Bakere, John, of Whitstable, husbandman 1
4718955 2271274 2271274 defendant Fitement John laborer 677823 677823 Fitement, John, of Whitstable, laborer 1
4769186 2286339 2286339 defendant Fytement John smith 677823 677823 Fytement, John, of Whitstable, smith 4
4839056 2308144 2308144 defendant Kenrath John chaplain 677823 677823 Kenrath, John, of Whitstable, chaplain 3
4839057 2308144 2308144 defendant Northwode Thomas husbandman 677823 677823 Northwode, Thomas, of Whitstable, husbandman 4
4848190 2310905 2310905 defendant Cotyng Thomas butcher 677823 677823 Cotyng, Thomas, of Whitstable, butcher 1
5007798 2359175 2359175 plaintiff Steven John   677823 677823 Steven, John, of Whitstable 0
5161165 2404365 2404365 defendant Eylmer Walter laborer 677823 677823 Eylmer, Walter, of Whitstable, laborer 2
5161166 2404365 2404365 defendant Watte Nicholas laborer 677823 677823 Watte, Nicholas, of Whitstable, laborer 3
5197076 2414890 2414890 defendant Edward John, sen yeoman 677823 677823 Edward, John, sen, of Whitstable, yeoman 0
5297514 2444279 2444279 defendant Stephyn John   677823 677823 Stephyn, John, of Whitstable 0
5297516 2444280 2444280 defendant Stephyn John yeoman 677823 677823 Stephyn, John, of Whitstable, yeoman 0
5302127 2445592 2445592 defendant Whithale Thomas husbandman 677823 677823 Whithale, Thomas, of Whitstable, husbandman 0
5309306 2447823 2447823 defendant Bolle John laborer 677823 677823 Bolle, John, of Whitstable, laborer 3
5377371 2468511 2468511 defendant Elmer Thomas husbandman 677823 677823 Elmer, Thomas, of Whitstable, husbandman 0
5388065 2471646 2471646 defendant Gilmyn William shipman 677823 677823 Gilmyn, William, of Whitstable, shipman 1
5388067 2471646 2471646 defendant Balser Malcolm laborer 677823 677823 Balser, Malcolm, of Whitstable, laborer 3
5409277 2477743 2477743 defendant Russell Richard smith 677823 677823 Russell, Richard, of Whitstable, smith 0
5420764 2481135 2481135 defendant Stephyn John   677823 677823 Stephyn, John, of Whitstable 0
5421749 2481442 2481442 defendant Edward John husbandman 677823 677823 Edward, John, of Whitstable, husbandman 0
5421751 2481442 2481442 defendant Gilmyn William shipman 677823 677823 Gilmyn, William, of Whitstable, shipman 2
5421753 2481442 2481442 defendant Balser Makelimus or Malcolm laborer 677823 677823 Balser, Makelimus or Malcolm, of Whitstable, laborer 4
5429627 2483798 2483798 defendant Elnore Thomas husbandman 677823 677823 Elnore, Thomas, of Whitstable, husbandman 2
5429632 2483799 2483799 defendant Elnore Thomas husbandman 677823 677823 Elnore, Thomas, of Whitstable, husbandman 2
5439731 2486824 2486824 defendant Stephyn John yeoman 677823 677823 Stephyn, John, of Whitstable, yeoman 0
5466315 2494861 2494861 defendant Gylmyn William shipman 677823 677823 Gylmyn, William, of Whitstable, shipman 0
5466421 2494895 2494895 defendant Edward John husbandman 677823 677823 Edward, John, of Whitstable, husbandman 0
5466423 2494895 2494895 defendant Gylmyn (illegible) shipman 677823 677823 Gylmyn, _, of Whitstable, shipman 2
5466425 2494895 2494895 defendant Balsar Malcolm laborer 677823 677823 Balsar, Malcolm, of Whitstable, laborer 4

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