names

55 rows where place_id = 762696

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
4490301 2197664 2197664 defendant Everard John   762696 762696 Everard, John, of Hicchen 0
4490303 2197665 2197665 defendant Everard John   762696 762696 Everard, John, of Hicchen 0
4490305 2197666 2197666 defendant Godmar John   762696 762696 Godmar, John, of Hicchen 0
4490307 2197667 2197667 defendant Godmar John   762696 762696 Godmar, John, of Hicchen 0
4495892 2199393 2199393 defendant Alisaundre alias Savage Thomas   762696 762696 Alisaundre alias Savage, Thomas, of Hicchen 0
4540401 2212896 2212896 plaintiff Style John   762696 762696 Style, John, of Hicchen 2
4540405 2212897 2212897 plaintiff Style John   762696 762696 Style, John, of Hicchen 2
4577993 2224623 2224623 defendant Wrong John   762696 762696 Wrong, John, of Hicchen 3
4628898 2239969 2239969 defendant Love William   762696 762696 Love, William, of Hicchen 0
4628900 2239970 2239970 defendant Love William   762696 762696 Love, William, of Hicchen 0
4630164 2240345 2240345 defendant Multon John   762696 762696 Multon, John, of Hicchen 0
4630757 2240512 2240512 defendant Bene Hugh   762696 762696 Bene, Hugh, of Hicchen 0
4643423 2244180 2244180 defendant Wafrere Thomas   762696 762696 Wafrere, Thomas, of Hicchen 0
4643430 2244181 2244181 defendant Wafrere Thomas   762696 762696 Wafrere, Thomas, of Hicchen 0
4648122 2245512 2245512 defendant Multon John   762696 762696 Multon, John, of Hicchen 0
4752828 2281281 2281281 defendant Clophill Robert (legal representative) 762696 762696 Clophill, Robert, of Hicchen, executors of 2
4761599 2283973 2283973 defendant Gente John cooper 762696 762696 Gente, John, of Hicchen, cooper 1
4783516 2290861 2290861 defendant Fleccher Robert hostler 762696 762696 Fleccher, Robert, of Hicchen, hostler 2
4828757 2305035 2305035 defendant Bray John   762696 762696 Bray, John, of Hicchen, school master 1
4828758 2305035 2305035 defendant Boldre John weaver 762696 762696 Boldre, John, of Hicchen, weaver 2
4828767 2305037 2305037 defendant Bray John   762696 762696 Bray, John, of Hicchen, school master 1
4828768 2305037 2305037 defendant Boldre John weaver 762696 762696 Boldre, John, of Hicchen, weaver 2
4831858 2305986 2305986 defendant Bayes John butcher 762696 762696 Bayes, John, of Hicchen, butcher 0
4837173 2307578 2307578 defendant Love or Lone William butcher 762696 762696 Love or Lone, William, of Hicchen, butcher 0
4861663 2315023 2315023 defendant Coterell Luke husbandman 762696 762696 Coterell, Luke, of Hicchen, husbandman 0
4861665 2315024 2315024 defendant Malyn John   762696 762696 Malyn, John, of Hicchen, tile maker 0
4880153 2320705 2320705 defendant Malyn John tiler 762696 762696 Malyn, John, of Hicchen, tiler 2
4898394 2326153 2326153 defendant Lawe John husbandman 762696 762696 Lawe, John, of Hicchen, husbandman 0
4899047 2326344 2326344 defendant Bierne John husbandman 762696 762696 Bierne, John, of Hicchen, husbandman 0
4899048 2326344 2326344 defendant Byerne John, junior husbandman 762696 762696 Byerne, John, junior, of Hicchen, husbandman 1
4935745 2337571 2337571 plaintiff Besteneye Richard   762696 762696 Besteneye, Richard, of Hicchen 0
4943275 2339870 2339870 defendant Taillour John butcher 762696 762696 Taillour, John, of Hicchen, butcher 0
4960624 2345143 2345143 defendant Leper John chapman 762696 762696 Leper, John, of Hicchen, chapman 1
4977529 2350243 2350243 plaintiff Pulter John draper 762696 762696 Pulter, John, of Hicchen, draper 0
4977530 2350243 2350243 defendant Coterell Luke yeoman 762696 762696 Coterell, Luke, of Hicchen, yeoman 0
4982982 2351821 2351821 defendant Catworth Thomas chapman 762696 762696 Catworth, Thomas, of Hicchen, chapman 4
5009766 2359737 2359737 defendant Boldre John yeoman 762696 762696 Boldre, John, of Hicchen, yeoman 0
5009776 2359739 2359739 defendant Preest Thomas husbandman 762696 762696 Preest, Thomas, of Hicchen, husbandman 0
5010427 2359920 2359920 defendant Beaufewe Thomas ostler 762696 762696 Beaufewe, Thomas, of Hicchen, ostler 0
5012362 2360468 2360468 defendant Gent John carter 762696 762696 Gent, John, of Hicchen, carter 0
5053784 2372733 2372733 plaintiff Beaufu Thomas   762696 762696 Beaufu, Thomas, of Hicchen 0
5091923 2384018 2384018 defendant Knotte Geoffrey husbandman 762696 762696 Knotte, Geoffrey, of Hicchen, husbandman 0
5091925 2384018 2384018 defendant Joynour John smith 762696 762696 Joynour, John, of Hicchen, smith 2
5093656 2384541 2384541 plaintiff Pyte John, senior   762696 762696 Pyte, John, senior, of Hicchen 0
5093657 2384541 2384541 defendant Scotte William pulter 762696 762696 Scotte, William, of Hicchen, pulter 0
5093661 2384541 2384541 defendant Malyn John, senior husbandman 762696 762696 Malyn, John, senior, of Hicchen, husbandman 4
5116183 2391160 2391160 defendant Beaufewe Thomas gent 762696 762696 Beaufewe, Thomas, of Hicchen, gent 0
5212586 2419428 2419428 defendant Quylard Ralph butcher 762696 762696 Quylard, Ralph, of Hicchen, butcher 1
5212763 2419481 2419481 plaintiff Beaufewe Thomas, senior   762696 762696 Beaufewe, Thomas, senior, of Hicchen 0
5212768 2419482 2419482 plaintiff Beaufewe Thomas, senior   762696 762696 Beaufewe, Thomas, senior, of Hicchen 0
5610006 2546835 2546835 defendant Walnysford Robert   762696 762696 Walnysford, Robert, of Hicchen 0
5613305 2547943 2547943 defendant Walmesford Robert   762696 762696 Walmesford, Robert, of Hicchen 2
5622412 2550935 2550935 plaintiff Vynter Heloise or Hawise   762696 762696 Vynter, Heloise or Hawise, of Hicchen, formerly wife of Luke le Vynter 0
5622414 2550935 2550935 defendant Everard John   762696 762696 Everard, John, of Hicchen 1
5622422 2550936 2550936 defendant Baily John   762696 762696 Baily, John, of Hicchen, son of William 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);