names

59 rows where place_id = 593570

✎ 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
3612398 1871505 1871505 defendant Fyssher Henry beer brewer 593570 593570 Fyssher, Henry, of Woxbrigge, beer brewer 1
3612399 1871505 1871505 defendant Sharpp Henry yeoman 593570 593570 Sharpp, Henry, of Woxbrigge, yeoman 2
4553040 2216892 2216892 plaintiff Frundale John   593570 593570 Frundale, John, of Woxbrigge 0
4553041 2216892 2216892 defendant Hore David   593570 593570 Hore, David, of Woxbrigge 0
4645275 2244687 2244687 defendant Long John   593570 593570 Long, John, of Woxbrigge 3
4645283 2244688 2244688 defendant Long John   593570 593570 Long, John, of Woxbrigge 3
4674710 2257701 2257701 defendant Staundon John husbandman 593570 593570 Staundon, John, of Woxbrigge, husbandman 1
4681976 2259979 2259979 defendant Talbot Nicholas husbandman 593570 593570 Talbot, Nicholas, of Woxbrigge, husbandman 0
4730224 2274655 2274655 defendant Cadesden Robert yeoman 593570 593570 Cadesden, Robert, of Woxbrigge, yeoman 1
4793733 2294158 2294158 defendant Stokkynge Thomas yeoman 593570 593570 Stokkynge, Thomas, of Woxbrigge, yeoman 0
4896241 2325485 2325485 defendant Jolyf Roger carpenter 593570 593570 Jolyf, Roger, of Woxbrigge, carpenter 0
4938715 2338494 2338494 defendant Payn John ostler 593570 593570 Payn, John, of Woxbrigge, ostler 0
4964528 2346298 2346298 defendant Spene or Speve Thomas husbandman 593570 593570 Spene or Speve, Thomas, of Woxbrigge, husbandman 0
4980926 2351231 2351231 plaintiff Staundon Julia (legal representative) 593570 593570 Staundon, Julia, of Woxbrigge, administrator of 0
4980929 2351231 2351231 defendant Ra- John husbandman 593570 593570 Ra-, John, of Woxbrigge, husbandman 1
4980930 2351232 2351232 plaintiff Staundon Julian (legal representative) 593570 593570 Staundon, Julian, of Woxbrigge, administrator of 0
5064880 2376027 2376027 defendant Sprott William yeoman 593570 593570 Sprott, William, of Woxbrigge, yeoman 5
5065446 2376199 2376199 defendant George John ostler 593570 593570 George, John, of Woxbrigge, ostler 3
5093333 2384447 2384447 defendant Heryng William yeoman 593570 593570 Heryng, William, of Woxbrigge, yeoman 0
5103487 2387447 2387447 defendant Pynke John baker 593570 593570 Pynke, John, of Woxbrigge, baker 1
5103492 2387448 2387448 defendant Pynke John baker 593570 593570 Pynke, John, of Woxbrigge, baker 1
5211765 2419185 2419185 defendant Kympton Walter yeoman 593570 593570 Kympton, Walter, of Woxbrigge, yeoman 2
5215389 2420231 2420231 defendant Clyfford Stephen yeoman 593570 593570 Clyfford, Stephen, of Woxbrigge, yeoman 0
5215390 2420231 2420231 defendant Ventham alias Iremonger Thomas baker 593570 593570 Ventham alias Iremonger, Thomas, of Woxbrigge, baker 1
5215392 2420231 2420231 defendant Botiller William tiler 593570 593570 Botiller, William, of Woxbrigge, tiler 3
5215393 2420231 2420231 defendant Clyfford William yeoman 593570 593570 Clyfford, William, of Woxbrigge, yeoman 4
5219539 2421445 2421445 plaintiff Hert John chapman 593570 593570 Hert, John, of Woxbrigge, chapman 0
5221625 2422021 2422021 defendant Clyfford Stephen miller 593570 593570 Clyfford, Stephen, of Woxbrigge, miller 2
5222076 2422158 2422158 defendant Flye John cordwainer 593570 593570 Flye, John, of Woxbrigge, cordwainer 3
5223131 2422477 2422477 defendant Herte John chapman 593570 593570 Herte, John, of Woxbrigge, chapman 0
5223672 2422609 2422609 defendant Colyn William barber 593570 593570 Colyn, William, of Woxbrigge, barber 0
5229143 2424129 2424129 defendant Queyntrell Richard husbandman 593570 593570 Queyntrell, Richard, of Woxbrigge, husbandman 0
5229144 2424129 2424129 defendant Clokton Richard husbandman 593570 593570 Clokton, Richard, of Woxbrigge, husbandman 1
5229145 2424129 2424129 defendant Dawe Richard husbandman 593570 593570 Dawe, Richard, of Woxbrigge, husbandman 2
5230505 2424538 2424538 defendant Norys Thomas butcher 593570 593570 Norys, Thomas, of Woxbrigge, butcher 1
5257132 2432363 2432363 defendant Milton Joan widow 593570 593570 Milton, Joan, of Woxbrigge, widow 0
5260924 2433540 2433540 defendant Kynton Walter yeoman 593570 593570 Kynton, Walter, of Woxbrigge, yeoman 1
5300587 2445138 2445138 defendant Middelton John yeoman 593570 593570 Middelton, John, of Woxbrigge, yeoman 0
5300588 2445138 2445138 defendant Kenyngis Ivan yeoman 593570 593570 Kenyngis, Ivan, of Woxbrigge, yeoman 1
5300589 2445138 2445138 defendant Butler William husbandman 593570 593570 Butler, William, of Woxbrigge, husbandman 2
5300592 2445139 2445139 defendant Strech Nicholas tailor 593570 593570 Strech, Nicholas, of Woxbrigge, tailor 0
5300593 2445139 2445139 defendant Cryppys John chapman 593570 593570 Cryppys, John, of Woxbrigge, chapman 1
5300594 2445139 2445139 defendant Cryppys Robert chapman 593570 593570 Cryppys, Robert, of Woxbrigge, chapman 2
5303357 2446001 2446001 defendant Hyde William yeoman 593570 593570 Hyde, William, of Woxbrigge, yeoman 0
5303358 2446001 2446001 defendant Webbe Nicholas baker 593570 593570 Webbe, Nicholas, of Woxbrigge, baker 1
5310365 2448134 2448134 defendant Aunesley Jacob Jacob gent 593570 593570 Aunesley, Jacob Jacob, of Woxbrigge, gent 1
5310368 2448135 2448135 defendant Annesley James gent 593570 593570 Annesley, James, of Woxbrigge, gent 1
5315722 2449767 2449767 defendant George Richard yeoman 593570 593570 George, Richard, of Woxbrigge, yeoman 0
5337170 2456188 2456188 defendant Robyns Richard fuller 593570 593570 Robyns, Richard, of Woxbrigge, fuller 2
5337171 2456188 2456188 defendant Draper Thomas draper 593570 593570 Draper, Thomas, of Woxbrigge, draper 3
5385712 2470984 2470984 defendant Augere Peter husbandman 593570 593570 Augere, Peter, of Woxbrigge, husbandman 0
5385865 2471031 2471031 defendant Johnson Henry shoemaker 593570 593570 Johnson, Henry, of Woxbrigge, shoemaker 0
5502969 2505839 2505839 defendant Stodeley Miles tailor 593570 593570 Stodeley, Miles, of Woxbrigge, tailor 0
5502970 2505839 2505839 defendant Bailly William husbandman 593570 593570 Bailly, William, of Woxbrigge, husbandman 1
5534469 2515326 2515326 defendant Pese Thomas yeoman 593570 593570 Pese, Thomas, of Woxbrigge, yeoman 0
5534472 2515327 2515327 defendant Veyser John yeoman 593570 593570 Veyser, John, of Woxbrigge, yeoman 0
5546825 2519075 2519075 plaintiff Pese Thomas yeoman 593570 593570 Pese, Thomas, of Woxbrigge, yeoman 1
5546829 2519076 2519076 plaintiff Pese Thomas yeoman 593570 593570 Pese, Thomas, of Woxbrigge, yeoman 1
5568670 2525387 2525387 defendant Wood Hugh yeoman 593570 593570 Wood, Hugh, of Woxbrigge, yeoman 1

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