names

53 rows where place_id = 586510

✎ 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
3588914 1864182 1864182 defendant Sparowe John clothier 586510 586510 Sparowe, John, of Neubury, Berks, clothier 0
3588916 1864183 1864183 defendant Sparowe John clothier 586510 586510 Sparowe, John, of Neubury, Berks, clothier 0
3588918 1864184 1864184 defendant Benet Thomas hosier 586510 586510 Benet, Thomas, of Neubury, Berks, hosier 0
3588923 1864186 1864186 defendant Benet William husbandman 586510 586510 Benet, William, of Neubury, Berks, husbandman 0
3588929 1864189 1864189 defendant Benet Thomas hosier 586510 586510 Benet, Thomas, of Neubury, Berks, hosier 0
3588932 1864190 1864190 defendant Benet Thomas hosier 586510 586510 Benet, Thomas, of Neubury, Berks, hosier 0
3623711 1874949 1874949 plaintiff Smyth William clothier 586510 586510 Smyth, William, of Neubury, Berks, clothier 0
3886314 1985678 1985678 plaintiff Knyght John gent 586510 586510 Knyght, John, of Neubury, Berks, gent 1
4673877 2257446 2257446 defendant Sadeler William husbandman 586510 586510 Sadeler, William, of Neubury, Berks, husbandman 3
4683736 2260514 2260514 defendant Goldsmith John butcher 586510 586510 Goldsmith, John, of Neubury, Berks, butcher 3
4747974 2279916 2279916 defendant Langeryche Robert clerk 586510 586510 Langeryche, Robert, of Neubury, Berks, clerk 0
4747976 2279917 2279917 defendant Langeryche Robert clerk 586510 586510 Langeryche, Robert, of Neubury, Berks, clerk 0
4753052 2281342 2281342 defendant Hereward Thomas chapman 586510 586510 Hereward, Thomas, of Neubury, Berks, chapman 3
4796986 2295215 2295215 defendant Messenger Nicholas yeoman 586510 586510 Messenger, Nicholas, of Neubury, Berks, ,yeoman 0
4797310 2295331 2295331 defendant Messager Nicholas yeoman 586510 586510 Messager, Nicholas, of Neubury, Berks, yeoman 3
4856121 2313286 2313286 defendant Fairfax Nicholas yeoman 586510 586510 Fairfax, Nicholas, of Neubury, Berks, yeoman 2
4857209 2313641 2313641 defendant Archer William husbandman 586510 586510 Archer, William, of Neubury, Berks, husbandman 0
4861343 2314916 2314916 defendant Sam- John fuller 586510 586510 Sam-, John, of Neubury, Berks, fuller 1
4905849 2328432 2328432 defendant Mumford William dyer 586510 586510 Mumford, William, of Neubury, Berks, dyer 1
4913210 2330630 2330630 defendant Abberbury Richard gent 586510 586510 Abberbury, Richard, of Neubury, Berks, gent 0
4915877 2331460 2331460 defendant Wyard Stephen tanner 586510 586510 Wyard, Stephen, of Neubury, Bersk, tanner 0
4926764 2334793 2334793 defendant Plomer Robert fuller 586510 586510 Plomer, Robert, of Neubury, Berks, fuller 1
4926766 2334793 2334793 defendant Smyth John smith 586510 586510 Smyth, John, of Neubury, Berks, smith 3
4931806 2336334 2336334 defendant Hall William skinner 586510 586510 Hall, William, of Neubury, Berks, skinner 0
4938862 2338545 2338545 defendant Pede William laborer 586510 586510 Pede, William, of Neubury, Berks, laborer 2
4958381 2344473 2344473 defendant Toke Roger shoemaker 586510 586510 Toke, Roger, of Neubury, Berks, shoemaker 0
4971655 2348448 2348448 defendant Baron Richard stainer 586510 586510 Baron, Richard, of Neubury, Berks, stainer 0
5017638 2362034 2362034 plaintiff Chilrey John (legal representative) 586510 586510 Chilrey, John, of Neubury, Berks, clerk, executors of 0
5020472 2362876 2362876 defendant Webbe Robert weaver 586510 586510 Webbe, Robert, of Neubury, Berks, weaver 0
5059308 2374350 2374350 defendant Lone or Love Thomas fuller 586510 586510 Lone or Love, Thomas, of Neubury, Berks, fuller 1
5097058 2385572 2385572 defendant Crede John butcher 586510 586510 Crede, John, of Neubury, Berks, butcher 1
5097198 2385615 2385615 defendant Inglysby John chaplain 586510 586510 (Inglysby, John, of Neubury, Berks, chaplain 1
5131357 2395662 2395662 defendant Bentley Thomas chapman 586510 586510 Bentley, Thomas, of Neubury, Berks, chapman 1
5221882 2422099 2422099 defendant Chansy Thomas gent 586510 586510 Chansy, Thomas, of Neubury, Berks, gent 0
5278333 2438767 2438767 defendant Love or Lone Thomas fuller 586510 586510 Love or Lone, Thomas, of Neubury, Berks, fuller 0
5278335 2438768 2438768 defendant Love Thomas filler 586510 586510 Love, Thomas, of Neubury, Berks, filler 0
5284764 2440562 2440562 defendant Kynge John dyer 586510 586510 Kynge, John, of Neubury, Berks, dyer 0
5288977 2441782 2441782 defendant Neweport John weaver 586510 586510 Neweport, John, of Neubury, Berks, weaver 2
5291177 2442425 2442425 defendant Godard Thomas ostler 586510 586510 Godard, Thomas, of Neubury, Berks, ostler 0
5291182 2442426 2442426 defendant Godard Thomas ostler 586510 586510 Godard, Thomas, of Neubury, Berks, ostler 0
5294723 2443437 2443437 defendant Scathelok Thomas fuller 586510 586510 Scathelok, Thomas, of Neubury, Berks, fuller 1
5294727 2443438 2443438 defendant Scathelok Thomas fuller 586510 586510 Scathelok, Thomas, of Neubury, Berks, fuller 1
5314988 2449535 2449535 defendant Astell Richard skinner 586510 586510 Astell, Richard, of Neubury, Berks, skinner 0
5327987 2453438 2453438 defendant Bocher John courser 586510 586510 Bocher, John, of Neubury, Berks, courser 0
5439154 2486635 2486635 defendant Scarlok John hosier 586510 586510 Scarlok, John, of Neubury, Berks, hosier 0
5493194 2502875 2502875 defendant Smyth William dyer 586510 586510 Smyth, William, of Neubury, Berks, dyer 0
5493199 2502876 2502876 defendant Smyth William dyer 586510 586510 Smyth, William, of Neubury, Berks, dyer 0
5493206 2502877 2502877 defendant Smyth William dyer 586510 586510 Smyth, William, of Neubury, Berks, dyer 0
5511186 2508338 2508338 defendant Bakon John tailor 586510 586510 Bakon, John, of Neubury, Berks, tailor 0
5511189 2508339 2508339 defendant Bakon John tailor 586510 586510 Bakon, John, of Neubury, Berks, tailor 0
5548933 2519727 2519727 defendant Howell William clothman 586510 586510 Howell, William, of Neubury, Berks, clothman 1
5633550 2554491 2554491 defendant Wallyngford Thomas dyer 586510 586510 Wallyngford, Thomas, of Neubury, Berks, dyer 0
5633557 2554492 2554492 defendant Wallyngford Thomas dyer 586510 586510 Wallyngford, Thomas, of Neubury, Berks, dyer 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);