names

46 rows where place_id = 588330

✎ 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
3594127 1865806 1865806 defendant Doget William gent 588330 588330 Doget, William, of Honyngham, Norf, gent 0
3717079 1931626 1931626 defendant Dogett Edmund or Edward gent 588330 588330 Dogett, Edmund or Edward, of Honyngham, Norf, gent 1
3955361 2008940 2008940 defendant Vyncent Henry yeoman 588330 588330 Vyncent, Henry, of Honyngham, Norf, yeoman 0
4018639 2031400 2031400 plaintiff Vyncent Henry   588330 588330 Vyncent, Henry, of Honyngham, Norf 0
4049713 2042337 2042337 plaintiff Vyncent Henry   588330 588330 Vyncent, Henry, of Honyngham, Norf 0
4049716 2042338 2042338 plaintiff Vyncent Henry   588330 588330 Vyncent, Henry, of Honyngham, Norf 0
4667241 2255487 2255487 defendant Fuller Henry husbandman 588330 588330 Fuller, Henry, of Honyngham, Norf, husbandman 0
4683263 2260372 2260372 defendant Rous Eustace husbandman 588330 588330 Rous, Eustace, of Honyngham, Norf, husbandman 0
4690077 2262448 2262448 defendant Rous Eustace   588330 588330 Rous, Eustace, of Honyngham, Norf, franklin 0
4723718 2272722 2272722 defendant Rous Eustace   588330 588330 Rous, Eustace, of Honyngham, Norf, franklin 0
4734127 2275857 2275857 defendant Rous Eustace   588330 588330 Rous, Eustace, of Honyngham, Norf, franklin 0
4740817 2277830 2277830 defendant Rous Eustace   588330 588330 Rous, Eustace, of Honyngham, Norf, franklin 0
4747905 2279894 2279894 defendant Rous Eustace   588330 588330 Rous, Eustace, of Honyngham, Norf, franklin 0
4748304 2280012 2280012 defendant Rous Eustace yeoman 588330 588330 Rous, Eustace, of Honyngham, Norf, yeoman 1
4772692 2287430 2287430 defendant Rous Eustace husbandman 588330 588330 Rous, Eustace, of Honyngham, Norf, husbandman 0
4788642 2292504 2292504 defendant Rous Eustace husbandman 588330 588330 Rous, Eustace, of Honyngham, Norf, husbandman 0
4835782 2307186 2307186 defendant Eustas Robert husbandman 588330 588330 Eustas, Robert, of Honyngham, Norf, husbandman 1
4903456 2327689 2327689 defendant Frampton John esq 588330 588330 Frampton, John, of Honyngham, Norf, esq 0
4911107 2329984 2329984 defendant Fedel John yeoman 588330 588330 Fedel, John, of Honyngham, Norf, yeoman 0
4933296 2336805 2336805 defendant Frampton John gent 588330 588330 Frampton, John, of Honyngham, Norf, gent 0
4936687 2337857 2337857 defendant Fedyl John yeoman 588330 588330 Fedyl, John, of Honyngham, Norf, yeoman 0
4973784 2349116 2349116 defendant Frampton John esq 588330 588330 Frampton, John, of Honyngham, Norf, esq 2
5077371 2379731 2379731 plaintiff Blakeney John esq 588330 588330 Blakeney, John, of Honyngham, Norf, esq 0
5077373 2379732 2379732 plaintiff Blakeney John esq 588330 588330 Blakeney, John, of Honyngham, Norf, esq 0
5077375 2379733 2379733 plaintiff Blakeney John esq 588330 588330 Blakeney, John, of Honyngham, Norf, esq 0
5131164 2395605 2395605 defendant Norman John esq 588330 588330 Norman, John, of Honyngham, Norf, esq 0
5136296 2397134 2397134 plaintiff Norman John esq 588330 588330 Norman, John, of Honyngham, Norf, esq 0
5150645 2401338 2401338 defendant Norman John esq 588330 588330 Norman, John, of Honyngham, Norf, esq 0
5160489 2404158 2404158 defendant Norman John esq 588330 588330 Norman, John, of Honyngham, Norf, esq 0
5232516 2425090 2425090 defendant Norman John gent 588330 588330 Norman, John, of Honyngham, Norf, gent 0
5232523 2425091 2425091 defendant Norman John gent 588330 588330 Norman, John, of Honyngham, Norf, gent 0
5246102 2429024 2429024 defendant Norman John gent 588330 588330 Norman, John, of Honyngham, Norf, gent 0
5246110 2429025 2429025 defendant Norman John esq 588330 588330 Norman, John, of Honyngham, Norf, esq 0
5252768 2430975 2430975 defendant Norman John esq 588330 588330 Norman, John, of Honyngham, Norf, esq 0
5259428 2433071 2433071 defendant Norman John esq 588330 588330 Norman, John, of Honyngham, Norf, esq 2
5259432 2433072 2433072 defendant Norman John esq 588330 588330 Norman, John, of Honyngham, Norf, esq 2
5270203 2436383 2436383 defendant Blakeney John esq 588330 588330 Blakeney, John, of Honyngham, Norf, esq 2
5298101 2444457 2444457 defendant Norman John esq 588330 588330 Norman, John, of Honyngham, Norf, esq 0
5312920 2448897 2448897 defendant Norman John esq 588330 588330 Norman, John, of Honyngham, Norf, esq 1
5383736 2470432 2470432 defendant Doget William gent 588330 588330 Doget, William, of Honyngham, Norf, gent 2
5395563 2473810 2473810 defendant Doget William gent 588330 588330 Doget, William, of Honyngham, Norf, gent 2
5408843 2477606 2477606 defendant Doget William gent 588330 588330 Doget, William, of Honyngham, Norf, gent 1
5580613 2529019 2529019 defendant Doget Edmund gent 588330 588330 Doget, Edmund, of Honyngham, Norf, gent 1
5580616 2529020 2529020 defendant Doget Edmund gent 588330 588330 Doget, Edmund, of Honyngham, Norf, gent 1
5580619 2529021 2529021 defendant Doget Edmund gent 588330 588330 Doget, Edmund, of Honyngham, Norf, gent 1
5580622 2529022 2529022 defendant Doget Edmund gent 588330 588330 Doget, Edmund, of Honyngham, Norf, gent 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);