names

66 rows where place_id = 589331

✎ 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
3597248 1866761 1866761 defendant Kokeham Thomas husbandman 589331 589331 Kokeham, Thomas, of Dersyngham, husbandman 0
3600821 1867920 1867920 defendant Bullok Robert pedder 589331 589331 Bullok, Robert, of Dersyngham, pedder 0
3656553 1912302 1912302 defendant Vychers Edmund   589331 589331 Vychers, Edmund, of Dersyngham, shepherd 1
3748973 1941611 1941611 defendant Shorttyng William tanner 589331 589331 Shorttyng, William, of Dersyngham, tanner 1
3803907 1959134 1959134 defendant Coke William butcher 589331 589331 Coke, William, of Dersyngham, butcher 1
3980330 2017735 2017735 defendant Hunt Robert husbandman 589331 589331 Hunt, Robert, of Dersyngham, husbandman 0
3994282 2022707 2022707 defendant Pell John gent 589331 589331 Pell, John, of Dersyngham, gent 0
4163855 2082885 2082885 defendant Grounde Robert husbandman 589331 589331 Grounde, Robert, of Dersyngham, husbandman 0
4222554 2103380 2103380 defendant Chaddok Nicholas gent 589331 589331 Chaddok, Nicholas, of Dersyngham, gent 2
4388890 2160914 2160914 defendant Makyn Geoffrey laborer 589331 589331 Makyn, Geoffrey, of Dersyngham, laborer 2
4456943 2187181 2187181 defendant Kirkeman John   589331 589331 Kirkeman, John, of Dersyngham 0
4458788 2187795 2187795 plaintiff Reve Alice   589331 589331 Reve, Alice, of Dersyngham 0
4526158 2208470 2208470 plaintiff Kirkeman John   589331 589331 Kirkeman, John, of Dersyngham 0
4565601 2220812 2220812 defendant Millere John   589331 589331 Millere, John, of Dersyngham, formerly farmer for Thomas Roo 2
4567042 2221247 2221247 defendant atte Lanesende Nicholas   589331 589331 atte Lanesende, Nicholas, of Dersyngham 2
4574771 2223631 2223631 plaintiff Kirkeman John   589331 589331 Kirkeman, John, of Dersyngham 1
4587577 2227519 2227519 defendant Smyth John   589331 589331 Smyth, John, of Dersyngham 0
4653120 2246912 2246912 defendant Kirkeman John, junior pedder 589331 589331 Kirkeman, John, junior, of Dersyngham, pedder 0
4653245 2246953 2246953 defendant Drowery William husbandman 589331 589331 Drowery, William, of Dersyngham, husbandman 0
4653247 2246954 2246954 defendant Palet Robert husbandman 589331 589331 Palet, Robert, of Dersyngham, husbandman 0
4653252 2246956 2246956 defendant Golde Adam yeoman 589331 589331 Golde, Adam, of Dersyngham, yeoman 0
4655585 2247636 2247636 defendant Goolde Adam husbandman 589331 589331 Goolde, Adam, of Dersyngham, husbandman 0
4659716 2248889 2248889 defendant Golde Adam shipman 589331 589331 Golde, Adam, of Dersyngham, shipman 3
4663598 2250093 2250093 plaintiff Goolde Adam   589331 589331 Goolde, Adam, of Dersyngham 0
4673282 2257284 2257284 defendant Gold Adam farmer 589331 589331 Gold, Adam, of Dersyngham, farmer 0
4683921 2260581 2260581 defendant Goolde Adam husbandman 589331 589331 Goolde, Adam, of Dersyngham, husbandman 0
4690193 2262488 2262488 defendant Golce Adam husbandman or husband 589331 589331 Golce, Adam, of Dersyngham, husbandman or husband 0
4695574 2264100 2264100 defendant Golde Adam   589331 589331 Golde, Adam, of Dersyngham husbandman 0
4706490 2267410 2267410 defendant Golde Adam yeoman 589331 589331 Golde, Adam, of Dersyngham, yeoman 0
4720560 2271765 2271765 defendant Golde Adam husbandman 589331 589331 Golde, Adam, of Dersyngham, husbandman 1
4751135 2280809 2280809 defendant Doget Roger husbandman 589331 589331 Doget, Roger, of Dersyngham, husbandman 1
4752031 2281086 2281086 defendant Doget Roger pedder 589331 589331 Doget, Roger, of Dersyngham, pedder 2
4752032 2281086 2281086 defendant Hake Martin yeoman 589331 589331 Hake, Martin, of Dersyngham, yeoman 3
4823677 2303496 2303496 defendant Baxstere Thomas husbandman 589331 589331 Baxstere, Thomas, of Dersyngham, husbandman 3
4857170 2313627 2313627 defendant Shenkewyn Richard butcher 589331 589331 Shenkewyn, Richard, of Dersyngham, butcher 0
4873069 2318532 2318532 defendant Andrewe Adam   589331 589331 Andrewe, Adam, of Dersyngham, wright 0
4881297 2321052 2321052 defendant Shenkwyn Richard yeoman 589331 589331 Shenkwyn, Richard, of Dersyngham, yeoman 3
4949885 2341941 2341941 defendant Sweyn William husbandman 589331 589331 Sweyn, William, of Dersyngham, husbandman 19
4984804 2352386 2352386 defendant Cornell John pedder 589331 589331 Cornell, John, of Dersyngham, pedder 3
4984805 2352386 2352386 defendant Mannyng Thomas pedder 589331 589331 Mannyng, Thomas, of Dersyngham, pedder 4
5025084 2364236 2364236 defendant Pelle John husbandman 589331 589331 Pelle, John, of Dersyngham, husbandman 0
5025085 2364236 2364236 defendant Pelle John, junior husbandman 589331 589331 Pelle, John, junior, of Dersyngham, husbandman 1
5119917 2392260 2392260 defendant Geryng William yeoman 589331 589331 Geryng, William, of Dersyngham, yeoman 2
5140774 2398415 2398415 defendant Shenkewyn Richard yeoman 589331 589331 Shenkewyn, Richard, of Dersyngham, yeoman 0
5161900 2404589 2404589 defendant Shenkewyn Richard yeoman 589331 589331 Shenkewyn, Richard, of Dersyngham, yeoman 0
5176154 2408714 2408714 defendant Shenkewyn Richard yeoman 589331 589331 Shenkewyn, Richard, of Dersyngham, yeoman 0
5179851 2409841 2409841 defendant Mannyng Thomas husbandman 589331 589331 Mannyng, Thomas, of Dersyngham, husbandman 2
5179855 2409842 2409842 defendant Mannyng Thomas husbandman 589331 589331 Mannyng, Thomas, of Dersyngham, husbandman 2
5198066 2415178 2415178 defendant Shenkewyn Richard yeoman 589331 589331 Shenkewyn, Richard, of Dersyngham, yeoman 0
5202090 2416377 2416377 defendant Mannyng Thomas husbandman 589331 589331 Mannyng, Thomas, of Dersyngham, husbandman 2
5202749 2416569 2416569 defendant Mannyng Thomas husbandman 589331 589331 Mannyng, Thomas, of Dersyngham, husbandman 0
5232678 2425139 2425139 defendant Shenkwyn Richard husbandman 589331 589331 Shenkwyn, Richard, of Dersyngham, husbandman 0
5234434 2425662 2425662 defendant Mannyng Thomas husbandman 589331 589331 Mannyng, Thomas, of Dersyngham, husbandman 0
5234435 2425662 2425662 defendant Shynkwyn Richard husbandman 589331 589331 Shynkwyn, Richard, of Dersyngham, husbandman 1
5242587 2428038 2428038 defendant Mannyng Thomas husbandman 589331 589331 Mannyng, Thomas, of Dersyngham, husbandman 0
5281580 2439678 2439678 defendant Shenkwyn Richard yeoman 589331 589331 Shenkwyn, Richard, of Dersyngham, yeoman 2
5288648 2441701 2441701 defendant Mannyng Thomas husbandman 589331 589331 Mannyng, Thomas, of Dersyngham, husbandman 0
5295131 2443566 2443566 defendant Shenkwyn Richard yeoman 589331 589331 Shenkwyn, Richard, of Dersyngham, yeoman 1
5341604 2457564 2457564 defendant Baxster John yeoman 589331 589331 Baxster, John, of Dersyngham, yeoman 2
5360619 2463354 2463354 defendant Cabelle or Capelle William clerk 589331 589331 Cabelle or Capelle, William, of Dersyngham, clerk 0
5538302 2516465 2516465 defendant Plane John yeoman 589331 589331 Plane, John, of Dersyngham, yeoman 0
5558803 2522529 2522529 defendant Edmund Nicholas clerk 589331 589331 Edmund, Nicholas, of Dersyngham, clerk 0
5558810 2522530 2522530 defendant Edmund Nicholas husbandman 589331 589331 Edmund, Nicholas, of Dersyngham, husbandman 4
5589444 2531700 2531700 defendant Mayne John husbandman 589331 589331 Mayne, John, of Dersyngham, husbandman 0
5624725 2551664 2551664 defendant Ropere John roper 589331 589331 Ropere, John, of Dersyngham, roper 0
5636605 2555393 2555393 defendant Kirkeman John, junior yeoman 589331 589331 Kirkeman, John, junior, of Dersyngham, yeoman 0

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