names

38 rows where place_id = 592465

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3607772 1870081 1870081 defendant Floure John, senior gent 592465 592465 Floure, John, senior, of Worton, gent 0
3888828 1986516 1986516 plaintiff Flowre John   592465 592465 Flowre, John, of Worton 0
3888835 1986517 1986517 plaintiff Flowre John   592465 592465 Flowre, John, of Worton 0
4040379 2039062 2039062 defendant Metcalf Edmund gent 592465 592465 Metcalf, Edmund, of Worton, gent 5
4040418 2039065 2039065 defendant Metcalf Edmund gent 592465 592465 Metcalf, Edmund, of Worton, gent 5
4235307 2107911 2107911 defendant Helliar or Hyllar Roger husbandman 592465 592465 Helliar or Hyllar, Roger, of Worton, husbandman 0
4254639 2114541 2114541 defendant Hellier or Hyllar Roger husbandman 592465 592465 Hellier or Hyllar, Roger, of Worton, husbandman 0
4322174 2137831 2137831 defendant Sewell Thomas gent 592465 592465 Sewell, Thomas, of Worton, gent 2
4322175 2137831 2137831 defendant Skarre Peter yeoman 592465 592465 Skarre, Peter, of Worton, yeoman 3
4322177 2137832 2137832 defendant Thompson Adam yeoman 592465 592465 Thompson, Adam, of Worton, yeoman 0
4322178 2137832 2137832 defendant Metcalfe Lawrence yeoman 592465 592465 Metcalfe, Lawrence, of Worton, yeoman 1
4322179 2137832 2137832 defendant Thompson Thomas yeoman 592465 592465 Thompson, Thomas, of Worton, yeoman 2
4322540 2137950 2137950 defendant Metcalf Lawrence yeoman 592465 592465 Metcalf, Lawrence, of Worton, yeoman 1
4322541 2137950 2137950 defendant Tompson Thomas yeoman 592465 592465 Tompson, Thomas, of Worton, yeoman 2
4322542 2137950 2137950 defendant Tompson Adam yeoman 592465 592465 Tompson, Adam, of Worton, yeoman 3
4365816 2152808 2152808 defendant Flower John gent 592465 592465 Flower, John, of Worton, gent 0
4368149 2153662 2153662 defendant Bowne William gent 592465 592465 Bowne, William, of Worton, or of Bassedon, Oxon, gent 0
4374515 2155947 2155947 defendant Metcalfe William gent 592465 592465 Metcalfe, William, of Worton, gent 0
4392774 2162201 2162201 defendant Flower John gent 592465 592465 Flower, John, of Worton, gent 0
4395111 2162952 2162952 defendant Skarr Alexander yeoman 592465 592465 Skarr, Alexander, of Worton, yeoman 2
4654148 2247180 2247180 defendant Floure William gent 592465 592465 Floure, William, of Worton, gent 0
4739495 2277436 2277436 defendant Feylde John husbandman 592465 592465 Feylde, John, of Worton, husbandman 0
4908073 2329084 2329084 defendant Tropenell John husbandman 592465 592465 Tropenell, John, of Worton, husbandman 2
5022257 2363403 2363403 defendant Cromhale John husbandman 592465 592465 Cromhale, John, of Worton, husbandman 0
5025207 2364267 2364267 defendant Floure Robert gent 592465 592465 Floure, Robert, of Worton, gent 0
5098583 2386018 2386018 defendant Rosse Walter husbandman 592465 592465 Rosse, Walter, of Worton, husbandman 4
5181340 2410285 2410285 defendant Floure Robert, sen gent 592465 592465 Floure, Robert, sen, of Worton, gent 0
5198676 2415369 2415369 defendant Floure Robert husbandman 592465 592465 Floure, Robert, of Worton, husbandman 0
5202877 2416604 2416604 defendant Floure Robert, sen gent 592465 592465 Floure, Robert, sen, of Worton, gent 0
5210668 2418861 2418861 defendant Floure Robert husbandman 592465 592465 Floure, Robert, of Worton, husbandman 0
5261977 2433855 2433855 defendant Cromale Robert husbandman 592465 592465 Cromale, Robert, of Worton, husbandman 2
5282212 2439862 2439862 defendant Cromale Robert husbandman 592465 592465 Cromale, Robert, of Worton, husbandman 3
5282213 2439862 2439862 defendant Cromale Thomas husbandman 592465 592465 Cromale, Thomas, of Worton, husbandman 4
5344336 2458409 2458409 defendant Cromale Robert husbandman 592465 592465 Cromale, Robert, of Worton, husbandman 0
5376173 2468138 2468138 defendant Floure John husbandman 592465 592465 Floure, John, of Worton, husbandman 2
5483770 2500092 2500092 defendant Floure John gent 592465 592465 Floure, John, of Worton, gent 2
5527225 2513094 2513094 defendant Flowere John gent 592465 592465 Flowere, John, of Worton, gent 0
5598763 2534490 2534490 defendant Barley William, senior husbandman 592465 592465 Barley, William, senior, of Worton, husbandman 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);