names

177 rows where place_id = 592447

✎ 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
3603046 1868620 1868620 defendant Meller William (legal representative) 592447 592447 Meller, William, of Wrotham, executor of Taylour, Walter, of Wrotham, executrix of 0
3607717 1870067 1870067 defendant Grene Robert tiler 592447 592447 Grene, Robert, of Wrotham, tiler 0
3609555 1870653 1870653 defendant Pekham Reginald gent 592447 592447 Pekham, Reginald, of Wrotham, gent 0
3633347 1905244 1905244 defendant Holmewode Robert husbandman 592447 592447 Holmewode, Robert, of Wrotham, husbandman 0
3641863 1907905 1907905 defendant Wyseman Robert husbandman 592447 592447 Wyseman, Robert, of Wrotham, husbandman 2
3648737 1909991 1909991 defendant Chipsted William husbandman 592447 592447 Chipsted, William, of Wrotham, husbandman 0
3651191 1910739 1910739 defendant Pecham Reginald gent 592447 592447 Pecham, Reginald, of Wrotham, gent 0
3654933 1911804 1911804 defendant Miller Richard husbandman 592447 592447 Miller, Richard, of Wrotham, husbandman 0
3660202 1913452 1913452 defendant Afen John husbandman 592447 592447 Afen, John, of Wrotham, husbandman 0
3684360 1921240 1921240 defendant Terry Robert husbandman 592447 592447 Terry, Robert, of Wrotham, husbandman 1
3693978 1924318 1924318 defendant Jetour John husbandman 592447 592447 Jetour, John, of Wrotham, husbandman 4
3716528 1931465 1931465 defendant Pekham Reginald gent 592447 592447 Pekham, Reginald, of Wrotham, gent 0
3741889 1939328 1939328 defendant Hastlyn William yeoman 592447 592447 Hastlyn, William, of Wrotham, yeoman 0
3754266 1943286 1943286 defendant Hastlyn William yeoman 592447 592447 Hastlyn, William, of Wrotham, yeoman 0
3772347 1949037 1949037 defendant Edmede John yeoman 592447 592447 Edmede, John, of Wrotham, yeoman 0
3790793 1954947 1954947 defendant Hamewode Joan widow 592447 592447 Hamewode, Joan, of Wrotham, widow 4
3790799 1954948 1954948 defendant Hamewode Joan widow 592447 592447 Hamewode, Joan, of Wrotham, widow 4
3790805 1954949 1954949 defendant Homewode Joan widow 592447 592447 Homewode, Joan, of Wrotham, widow 4
3790811 1954950 1954950 defendant Homewode Joan widow 592447 592447 Homewode, Joan, of Wrotham, widow 4
3892218 1987647 1987647 defendant Grannesden John husbandman 592447 592447 Grannesden, John, of Wrotham, husbandman 0
3896397 1989002 1989002 defendant Myller Richard yeoman 592447 592447 Myller, Richard, of Wrotham, yeoman 2
3968646 2013673 2013673 plaintiff Clerke William gent 592447 592447 Clerke, William, of Wrotham, gent 0
4004625 2026430 2026430 defendant Chownyng alias Gregory Christopher yeoman 592447 592447 Chownyng alias Gregory, Christopher, of Wrotham, yeoman 0
4004626 2026430 2026430 defendant Chownyng alias Gregory Thomas husbandman 592447 592447 Chownyng alias Gregory, Thomas, of Wrotham, husbandman 1
4004627 2026430 2026430 defendant Warde William butcher 592447 592447 Warde, William, of Wrotham, butcher 2
4050626 2042654 2042654 defendant Skynner John husbandman 592447 592447 Skynner, John, of Wrotham, husbandman 0
4062029 2046704 2046704 defendant Palmer Richard yeoman 592447 592447 Palmer, Richard, of Wrotham, yeoman 1
4073214 2050711 2050711 plaintiff Petley Joan widow 592447 592447 Petley, Joan, of Wrotham, widow 0
4135252 2072927 2072927 defendant Woodgate Edward yeoman 592447 592447 Woodgate, Edward, of Wrotham, yeoman 1
4136378 2073355 2073355 defendant Swanne Silvester yeoman 592447 592447 Swanne, Silvester, of Wrotham, yeoman 0
4136379 2073355 2073355 defendant Brysenden Thomas miller 592447 592447 Brysenden, Thomas, of Wrotham, miller 1
4137005 2073584 2073584 defendant Osmere John butcher 592447 592447 Osmere, John, of Wrotham, butcher 0
4143735 2075968 2075968 defendant Woodgate Edward clothier 592447 592447 Woodgate, Edward, of Wrotham, clothier 0
4182541 2089373 2089373 defendant Brissenden Thomas miller 592447 592447 Brissenden, Thomas, of Wrotham, miller 0
4380543 2158153 2158153 defendant Staly William husbandman 592447 592447 Staly, William, of Wrotham, husbandman 0
4380544 2158153 2158153 defendant Staly Walter husbandman 592447 592447 Staly, Walter, of Wrotham, husbandman 1
4380545 2158153 2158153 defendant Staly Emma spinster 592447 592447 Staly, Emma, of Wrotham, spinster 2
4396447 2163388 2163388 defendant Webbe William yeoman 592447 592447 Webbe, William, of Wrotham, yeoman 0
4402467 2165411 2165411 defendant Polhill Thomas yeoman 592447 592447 Polhill, Thomas, of Wrotham, yeoman 0
4402469 2165411 2165411 defendant Chownynge Thomas yeoman 592447 592447 Chownynge, Thomas, of Wrotham, yeoman 2
4472117 2191946 2191946 defendant Bokynham Robert de   592447 592447 Bokynham, Robert de, of Wrotham 0
4490678 2197784 2197784 defendant Cook Robert   592447 592447 Cook, Robert, of Wrotham 1
4491883 2198142 2198142 plaintiff Wryght Thomas   592447 592447 Wryght, Thomas, of Wrotham 0
4491884 2198142 2198142 defendant Swyft Alan   592447 592447 Swyft, Alan, of Wrotham 0
4492974 2198505 2198505 defendant Spynney Richard   592447 592447 Spynney, Richard, of Wrotham, vicar 2
4494014 2198815 2198815 defendant Choun Richard   592447 592447 Choun, Richard, of Wrotham 0
4494390 2198940 2198940 defendant atte Lee John   592447 592447 atte Lee, John, of Wrotham 0
4503422 2201640 2201640 defendant Fuller William   592447 592447 Fuller, William, of Wrotham 1
4510858 2203850 2203850 defendant Gode William   592447 592447 Gode, William, of Wrotham 0
4543350 2213807 2213807 defendant Epselon Robert   592447 592447 Epselon, Robert, of Wrotham 3
4554480 2217335 2217335 defendant Lovell John   592447 592447 Lovell, John, of Wrotham 0
4554707 2217398 2217398 defendant Hertland John   592447 592447 Hertland, John, of Wrotham 0
4560815 2219340 2219340 plaintiff Ode James (legal representative) 592447 592447 Ode, James, of Wrotham, executrix of 0
4561605 2219565 2219565 defendant Frenter Hugh   592447 592447 Frenter, Hugh, of Wrotham 1
4561606 2219565 2219565 defendant Gronger Simon   592447 592447 Gronger, Simon, of Wrotham 2
4561607 2219565 2219565 defendant Fulllere William   592447 592447 Fulllere, William, of Wrotham 3
4561608 2219565 2219565 defendant Wylelot Alan   592447 592447 Wylelot, Alan, of Wrotham 4
4561609 2219565 2219565 defendant Asshe Nicholas   592447 592447 Asshe, Nicholas, of Wrotham 5
4569644 2222088 2222088 defendant Bertulf John   592447 592447 Bertulf, John, of Wrotham 1
4570479 2222341 2222341 defendant Adames John   592447 592447 Adames, John, of Wrotham 1
4572593 2222963 2222963 defendant Croweherst Ellis   592447 592447 Croweherst, Ellis, of Wrotham 0
4572595 2222963 2222963 defendant Mellere William   592447 592447 Mellere, William, of Wrotham 2
4579037 2224922 2224922 defendant Lambyn Peter   592447 592447 Lambyn, Peter, of Wrotham 4
4584764 2226659 2226659 defendant Yonge John   592447 592447 Yonge, John, of Wrotham 1
4586866 2227292 2227292 defendant Neysell John   592447 592447 Neysell, John, of Wrotham 0
4586867 2227292 2227292 defendant Godwyne Andrew   592447 592447 Godwyne, Andrew, of Wrotham 1
4586997 2227335 2227335 defendant Nysell John   592447 592447 Nysell, John, of Wrotham 0
4586998 2227335 2227335 defendant Godewyne Andrew   592447 592447 Godewyne, Andrew, of Wrotham 1
4588609 2227815 2227815 plaintiff Kyng John   592447 592447 Kyng, John, of Wrotham 0
4589850 2228191 2228191 plaintiff Lovell John   592447 592447 Lovell, John, of Wrotham 0
4589859 2228192 2228192 defendant Godwyne Andrew   592447 592447 Godwyne, Andrew, of Wrotham 0
4589866 2228194 2228194 defendant Pulter John   592447 592447 Pulter, John, of Wrotham 1
4593640 2229285 2229285 defendant Absolon Robert   592447 592447 Absolon, Robert, of Wrotham 0
4601685 2231745 2231745 defendant Apselyn Robert   592447 592447 Apselyn, Robert, of Wrotham 1
4601687 2231745 2231745 defendant Godewyn Andrew   592447 592447 Godewyn, Andrew, of Wrotham 3
4601690 2231746 2231746 defendant Apselyn Robert   592447 592447 Apselyn, Robert, of Wrotham 1
4601692 2231746 2231746 defendant Godewyn Andrew   592447 592447 Godewyn, Andrew, of Wrotham 3
4610224 2234281 2234281 defendant Clerk Thomas   592447 592447 Clerk, Thomas, of Wrotham 0
4610226 2234281 2234281 defendant Fullere Walter   592447 592447 Fullere, Walter, of Wrotham 2
4610228 2234282 2234282 defendant Clerk Thomas   592447 592447 Clerk,Thomas, of Wrotham 0
4610230 2234282 2234282 defendant Fullere Walter   592447 592447 Fullere, Walter, of Wrotham 2
4611542 2234670 2234670 defendant Barbour Thomas   592447 592447 Barbour, Thomas, of Wrotham 0
4613948 2235375 2235375 defendant Bacheler John (legal representative) 592447 592447 Bacheler, John, of Wrotham, executrix of 0
4651618 2246500 2246500 defendant Kyng John husbandman 592447 592447 Kyng, John, of Wrotham, husbandman 0
4651702 2246506 2246506 defendant Barbour Thomas husbandman 592447 592447 Barbour, Thomas, of Wrotham, husbandman 0
4653455 2247011 2247011 defendant Choune Richard thatcher 592447 592447 Choune, Richard, of Wrotham, thatcher 0
4657554 2248254 2248254 defendant Dowesyng Henry husbandman 592447 592447 Dowesyng, Henry, of Wrotham, husbandman 0
4692982 2263316 2263316 defendant Michel Simon   592447 592447 Michel, Simon, of Wrotham, wheel wright 0
4692984 2263317 2263317 defendant Bette William husbandman 592447 592447 Bette, William, of Wrotham, husbandman 0
4697628 2264747 2264747 defendant Lambyn Peter husbandman 592447 592447 Lambyn, Peter, of Wrotham, husbandman 2
4722542 2272364 2272364 defendant Barbour Thomas yeoman 592447 592447 Barbour, Thomas, of Wrotham, yeoman 0
4722543 2272364 2272364 defendant Lambyn Peter husbandman 592447 592447 Lambyn, Peter, of Wrotham, husbandman 1
4731603 2275076 2275076 defendant Hawele William clerk 592447 592447 Hawele, William, of Wrotham, clerk 0
4749699 2280396 2280396 defendant Croweherst Richard husbandman 592447 592447 Croweherst, Richard, of Wrotham, husbandman 0
4752778 2281268 2281268 defendant atte Lee Wilelma widow 592447 592447 atte Lee, Wilelma, of Wrotham, widow 2
4804466 2297582 2297582 defendant Wrong Stephen smith 592447 592447 Wrong, Stephen, of Wrotham, smith 0
4805656 2297977 2297977 defendant Salman John carpenter 592447 592447 Salman, John, of Wrotham, carpenter 0
4810092 2299309 2299309 defendant Morcok John chaplain 592447 592447 Morcok, John, of Wrotham, chaplain 0
4823015 2303281 2303281 defendant Mellere Edward butcher 592447 592447 Mellere, Edward, of Wrotham, butcher 0
4845954 2310241 2310241 defendant Wronger Stephen smith 592447 592447 Wronger, Stephen, of Wrotham, smith 1

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