names

22 rows where place_id = 624793

✎ 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
3760334 1945236 1945236 defendant Cukkowe John butcher 624793 624793 Cukkowe, John, of Byllerica, butcher 0
3760335 1945236 1945236 defendant Cukkowe William butcher 624793 624793 Cukkowe, William, of Byllerica, butcher 1
3819125 1963873 1963873 defendant Trowey Robert yeoman 624793 624793 Trowey, Robert, of Byllerica, yeoman 0
3920856 1997319 1997319 defendant Whyppoll William smith 624793 624793 Whyppoll, William, of Byllerica, smith 0
4060286 2046077 2046077 defendant Rombolle or Rombolde John saddler 624793 624793 Rombolle or Rombolde, John, of Byllerica, saddler 0
4233000 2107049 2107049 defendant Page John   624793 624793 Page, John, of Byllerica, collar maker 0
4370910 2154652 2154652 defendant Wakes Joan spinster 624793 624793 Wakes, Joan, of Byllerica, spinster 1
4599704 2231124 2231124 plaintiff Syden John   624793 624793 Syden, John, of Byllerica 0
4856136 2313290 2313290 defendant Horeward John cobbler 624793 624793 Horeward, John, of Byllerica, cobbler 4
5017976 2362140 2362140 defendant Palmer John burcher 624793 624793 Palmer, John, of Byllerica, burcher 0
5017977 2362140 2362140 defendant Wylee William burcher 624793 624793 Wylee, William, of Byllerica, burcher 1
5100732 2386639 2386639 defendant Basset Thomas woolman 624793 624793 Basset, Thomas, of Byllerica, woolman 2
5107086 2388500 2388500 defendant Markeday Thomas husbandman 624793 624793 Markeday, Thomas, of Byllerica, husbandman 0
5107088 2388500 2388500 defendant Kyng John husbandman 624793 624793 Kyng, John, of Byllerica, husbandman 2
5118084 2391723 2391723 defendant Sprot Richard husbandman 624793 624793 Sprot, Richard, of Byllerica, husbandman 0
5118085 2391723 2391723 defendant Swetyng John cooper 624793 624793 Swetyng, John, of Byllerica, cooper 1
5120835 2392525 2392525 defendant Clerk Robert carpenter 624793 624793 Clerk, Robert, of Byllerica, carpenter 0
5286289 2440997 2440997 defendant Pende John woolman 624793 624793 Pende, John, of Byllerica, woolman 0
5388466 2471753 2471753 defendant Hatche Roger woolman 624793 624793 Hatche, Roger, of Byllerica, woolman 0
5404169 2476270 2476270 defendant Brownn John butcher 624793 624793 Brownn, John, of Byllerica, butcher 0
5469186 2495714 2495714 defendant Brynkley John shoemaker 624793 624793 Brynkley, John, of Byllerica, shoemaker 0
5500404 2505064 2505064 defendant Ponde John (legal representative) 624793 624793 Ponde, John, of Byllerica, executors of 3

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