names

27 rows where place_id = 759193

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
4440835 2182049 2182049 plaintiff Beylham Edmund   759193 759193 Beylham, Edmund, of Herdewyk, parson 0
4459799 2188117 2188117 defendant Northfeld William   759193 759193 Northfeld, William, of Herdewyk 0
4468286 2190750 2190750 defendant St Maure Thomas de   759193 759193 St Maure, Thomas de, of Herdewyk 0
4469905 2191252 2191252 defendant Corsour Alan   759193 759193 Corsour, Alan, of Herdewyk 2
4482660 2195283 2195283 plaintiff Morce John   759193 759193 Morce, John, of Herdewyk, on his own account 0
4554736 2217406 2217406 defendant Fraryclerk Henry   759193 759193 Fraryclerk, Henry, of Herdewyk 3
4565440 2220759 2220759 defendant Graunt William   759193 759193 Graunt, William, of Herdewyk 0
4594092 2229412 2229412 defendant Coupere Richard   759193 759193 Coupere, Richard, of Herdewyk 0
4594904 2229661 2229661 defendant Hykkes William   759193 759193 Hykkes, William, of Herdewyk 0
4594906 2229661 2229661 defendant Webbe David   759193 759193 Webbe, David, of Herdewyk 2
4604401 2232546 2232546 defendant Saltere John   759193 759193 Saltere, John, of Herdewyk 6
4621384 2237681 2237681 defendant Clerk John   759193 759193 Clerk, John, of Herdewyk 2
4621389 2237682 2237682 defendant Clerk John   759193 759193 Clerk, John, of Herdewyk 2
4661975 2249585 2249585 defendant Bartelot William husbandman 759193 759193 Bartelot, William, of Herdewyk, husbandman 1
4675206 2257858 2257858 defendant Bartelot William husbandman 759193 759193 Bartelot, William, of Herdewyk, husbandman 1
4676422 2258237 2258237 defendant Aleynson William yeoman 759193 759193 Aleynson, William, of Herdewyk, yeoman 0
4722417 2272331 2272331 plaintiff Cole John (legal representative) 759193 759193 Cole, John, of Herdewyk, executors of 0
4737733 2276904 2276904 defendant Halle John husbandman 759193 759193 Halle, John, of Herdewyk, husbandman 3
4738495 2277132 2277132 plaintiff Whelere Thomas   759193 759193 Whelere, Thomas, of Herdewyk 0
4772914 2287499 2287499 defendant Ponder or Pouder Richard husbandman 759193 759193 Ponder or Pouder, Richard, of Herdewyk, husbandman 1
4786443 2291807 2291807 defendant Mullesworth William gent 759193 759193 Mullesworth, William, of Herdewyk, gent 0
4868177 2317024 2317024 plaintiff Huton William   759193 759193 Huton, William, of Herdewyk 0
5004367 2358173 2358173 defendant Farndon William laborer 759193 759193 Farndon, William, of Herdewyk, laborer 3
5440928 2487195 2487195 defendant Bedull Henry   759193 759193 Bedull, Henry, of Herdewyk 17
5634999 2554932 2554932 defendant Tubbyng Hugh husbandman 759193 759193 Tubbyng, Hugh, of Herdewyk, husbandman 0
5635000 2554932 2554932 defendant de Coton William husbandman 759193 759193 de Coton, William, of Herdewyk, husbandman 1
5635001 2554932 2554932 defendant Freman Cecily widow 759193 759193 Freman, Cecily, of Herdewyk, widow 2

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