names

355 rows where place_id = 586576

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3589083 1864232 1864232 defendant Chyld John husbandman 586576 586576 Chyld, John, of Wytham, husbandman 0
3655020 1911835 1911835 defendant Netlam John yeoman 586576 586576 Netlam, John, of Wytham, yeoman 0
3658635 1912955 1912955 defendant Pulter Thomas yeoman 586576 586576 Pulter, Thomas, of Wytham, yeoman 0
3706937 1928454 1928454 defendant Howlett Hugh butcher 586576 586576 Howlett, Hugh, of Wytham, butcher 3
3714143 1930724 1930724 defendant Hodge William butcher 586576 586576 Hodge, William, of Wytham, butcher 1
3714144 1930724 1930724 defendant Howlett Hugh butcher 586576 586576 Howlett, Hugh, of Wytham, butcher 2
3717032 1931612 1931612 defendant Pakeman John, senior husbandman 586576 586576 Pakeman, John, senior, of Wytham, husbandman 0
3727049 1934725 1934725 defendant Hodgge William butcher 586576 586576 Hodgge, William, of Wytham, butcher 1
3727050 1934725 1934725 defendant Howlett Hugh butcher 586576 586576 Howlett, Hugh, of Wytham, butcher 2
3729491 1935470 1935470 defendant Hodgge William butcher 586576 586576 Hodgge, William, of Wytham, butcher 1
3729492 1935470 1935470 defendant Howlet Hugh butcher 586576 586576 Howlet, Hugh, of Wytham, butcher 2
3741283 1939134 1939134 defendant Walser Robert mariner 586576 586576 Walser, Robert, of Wytham, mariner 0
3757158 1944220 1944220 defendant Garard John yeoman 586576 586576 Garard, John, of Wytham, yeoman 0
3757957 1944472 1944472 defendant Sparke John carpenter 586576 586576 Sparke, John, of Wytham, carpenter 0
3761128 1945485 1945485 defendant Garrard John, senior yeoman 586576 586576 Garrard, John, senior, of Wytham, yeoman 0
3761130 1945485 1945485 defendant Payn John yeoman 586576 586576 Payn, John, of Wytham, yeoman 2
3777543 1950727 1950727 defendant Payn Thomas smith 586576 586576 Payn, Thomas, of Wytham, smith 0
3827900 1966589 1966589 defendant Turnour Thomas innholder 586576 586576 Turnour, Thomas, of Wytham, innholder 1
3827901 1966589 1966589 defendant Payne John   586576 586576 Payne, John, of Wytham, pale maker 2
3829978 1967271 1967271 plaintiff Ecressall John gent 586576 586576 Ecressall, John, of Wytham, gent 0
3829979 1967271 1967271 defendant Rowland Nicholas yeoman 586576 586576 Rowland, Nicholas, of Wytham, yeoman 0
3848587 1973140 1973140 defendant Barrell John butcher 586576 586576 Barrell, John, of Wytham, butcher 4
3859628 1976714 1976714 defendant Wyndewell Robert husbandman 586576 586576 Wyndewell, Robert, of Wytham, husbandman 0
3860933 1977145 1977145 defendant Crystmas John yeoman 586576 586576 Crystmas, John, of Wytham, yeoman 0
3867128 1979247 1979247 defendant Malard John sherman 586576 586576 Malard, John, of Wytham, sherman 0
3867733 1979440 1979440 defendant Shethe John (legal representative) 586576 586576 Shethe, John, of Wytham, yeoman, executrix of 0
3867734 1979440 1979440 defendant Shethe Joan widow 586576 586576 Shethe, Joan, of Wytham, widow 1
3867738 1979441 1979441 defendant Shethe John (legal representative) 586576 586576 Shethe, John, of Wytham, yeoman, executrix of 0
3867739 1979441 1979441 defendant Shethe Joan widow 586576 586576 Shethe, Joan, of Wytham, widow 1
3902513 1991073 1991073 defendant Hutte John, junior innholder 586576 586576 Hutte, John, junior, of Wytham, innholder 0
3902515 1991074 1991074 defendant Raven John butcher 586576 586576 Raven, John, of Wytham, butcher 0
3902517 1991075 1991075 defendant Warner John husbandman 586576 586576 Warner, John, of Wytham, husbandman 0
3924685 1998570 1998570 defendant Colman John laborer 586576 586576 Colman, John, of Wytham, laborer 2
3924686 1998570 1998570 defendant Crakbone Thomas laborer 586576 586576 Crakbone, Thomas, of Wytham, laborer 3
3944975 2005337 2005337 defendant Nunne John roper 586576 586576 Nunne, John, of Wytham, roper 0
3954532 2008655 2008655 defendant Cowmeley William baker 586576 586576 Cowmeley, William, of Wytham, baker 1
3981671 2018201 2018201 defendant Cole Peter butcher 586576 586576 Cole, Peter, of Wytham, butcher 1
4128701 2070559 2070559 defendant Hyll John laborer 586576 586576 Hyll, John, of Wytham, laborer 1
4129389 2070814 2070814 defendant Haryngton John esq 586576 586576 Haryngton, John, of Wytham, esq 0
4129390 2070814 2070814 defendant Flowers Henry husbandman 586576 586576 Flowers, Henry, of Wytham, husbandman 1
4174032 2086369 2086369 defendant Rodes John husbandman 586576 586576 Rodes, John, of Wytham, husbandman 1
4190639 2092289 2092289 defendant Jolly Walter yeoman 586576 586576 Jolly, Walter, of Wytham, tailor, or of Laxden, yeoman 0
4198340 2094970 2094970 defendant Songer Rook gent 586576 586576 Songer, Rook, of Wytham, gent 0
4236180 2108223 2108223 defendant Lowe Jerome yeoman 586576 586576 Lowe, Jerome, of Wytham, yeoman 1
4236181 2108223 2108223 defendant Archer Nicholas yeoman 586576 586576 Archer, Nicholas, of Wytham, yeoman 2
4279863 2122870 2122870 defendant Snow Peter, junior butcher 586576 586576 Snow, Peter, junior, of Wytham, butcher 3
4281412 2123404 2123404 defendant Johnson John husbandman 586576 586576 Johnson, John, of Wytham, husbandman 1
4283041 2123967 2123967 defendant Ferne William innholder 586576 586576 Ferne, William, of Wytham, innholder 1
4283042 2123967 2123967 defendant Havan William yeoman 586576 586576 Havan, William, of Wytham, yeoman 2
4283046 2123968 2123968 defendant Johnson John husbandman 586576 586576 Johnson, John, of Wytham, husbandman 1
4283050 2123969 2123969 defendant Kyteley Michael yeoman 586576 586576 Kyteley, Michael, of Wytham, yeoman 0
4290756 2126752 2126752 defendant Parkes Zachary yeoman 586576 586576 Parkes, Zachary, of Wytham, yeoman 0
4290757 2126752 2126752 defendant Raven Christopher husbandman 586576 586576 Raven, Christopher, of Wytham, husbandman 1
4426196 2172997 2172997 plaintiff Neweman John   586576 586576 Neweman, John, of Wytham 0
4467878 2190635 2190635 defendant Clerk Walter   586576 586576 Clerk, Walter, of Wytham 0
4496681 2199629 2199629 defendant Parys Walter de   586576 586576 Parys, Walter de, of Wytham 1
4503297 2201600 2201600 plaintiff Parys Walter   586576 586576 Parys, Walter, of Wytham, on his own account 0
4521103 2206941 2206941 defendant Maygood William   586576 586576 Maygood, William, of Wytham 0
4521150 2206952 2206952 defendant Maygood William   586576 586576 Maygood, William, of Wytham 0
4521153 2206952 2206952 defendant Godeyer William   586576 586576 Godeyer, William, of Wytham 3
4523824 2207781 2207781 defendant Herde John (legal representative) 586576 586576 Herde, John, of Wytham, executors of 0
4523827 2207781 2207781 defendant Herde Alice   586576 586576 Herde, Alice, of Wytham, formerly wife of John 3
4523828 2207781 2207781 defendant Herde John   586576 586576 Herde, John, of Wytham 4
4524491 2207998 2207998 plaintiff Holtate John (legal representative) 586576 586576 Holtate, John, of Wytham, vicar, administrator of 0
4541683 2213294 2213294 defendant Millere John skinner 586576 586576 Millere, John, of wytham, skinner 0
4548923 2215595 2215595 defendant Draper Roger   586576 586576 Draper, Roger, of Wytham 0
4562412 2219803 2219803 plaintiff Fancelon Roger   586576 586576 Fancelon, Roger, of Wytham 4
4578697 2224827 2224827 plaintiff Ounseby John   586576 586576 Ounseby, John, of Wytham 1
4606493 2233141 2233141 defendant Ballard John   586576 586576 Ballard, John, of Wytham 1
4616394 2236122 2236122 plaintiff Frende John   586576 586576 Frende, John, of Wytham 0
4618765 2236871 2236871 defendant Byrcham John   586576 586576 Byrcham, John, of Wytham 6
4629856 2240263 2240263 defendant Maygood William   586576 586576 Maygood, William, of Wytham 0
4629859 2240263 2240263 defendant Cook John   586576 586576 Cook, John, of Wytham 3
4634463 2241627 2241627 defendant Warner John   586576 586576 Warner, John, of Wytham 0
4641807 2243704 2243704 defendant Gaze or Gaye Richard   586576 586576 Gaze or Gaye, Richard, of Wytham 0
4643701 2244258 2244258 defendant Maygood (illegible)   586576 586576 Maygood, _, of Wytham 0
4649067 2245774 2245774 defendant Dyer William   586576 586576 Dyer, William, of Wytham 3
4654852 2247395 2247395 plaintiff Bowyere Roger   586576 586576 Bowyere, Roger, of Wytham 0
4654853 2247395 2247395 defendant Lylye Geoffrey yeoman 586576 586576 Lylye, Geoffrey, of Wytham, yeoman 0
4658083 2248409 2248409 defendant Ronyngton or Rovyngton Robert husbandman 586576 586576 Ronyngton or Rovyngton, Robert, of Wytham, husbandman 0
4659364 2248789 2248789 defendant Bryd Edmund butcher 586576 586576 Bryd, Edmund, of Wytham, butcher 0
4673330 2257296 2257296 defendant Smyth Henry husbandman 586576 586576 Smyth, Henry, of Wytham, husbandman 2
4674470 2257625 2257625 plaintiff Dyer William   586576 586576 Dyer, William, of Wytham 0
4674472 2257626 2257626 plaintiff Dyer William   586576 586576 Dyer, William, of Wytham 0
4685702 2261117 2261117 defendant Pye John butcher 586576 586576 Pye, John, of Wytham, butcher 0
4698951 2265148 2265148 defendant Buschsthe John, sen   586576 586576 Buschsthe, John, sen, of Wytham 0
4701057 2265737 2265737 plaintiff Frende John   586576 586576 Frende, John, of Wytham 0
4721804 2272153 2272153 plaintiff Child Thomas   586576 586576 Child, Thomas, of Wytham 0
4722970 2272498 2272498 plaintiff Rykedon Robert   586576 586576 Rykedon, Robert, of Wytham 2
4722975 2272499 2272499 plaintiff Rykedon Robert   586576 586576 Rykedon, Robert, of Wytham 2
4722983 2272500 2272500 plaintiff Rykedon Robert   586576 586576 Rykedon, Robert, of Wytham 2
4722992 2272501 2272501 plaintiff Rykedon Robert   586576 586576 Rykedon, Robert, of Wytham 2
4724088 2272829 2272829 defendant Maygood William husbandman 586576 586576 Maygood, William, of Wytham, husbandman 3
4725241 2273187 2273187 plaintiff Frende John   586576 586576 Frende, John, of Wytham 0
4730352 2274693 2274693 defendant atte Wode William   586576 586576 atte Wode, William, of Wytham, net drovere or cattle driver 0
4730941 2274876 2274876 defendant atte Wode John husbandman 586576 586576 atte Wode, John, of Wytham, husbandman 0
4730942 2274876 2274876 defendant Maygood William husbandman 586576 586576 Maygood, William, of Wytham, husbandman 1
4733955 2275805 2275805 defendant Mason William   586576 586576 Mason, William, of Wytham, mason 2
4734946 2276085 2276085 defendant Herde Thomas husbandman 586576 586576 Herde, Thomas, of Wytham, husbandman 1
4734948 2276085 2276085 defendant Mellere William husbandman 586576 586576 Mellere, William, of Wytham, husbandman 3

Next page

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