names

62 rows where place_id = 623113

✎ 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
3750701 1942144 1942144 defendant Lusby Thomas husbandman 623113 623113 Lusby, Thomas, of Redham, husbandman 0
3750702 1942144 1942144 defendant Kensale Stephen husbandman 623113 623113 Kensale, Stephen, of Redham, husbandman 1
3883969 1984908 1984908 defendant Arnold Thomas husbandman 623113 623113 Arnold, Thomas, of Redham, husbandman 0
3883973 1984909 1984909 defendant Arnold Thomas husbandman 623113 623113 Arnold, Thomas, of Redham, husbandman 0
3934053 2001684 2001684 plaintiff Harward Gregory (legal representative) 623113 623113 Harward, Gregory, of Redham, gent, executrix of 0
4462364 2188926 2188926 defendant Mome John, senior   623113 623113 Mome, John, senior, of Redham 0
4542741 2213617 2213617 defendant Cotte William   623113 623113 Cotte, William, of Redham 0
4576813 2224256 2224256 defendant Ennesmerssh Thomas   623113 623113 Ennesmerssh, Thomas, of Redham 1
4669103 2256044 2256044 defendant Glovere John yeoman 623113 623113 Glovere, John, of Redham, yeoman 0
4739342 2277392 2277392 defendant Cotwode Geoffrey yeoman 623113 623113 Cotwode, Geoffrey, of Redham, yeoman 1
4751959 2281066 2281066 defendant Kirkby Richard yeoman 623113 623113 Kirkby, Richard, of Redham, yeoman 2
4806311 2298183 2298183 defendant Doket Roger yeoman 623113 623113 Doket, Roger, of Redham, yeoman 0
4830240 2305495 2305495 plaintiff Berney John esq 623113 623113 Berney, John, of Redham, esq 0
4836841 2307485 2307485 plaintiff Berneye John   623113 623113 Berneye, John, of Redham 1
4836846 2307486 2307486 plaintiff Berneye John   623113 623113 Berneye, John, of Redham 1
4878635 2320260 2320260 defendant Skot William yeoman 623113 623113 Skot, William, of Redham, yeoman 1
4882309 2321377 2321377 plaintiff Piers Edmund   623113 623113 Piers, Edmund, of Redham 0
4952793 2342792 2342792 defendant Tret John yeoman 623113 623113 Tret, John, of Redham, yeoman 1
4961075 2345276 2345276 plaintiff Berney John (legal representative) 623113 623113 Berney, John, of Redham, esq, executors of 0
4961079 2345277 2345277 plaintiff Berney John (legal representative) 623113 623113 Berney, John, of Redham, esq, executors of 0
4971278 2348346 2348346 defendant Berneye John, senior (legal representative) 623113 623113 Berneye, John, senior, of Redham, esq, executors of 0
4971280 2348346 2348346 defendant Peers Edmund gent 623113 623113 Peers, Edmund, of Redham, gent 2
4987514 2353223 2353223 plaintiff Berney John (legal representative) 623113 623113 Berney, John, of Redham, esq, executors of 0
4987515 2353223 2353223 plaintiff atte Lee John   623113 623113 (atte Lee, John, of Redham, parson 1
5091819 2383990 2383990 defendant Rysyng Edmund yeoman 623113 623113 Rysyng, Edmund, of Redham, yeoman 3
5094081 2384670 2384670 plaintiff Risyng Edmund   623113 623113 Risyng, Edmund, of Redham 0
5104440 2387724 2387724 defendant Preest William yeoman 623113 623113 Preest, William, of Redham, yeoman 1
5135803 2396986 2396986 plaintiff Monne Richard   623113 623113 Monne, Richard, of Redham 0
5135804 2396986 2396986 defendant Doke John husbandman 623113 623113 Doke, John, of Redham, husbandman 0
5135806 2396986 2396986 defendant Russhamer William husbandman 623113 623113 Russhamer, William, of Redham, husbandman 2
5156021 2402918 2402918 defendant Russhmer W_ husbandman 623113 623113 Russhmer, W_, of Redham, husbandman 0
5156024 2402919 2402919 plaintiff Mome Richard   623113 623113 Mome, Richard, of Redham 0
5156025 2402919 2402919 defendant Doke John husbandman 623113 623113 Doke, John, of Redham, husbandman 0
5156026 2402920 2402920 plaintiff Mome Richard   623113 623113 Mome, Richard, of Redham 0
5156746 2403133 2403133 defendant Reynold Thomas husbandman 623113 623113 Reynold, Thomas, of Redham, husbandman 2
5172829 2407786 2407786 defendant Reynald Thomas husbandman 623113 623113 Reynald, Thomas, of Redham, husbandman 2
5203189 2416694 2416694 defendant Prest William yeoman 623113 623113 Prest, William, of Redham, yeoman 0
5203190 2416694 2416694 defendant Prest Thomas husbandman 623113 623113 Prest, Thomas, of Redham, husbandman 1
5241830 2427811 2427811 defendant (not given) John rector of Herdfyssh 623113 623113 Herdfyssh, John, of Redham, clerk, rector of Skulthorp 0
5249085 2429852 2429852 defendant Swanton Thomas yeoman 623113 623113 Swanton, Thomas, of Redham, yeoman 0
5249089 2429853 2429853 defendant Swanton Thomas yeoman 623113 623113 Swanton, Thomas, of Redham, yeoman 0
5253887 2431329 2431329 defendant Smyth John yeoman 623113 623113 Smyth, John, of Redham, yeoman 2
5268426 2435891 2435891 plaintiff Berney John (legal representative) 623113 623113 Berney, John, of Redham, esq, executor of Philip Berney, esq, executor of 0
5278527 2438829 2438829 plaintiff Berney John esq 623113 623113 Berney, John, of Redham, esq 0
5278529 2438830 2438830 plaintiff Berney John (legal representative) 623113 623113 Berney, John, of Redham, esq, executor of Berneye, Philip, esq, executor of 0
5287900 2441477 2441477 plaintiff Swanton William yeoman 623113 623113 Swanton, William, of Redham, yeoman 1
5287901 2441477 2441477 plaintiff Wrampyll Geoffrey husbandman 623113 623113 Wrampyll, Geoffrey, of Redham, husbandman 2
5289031 2441802 2441802 defendant Swanton Thomas husbandman 623113 623113 Swanton, Thomas, of Redham, husbandman 0
5329551 2453901 2453901 defendant Mome Henry husbandman 623113 623113 Mome, Henry, of Redham, husbandman 9
5336334 2455934 2455934 defendant Hert John chaplain 623113 623113 Hert, John, of Redham, chaplain 0
5336336 2455935 2455935 defendant Hert John chaplain 623113 623113 Hert, John, of Redham, chaplain 0
5336623 2456022 2456022 defendant Meme or Mome Henry husbandman 623113 623113 Meme or Mome, Henry, of Redham, husbandman 2
5336883 2456098 2456098 defendant Wryght Walter husbandman 623113 623113 Wryght, Walter, of Redham, husbandman 0
5336884 2456098 2456098 defendant Scroweby or Stroweby Henry husbandman 623113 623113 Scroweby or Stroweby, Henry, of Redham, husbandman 1
5336885 2456098 2456098 defendant Gardener John husbandman 623113 623113 Gardener, John, of Redham, husbandman 2
5336886 2456098 2456098 defendant Deke John husbandman 623113 623113 Deke, John, of Redham, husbandman 3
5355437 2461775 2461775 defendant Patte Henry husbandman 623113 623113 Patte, Henry, of Redham, husbandman 0
5386338 2471160 2471160 defendant Wylde Simon husbandman 623113 623113 Wylde, Simon, of Redham, husbandman 0
5560062 2522901 2522901 defendant Goneld Richard husbandman 623113 623113 Goneld, Richard, of Redham, husbandman 2
5560064 2522901 2522901 defendant Wrampyll John husbandman 623113 623113 Wrampyll, John, of Redham, husbandman 4
5560068 2522902 2522902 defendant Goneld Richard husbandman 623113 623113 Goneld, Richard, of Redham, husbandman 2
5560069 2522902 2522902 defendant Wrampyll John husbandman 623113 623113 Wrampyll, John, of Redham, husbandman 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);