names

83 rows where place_id = 616182

✎ 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
3713069 1930413 1930413 defendant Myll William gent 616182 616182 Myll, William, of Gretham, gent 0
3713076 1930413 1930413 defendant Charilman Robert husbandman 616182 616182 Charilman, Robert, of Gretham, husbandman 7
3713079 1930414 1930414 defendant Myll William gent 616182 616182 Myll, William, of Gretham, gent 0
3713082 1930414 1930414 defendant Charilman Robert husbandman 616182 616182 Charilman, Robert, of Gretham, husbandman 3
3713083 1930414 1930414 defendant Charilman Henry husbandman 616182 616182 Charilman, Henry, of Gretham, husbandman 4
3760870 1945403 1945403 plaintiff Downowe Robert   616182 616182 Downowe, Robert, of Gretham 0
3780327 1951579 1951579 defendant Chase John husbandman 616182 616182 Chase, John, of Gretham, husbandman 2
3815501 1962763 1962763 defendant Syngleton Robert clerk 616182 616182 Syngleton, Robert, of Gretham, clerk 0
3886991 1985913 1985913 defendant Walker James yeoman 616182 616182 Walker, James, of Gretham, yeoman 0
3886992 1985913 1985913 defendant Loke John husbandman 616182 616182 Loke, John, of Gretham, husbandman 1
4098619 2059836 2059836 defendant Wolff Richard gent 616182 616182 Wolff, Richard, of Gretham, gent 2
4163314 2082696 2082696 defendant Willyams Arthur gent 616182 616182 Willyams, Arthur, of Gretham, gent 0
4362794 2151752 2151752 defendant Cockborne George clerk 616182 616182 Cockborne, George, of Gretham, clerk 0
4362795 2151752 2151752 defendant Hostler John yeoman 616182 616182 Hostler, John, of Gretham, yeoman 1
4362796 2151752 2151752 defendant Hodgeson John yeoman 616182 616182 Hodgeson, John, of Gretham, yeoman 2
4362798 2151753 2151753 defendant Cockborne George clerk 616182 616182 Cockborne, George, of Gretham, clerk 0
4367188 2153323 2153323 defendant Humfrey John yeoman 616182 616182 Humfrey, John, of Gretham, yeoman 0
4432055 2174807 2174807 plaintiff Chaumberleyn John   616182 616182 Chaumberleyn, John, of Gretham 0
4459631 2188067 2188067 plaintiff Salman John   616182 616182 Salman, John, of Gretham, on his own account 0
4459638 2188070 2188070 plaintiff Salmon John   616182 616182 Salmon, John, of Gretham 0
4465813 2189978 2189978 defendant Dole John   616182 616182 Dole, John, of Gretham 1
4465814 2189978 2189978 defendant Bretham John   616182 616182 Bretham, John, of Gretham 2
4488960 2197264 2197264 plaintiff Taillour Richard   616182 616182 Taillour, Richard, of Gretham 0
4491084 2197900 2197900 defendant Knot John   616182 616182 Knot, John, of Gretham 2
4501072 2200939 2200939 defendant Clerk John   616182 616182 (Clerk, John, of Gretham 1
4524620 2208034 2208034 plaintiff Horkynson Henry   616182 616182 Horkynson, Henry, of Gretham 0
4541497 2213236 2213236 plaintiff Wright John   616182 616182 Wright, John, of Gretham 0
4554741 2217409 2217409 plaintiff Halyngton John   616182 616182 Halyngton, John, of Gretham 0
4554742 2217409 2217409 defendant Osgodby Thomas   616182 616182 Osgodby, Thomas, of Gretham 0
4565396 2220745 2220745 defendant Weller John   616182 616182 Weller, John, of Gretham 0
4573907 2223356 2223356 defendant Thornton John   616182 616182 Thornton, John, of Gretham 1
4580225 2225302 2225302 defendant Knotte Henry   616182 616182 Knotte, Henry, of Gretham 0
4600098 2231256 2231256 defendant Sadeler Geoffrey   616182 616182 Sadeler, Geoffrey, of Gretham 2
4617753 2236553 2236553 defendant Sedare William   616182 616182 Sedare, William, of Gretham 0
4636561 2242263 2242263 defendant Wederley Thomas   616182 616182 Wederley, Thomas, of Gretham 0
4682883 2260264 2260264 defendant Burgeys Robert husbandman 616182 616182 Burgeys, Robert, of Gretham, husbandman 1
4692606 2263204 2263204 defendant Pecok John yeoman 616182 616182 Pecok, John, of Gretham, yeoman 0
4699617 2265331 2265331 defendant Hardy John husbandman 616182 616182 Hardy, John, of Gretham, husbandman 2
4705116 2266972 2266972 defendant Hapsey Richard   616182 616182 Hapsey, Richard, of Gretham, parson, formerly deacon of Alton 4
4711393 2268894 2268894 defendant Pecok John yeoman 616182 616182 Pecok, John, of Gretham, yeoman 2
4713457 2269531 2269531 defendant Pekock John   616182 616182 Pekock, John, of Gretham, single man 0
4726880 2273673 2273673 defendant Pecok John laborer 616182 616182 Pecok, John, of Gretham, laborer 0
4742685 2278369 2278369 defendant Kemp Robert husbandman 616182 616182 Kemp, Robert, of Gretham, husbandman 1
4770504 2286751 2286751 plaintiff Rede John   616182 616182 Rede, John, of Gretham, parson 0
4802212 2296883 2296883 defendant Plympton William gent 616182 616182 Plympton, William, of Gretham, gent 0
4836976 2307523 2307523 defendant Stykeney John husbandman 616182 616182 Stykeney, John, of Gretham, husbandman 1
4837139 2307568 2307568 defendant Eger John laborer 616182 616182 Eger, John, of Gretham, laborer 0
4842285 2309119 2309119 plaintiff Sutton Andrew   616182 616182 (Sutton, Andrew, of Gretham, parson & master 1
4846640 2310459 2310459 defendant Money Simon husbandman 616182 616182 Money, Simon, of Gretham, husbandman 1
4853630 2312552 2312552 defendant Storrs John yeoman 616182 616182 Storrs, John, of Gretham, yeoman 1
4853634 2312553 2312553 defendant Storror John yeoman 616182 616182 Storror, John, of Gretham, yeoman 1
4858445 2314015 2314015 defendant Plumpton William gent 616182 616182 Plumpton, William, of Gretham, gent 0
4866636 2316525 2316525 defendant Storour John husbandman 616182 616182 Storour, John, of Gretham, husbandman 2
4891393 2324037 2324037 defendant Chaas Henry husbandman 616182 616182 Chaas, Henry, of Gretham, husbandman 0
4925968 2334554 2334554 defendant Dumpyng Thomas husbandman 616182 616182 Dumpyng, Thomas, of Gretham, husbandman 0
4925975 2334555 2334555 defendant Dumpyng Thomas husbandman 616182 616182 with Dumpyng, Thomas, of Gretham, husbandman 2
4936665 2337852 2337852 defendant Plumpton William gent 616182 616182 Plumpton, William, of Gretham, gent 0
4966640 2346957 2346957 defendant Cartwryght Thomas   616182 616182 Cartwryght, Thomas, of Gretham, cartwright 1
4978375 2350479 2350479 defendant Cartwryght Thomas   616182 616182 Cartwryght, Thomas, of Gretham, cartwright 0
4999539 2356736 2356736 plaintiff Sutton Andrew   616182 616182 (Sutton, Andrew, of Gretham, parson 1
4999544 2356737 2356737 plaintiff Sutton Andrew   616182 616182 (Sutton, Andrew, of Gretham, parson of the church 1
5001609 2357363 2357363 defendant Chaumberleyn Thomas husbandman 616182 616182 Chaumberleyn, Thomas, of Gretham, husbandman 3
5013295 2360725 2360725 plaintiff atte Mille Thomas   616182 616182 atte Mille, Thomas, of Gretham 0
5013296 2360725 2360725 defendant atte Mille Robert   616182 616182 atte Mille, Robert, of Gretham, millward 0
5028250 2365139 2365139 defendant Chaumberleyn Thomas husbandman 616182 616182 Chaumberleyn, Thomas, of Gretham, husbandman 0
5035485 2367238 2367238 defendant Plompton William gent 616182 616182 Plompton, William, of Gretham, gent 0
5061336 2374973 2374973 defendant Cowesby Roger clerk 616182 616182 Cowesby, Roger, of Gretham, clerk 1
5068589 2377096 2377096 defendant Mille Robert gent 616182 616182 Mille, Robert, of Gretham, gent 0
5073304 2378504 2378504 defendant atte Mylle Richard husbandman 616182 616182 atte Mylle, Richard, of Gretham, husbandman 4
5128106 2394694 2394694 defendant Plumpton William husbandman 616182 616182 Plumpton, William, of Gretham, husbandman 0
5128107 2394694 2394694 defendant Plumpton John   616182 616182 Plumpton, John, of Gretham, servant 1
5147193 2400318 2400318 defendant Plumpton William husbandman 616182 616182 Plumpton, William, of Gretham, husbandman 0
5147194 2400318 2400318 defendant Plumpton John   616182 616182 Plumpton, John, of Gretham, servant 1
5166980 2406075 2406075 defendant Plumpton William husbandman 616182 616182 Plumpton, William, of Gretham, husbandman 0
5166981 2406075 2406075 defendant Plumpton John   616182 616182 Plumpton, John, of Gretham, servant 1
5227707 2423722 2423722 defendant Cowesy Roger clerk 616182 616182 Cowesy, Roger, of Gretham, clerk 1
5227708 2423722 2423722 defendant Cowesy Thomas husbandman 616182 616182 Cowesy, Thomas, of Gretham, husbandman 2
5231030 2424675 2424675 defendant Plumpton Henry husbandman 616182 616182 Plumpton, Henry, of Gretham, husbandman 0
5231031 2424675 2424675 defendant Plumpton John husbandman 616182 616182 Plumpton, John, of Gretham, husbandman 1
5289834 2442033 2442033 defendant Frankeleyn William yeoman 616182 616182 Frankeleyn, William, of Gretham, yeoman 2
5315407 2449668 2449668 defendant Plompton John yeoman 616182 616182 Plompton, John, of Gretham, yeoman 0
5321248 2451453 2451453 defendant Mille Richard gent 616182 616182 Mille, Richard, of Gretham, gent 0
5339649 2456974 2456974 defendant Blakehurst John laborer 616182 616182 Blakehurst, John, of Gretham, laborer 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);