names

57 rows where place_id = 592770

✎ 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
3608863 1870428 1870428 defendant Forde John husbandman 592770 592770 Forde, John, of Eynesford, husbandman 1
3665879 1915263 1915263 defendant Fyssher John smith 592770 592770 Fyssher, John, of Eynesford, smith 0
3679644 1919700 1919700 defendant Marshall William husbandman 592770 592770 Marshall, William, of Eynesford, husbandman 4
3713404 1930507 1930507 defendant Woldregge Robert husbandman 592770 592770 Woldregge, Robert, of Eynesford, husbandman 0
3728874 1935279 1935279 defendant Woldregge Robert husbandman 592770 592770 Woldregge, Robert, of Eynesford, husbandman 0
3728943 1935298 1935298 defendant Woldregge Robert husbandman 592770 592770 Woldregge, Robert, of Eynesford, husbandman 0
4483529 2195535 2195535 defendant Lye Robert   592770 592770 Lye, Robert, of Eynesford 5
4505057 2202114 2202114 defendant Ferrour John   592770 592770 Ferrour, John, of Eynesford 0
4525492 2208302 2208302 defendant Forster John   592770 592770 Forster, John, of Eynesford, vicar 4
4525498 2208303 2208303 defendant Forster John   592770 592770 Forster, John, of Eynesford, vicar 4
4552430 2216714 2216714 plaintiff Ferrour John   592770 592770 Ferrour, John, of Eynesford 0
4552433 2216714 2216714 defendant Henkesman John   592770 592770 Henkesman, John, of Eynesford 2
4617141 2236370 2236370 defendant Pauley John esq 592770 592770 Pauley, John, of Eynesford, esq 0
4732624 2275380 2275380 defendant Parkere Ralph husbandman 592770 592770 Parkere, Ralph, of Eynesford, husbandman 0
4732625 2275380 2275380 defendant Reys Richard husbandman 592770 592770 Reys, Richard, of Eynesford, husbandman 1
4758591 2283065 2283065 defendant Dowsyng Robert husbandman 592770 592770 Dowsyng, Robert, of Eynesford, husbandman 0
4871454 2318035 2318035 defendant Holynden Thomas laborer 592770 592770 Holynden, Thomas, of Eynesford, laborer 2
4929736 2335718 2335718 defendant Sybbyng Nicholas husbandman 592770 592770 Sybbyng, Nicholas, of Eynesford, husbandman 0
4990941 2354180 2354180 defendant Rippele Richard   592770 592770 Rippele, Richard, of Eynesford, vicar 0
5001342 2357275 2357275 defendant Sibbyng Nicholas husbandman 592770 592770 Sibbyng, Nicholas, of Eynesford, husbandman 0
5001343 2357275 2357275 defendant Miche John husbandman 592770 592770 Miche, John, of Eynesford, husbandman 1
5001344 2357275 2357275 defendant Lek John husbandman 592770 592770 Lek, John, of Eynesford, husbandman 2
5005640 2358548 2358548 defendant Sybbynge Nicholas husbandman 592770 592770 Sybbynge, Nicholas, of eynesford, husbandman 1
5032023 2366239 2366239 defendant Sybbyng Nicholas husbandman 592770 592770 Sybbyng, Nicholas, of Eynesford, husbandman 1
5048653 2371235 2371235 defendant Hedere John   592770 592770 Hedere, John, of Eynesford, husbandman, son of Nicholas Hedere 1
5048662 2371236 2371236 defendant Hodere Robert husbandman 592770 592770 Hodere, Robert, of Eynesford, husbandman 4
5079222 2380278 2380278 defendant Parker Thomas, junior husbandman 592770 592770 Parker, Thomas, junior, of Eynesford, husbandman 1
5096242 2385338 2385338 defendant Burwassh John gent 592770 592770 Burwassh, John, of Eynesford, gent 0
5120390 2392390 2392390 defendant Burwassh John gent 592770 592770 Burwassh, John, of Eynesford, gent 0
5223885 2422671 2422671 defendant Wassheners or Wasshevers Thomas laborer 592770 592770 Wassheners or Wasshevers, Thomas, of Eynesford, laborer 0
5223886 2422671 2422671 defendant Holynden William laborer 592770 592770 Holynden, William, of Eynesford, laborer 1
5226937 2423536 2423536 defendant Dobson Robert husbandman 592770 592770 Dobson, Robert, of Eynesford, husbandman 2
5287570 2441390 2441390 defendant Syngleton Chrtistopher yeoman 592770 592770 Syngleton, Chrtistopher, of Eynesford, yeoman 0
5300866 2445221 2445221 defendant Martyn John esq 592770 592770 Martyn, John, of Eynesford, esq 0
5305603 2446683 2446683 defendant Gyldwyn Robert laborer 592770 592770 Gyldwyn, Robert, of Eynesford, laborer 0
5307362 2447205 2447205 defendant Martyn John gent 592770 592770 Martyn, John, of Eynesford, gent 0
5356867 2462207 2462207 defendant Cordener Nicholas cordwainer 592770 592770 Cordener, Nicholas, of Eynesford, cordwainer 0
5385670 2470972 2470972 defendant Shynggylton Christopher yeoman 592770 592770 Shynggylton, Christopher, of Eynesford, yeoman 0
5389621 2472093 2472093 defendant Sybbyng Robert yeoman 592770 592770 Sybbyng, Robert, of Eynesford, yeoman 2
5393490 2473194 2473194 defendant Williams John yeoman 592770 592770 Williams, John, of Eynesford, yeoman 0
5402356 2475747 2475747 defendant Bybbyng Robert yeoman 592770 592770 Bybbyng, Robert, of Eynesford, yeoman 2
5402973 2475932 2475932 defendant Beke Robert clerk 592770 592770 Beke, Robert, of Eynesford, clerk 0
5406648 2476969 2476969 defendant Williams John yeoman 592770 592770 Williams, John, of Eynesford, yeoman 0
5415297 2479513 2479513 defendant Sybbyng Robert yeoman 592770 592770 Sybbyng, Robert, of Eynesford, yeoman 2
5415960 2479706 2479706 defendant Beke Robert clerk 592770 592770 Beke, Robert, of Eynesford, clerk 0
5419804 2480838 2480838 defendant Williams John yeoman 592770 592770 Williams, John, of Eynesford, yeoman 0
5423043 2481843 2481843 defendant Holynden Nicholas husbandman 592770 592770 Holynden, Nicholas, of Eynesford, husbandman 0
5437168 2486052 2486052 defendant Holynden Nicholas husbandman 592770 592770 Holynden, Nicholas, of Eynesford, husbandman 0
5442508 2487671 2487671 defendant Holynden Nicholas husbandman 592770 592770 Holynden, Nicholas, of Eynesford, husbandman 0
5451354 2490281 2490281 defendant H_don Nicholas husbandman 592770 592770 H_don, Nicholas, of Eynesford, husbandman 0
5489888 2501861 2501861 defendant Holynden Nicholas husbandman 592770 592770 Holynden, Nicholas, of Eynesford, husbandman 0
5490256 2501972 2501972 defendant Holynden Nicholas husbandman 592770 592770 Holynden, Nicholas, of Eynesford, husbandman 0
5498756 2504570 2504570 defendant Beke Robert clerk 592770 592770 Beke, Robert, of Eynesford, clerk 1
5513434 2509049 2509049 defendant Forde John yeoman 592770 592770 Forde, John, of Eynesford, yeoman 1
5536395 2515872 2515872 defendant Jetour Thomas yeoman 592770 592770 Jetour, Thomas, of Eynesford, yeoman 0
5586472 2530807 2530807 defendant Faireman Walter husbandman 592770 592770 Faireman, Walter, of Eynesford, husbandman 0
5599311 2534666 2534666 defendant Wryght William laborer 592770 592770 Wryght, William, of Eynesford, laborer 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);