names

19 rows where place_id = 591946

✎ 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
3606080 1869569 1869569 defendant Candeler Nicholas yeoman 591946 591946 Candeler, Nicholas, of Pykenham, yeoman 0
3878924 1983204 1983204 defendant Bettys William husbandman 591946 591946 Bettys, William, of Pykenham, husbandman 0
4416376 2170009 2170009 defendant Aspale Thomas de   591946 591946 Aspale, Thomas de, of Pykenham 2
4427766 2173521 2173521 defendant Tyoys Thomas   591946 591946 Tyoys, Thomas, of Pykenham 1
4544267 2214122 2214122 defendant Souter Robert   591946 591946 Souter, Robert, of Pykenham 2
4545583 2214539 2214539 defendant Fouldon John   591946 591946 Fouldon, John, of Pykenham 1
4557226 2218194 2218194 defendant Caudeler John   591946 591946 Caudeler, John, of Pykenham 0
4557231 2218195 2218195 defendant Caudeler John   591946 591946 Caudeler, John, of Pykenham 0
4577611 2224505 2224505 defendant Flappe Walter   591946 591946 Flappe, Walter, of Pykenham 5
4595999 2229997 2229997 defendant Ropere John   591946 591946 Ropere, John, of Pykenham 2
4619486 2237087 2237087 defendant Sikelere Thomas   591946 591946 Sikelere, Thomas, of Pykenham 0
4633309 2241280 2241280 defendant Cand_ John   591946 591946 Cand_, John, of Pykenham 5
4707140 2267613 2267613 defendant Freman John ostler 591946 591946 Freman, John, of Pykenham, ostler 1
4725640 2273304 2273304 defendant Fayrman John yeoman 591946 591946 Fayrman, John, of Pykenham, yeoman 9
4809391 2299114 2299114 plaintiff Dowell Edmund   591946 591946 Dowell, Edmund, of Pykenham 0
5045412 2370258 2370258 defendant Jesep John glover 591946 591946 Jesep, John, of Pykenham, glover 0
5181065 2410205 2410205 defendant Fawne Richard miller 591946 591946 Fawne, Richard, of Pykenham, miller 2
5243147 2428197 2428197 defendant Sponer Henry (legal representative) 591946 591946 Sponer, Henry, of Pykenham, executors of 0
5632651 2554232 2554232 defendant Heylot John clerk 591946 591946 Heylot, John, of Pykenham, clerk 7

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