names

25 rows where place_id = 777945

✎ 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
4651072 2246336 2246336 defendant Keneworth William husbandman 777945 777945 Keneworth, William, of Heryettesham, husbandman 0
4668130 2255740 2255740 defendant Rasyll William husbandman 777945 777945 Rasyll, William, of Heryettesham, husbandman 2
4777293 2288888 2288888 defendant Graunt John laborer 777945 777945 Graunt, John, of Heryettesham, laborer 0
4777774 2289042 2289042 defendant Walton Richard butcher 777945 777945 Walton, Richard, of Heryettesham, butcher 0
4784227 2291066 2291066 defendant Walter Richard butcher 777945 777945 Walter, Richard, of Heryettesham, butcher 0
4876957 2319762 2319762 defendant Syre Robert husbandman 777945 777945 Syre, Robert, of Heryettesham, husbandman 0
4881038 2320981 2320981 defendant Waryn Robert rypier or fishmonger 777945 777945 Waryn, Robert, of Heryettesham, rypier or fishmonger 0
4939937 2338876 2338876 defendant Keneworth William repyer or fishmonger 777945 777945 Keneworth, William, of Heryettesham, repyer or fishmonger 1
5140566 2398350 2398350 defendant Clerk William repyer or inland fish seller 777945 777945 Clerk, William, of Heryettesham, repyer or inland fish seller 0
5215531 2420266 2420266 defendant Taillour John husbandman 777945 777945 Taillour, John, of Heryettesham, husbandman 0
5215567 2420275 2420275 defendant Rede William husbandman 777945 777945 Rede, William, of Heryettesham, husbandman 0
5215875 2420375 2420375 defendant Gregory Henry laborer 777945 777945 Gregory, Henry, of Heryettesham, laborer 2
5227259 2423602 2423602 defendant Feld Richard husbandman 777945 777945 Feld, Richard, of Heryettesham, husbandman 2
5227261 2423602 2423602 defendant Feld Alexander husbandman 777945 777945 Feld, Alexander, of Heryettesham, husbandman 4
5233928 2425512 2425512 defendant Taillour John yeoman 777945 777945 Taillour, John, of Heryettesham, yeoman 0
5237721 2426618 2426618 defendant Attelee Philip husbandman 777945 777945 Attelee, Philip, of Heryettesham, husbandman 1
5259552 2433110 2433110 defendant Voche John   777945 777945 Voche, John, of Heryettesham, "repiar" 2
5315007 2449541 2449541 defendant Bedmanton Thomas, junior husbandman 777945 777945 Bedmanton, Thomas, junior, of Heryettesham, husbandman 1
5353638 2461209 2461209 defendant Pylchard Henry   777945 777945 Pylchard, Henry, of Heryettesham, "repyer" 2
5353639 2461209 2461209 defendant Bodmanton William (legal representative) 777945 777945 Bodmanton, William, of Heryettesham, "repyer", executors of 3
5353640 2461209 2461209 defendant Bodmanton William husbandman 777945 777945 (Bodmanton, William, of Heryettesham, husbandman 4
5353641 2461209 2461209 defendant Pilchard Richard smith 777945 777945 Pilchard, Richard, of Heryettesham, smith 5
5355587 2461821 2461821 defendant Dodde Richard husbandman 777945 777945 Dodde, Richard, of Heryettesham, husbandman 0
5366174 2465082 2465082 defendant Bodmanton John, junior husbandman 777945 777945 Bodmanton, John, junior, of Heryettesham, husbandman 9
5629355 2553160 2553160 plaintiff Rasyll Thomas   777945 777945 Rasyll, Thomas, of Heryettesham 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);